Hi Team,
good evening!
I have a dataset where I have the Day column, a Financial week column and a Financial week column.
How to display last 2 quarters data . Each Fiscal quarter starts at different date than the default given in Tableau.
For example -
The Fiscal Quarter Q1 is from July 31st to Oct 29th ,
Q2 is from Oct 30th to Jan28,
and so on
Currently in my dashboard I am showing the last quarter data by using a parameter ( workbook attached).
Wanted to know if there is a way to display the last 2 quarters, considering that the Financial quarter field is a string.
I tried various approaches by splitting the Financial Quarter column and then trying to find the max, -1 but still not working.
Any suggestions would be helpful.
Regards,,
Rishi Saka
Hi Deepak,
Thank you for the solution. I tried it out with a couple of scenarios, It works the way we want it to.
Regards,
Rishi Saka
