Update Quarters to Match Fiscal Year

Java

Hi all,

 

How can I update the format of my quarters to match our fiscal year? I'm trying to have Jul, Aug, and Sep represented as Q1 / Oct, Nov, and Dec represented as Q2, etc.

 

Is there a beast mode formula for this? Or does this need to be updated under admin settings?

 

Thanks!

GrantSmith

Hi @Java 

You could utilize a fiscal calendar: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/KPI_Card_Building_Part_2%3A_The_Analyzer/Using_A_Fiscal_Calendar

 

Keep in mind, using a fiscal calendar DOES NOT change how DATE functions in Beast modes evaluate.  It only implacts the Date filters in cards.

Java

Thank you! Just submitted a support ticket to get this set up.