1 of 1 people found this helpful
I've created something similar using Superstore data:
The date calculation is as follows:
If the order date is in the current quarter, return the month of the order date. Otherwise, return the quarter if the order date is in the current year. If not, return the year of order date.
The color-coding is as follows:
DATETRUNC('quarter',[Order Date])= DATETRUNC('quarter',TODAY())
If the order date is in the current quarter, count as true.
Drill the column pill down to the month ("May 2015") to make the viz shown above.
Hope this helps.
Thanks for your help. Exactly what I needed.