@btm please chime in on this conversation.
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
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.