Fiscal calendar in Beast Mode

Reply
Dojo Admin

Re: Fiscal calendar in Beast Mode

@btm please chime in on this conversation.

Thanks!

Dani aka "Mr.Dojo"

Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Dojo Admin

Re: Fiscal calendar in Beast Mode

@Gavatar @btm

 

Can one you advise the thread on this please?

 

Thanks!

Dani aka "Mr.Dojo"

Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
White Belt

Re: Fiscal calendar in Beast Mode

same inquiry here - we align to Fiscal Calendar so would be great to know how it can be done in DOMO

Green Belt

Re: Fiscal calendar in Beast Mode

This thread has not had an update in the past year, but I would really like to have fiscal_month, fiscal_year and fiscal_quarter commands available in beast modes.  The reason that I cannot do this through a join is that I have a large dataset that times out with a fusion (I have added fiscal month, quarter and year to the dataset already) and I need to know the fiscal month/quarter/year of the current date, so I can exclude the current and future months from a card using a beast mode (automatically).  I tried a formula like this to exclude future months and only show completed fiscal months (for any year) and it seems to time out on large datasets:

CASE WHEN RIGHT(max(CONCAT(`fiscal_year`,`fiscal_month`)),2) >= `fiscal_month` THEN 'Exclude'   ELSE 'Include' END

 

 

Thanks,

Josh

Highlighted
Dojo Admin

Re: Fiscal calendar in Beast Mode

Thanks @jstan

 

@Gavatar any update on this ask from our customers?

 

Regards,

Dani aka "Mr.Dojo"

Dojo Admin
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
White Belt

Re: Fiscal calendar in Beast Mode

Bumping this ask - the 'fiscal calendar' setting is currently not useful for us, because we'd like to have a week-over-week % change value displayed in the *card summary*.

 

Currently our week-over-week card summaries appear to be incorrect, because the card summary formula is still calculating off the standard domo week (saturday - sunday) rather than our desired week (monday-sunday). Turning on the fiscal calendar feature in the card thus produces an "incorrect" result.

Announcements
Looking for the latest Dojo Community solutions? Click on the "NEW SOLUTIONS' widget title or go to https://dojo.domo.com/solutions Click here!