Fiscal calendar should apply to beast modes

roidna

This feature request appears to go back at least 2 years (!!) as evidenced here:

 

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Fiscal-calendar-in-Beast-Mode/m-p/14187#M1063

 

Currently the fiscal calendar feature is very limiting because formulas are not affected. In our specific use case, we want to be able to report on Monday-Sunday weeks, vs. DOMO's default Saturday-Sunday weeks.

 

The fiscal calendar correctly adjusts week beginning and ending dates as requested, but any formulas designed to calculate week-over-week change are not useful because they still calculate according to the default DOMO week.

JacobFolsom

I agree! One idea for implementation here would be for Domo product to add new custom fiscal calendar variables, so that a user needs to explicitely call it out, such as: 

FISCAL_WEEK()

FISCAL_YEAR()