How do I get future data being populated to current year?

yogesh_1 · January 23

I have a requirement to show Next fiscal Year data into Current chosen fiscal year. So if user choses , FY 23, it should show data for Fy24 in 1 column.

Please see below: If FY is selected, then monthly data is shown for current fiscal year.

and similarly NextFy data (Fy+1) is also displayed like below. Please suggest.

	Oct-22	Nov-22	Dec-22
FY	100	200	445
NextFY	150	234	221

GrantSmith · January 23

What I recommend is creating your own date dimension dataset with your defined periods (FY and NextFY). This will allow you to have a single date you can then use in your chart and conditionally use a beast mode to display either FY or Next FY. I've done a writeup in the past on this for period over period analysis you can follow here:

https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons

MichelleH · January 23

@yogesh_1 Is Fiscal Year a column in your dataset or are you using the native date range selector in the card/dashboard? If you don't already, I would look into setting up a Fiscal Calendar on your instance.

yogesh_1 · January 23

@MichelleH YEs its a column already in dataset

GrantSmith · January 23

What I recommend is creating your own date dimension dataset with your defined periods (FY and NextFY). This will allow you to have a single date you can then use in your chart and conditionally use a beast mode to display either FY or Next FY. I've done a writeup in the past on this for period over period analysis you can follow here:

https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons

How do I get future data being populated to current year?

Best Answer

Answers

Categories