Hi tableaurs,
I want to display the aggregated KPI scores by year , quarter and month in the dashboard.
something like this. I want to use filter like this : for year "2018" and filter for quarter in this format "2018 Q1, '2018 Q2', and filter for month ' Janauary 2018'
Kindly help. attached is the superstore dataset .
Hi Adam,
YYYYQ=
STR(YEAR([Order Date]))+'Q'+str(DATEPART('quarter',[Order Date]))
Month YYYY=
DATENAME('month',[Order Date])+' '+str(year([Order Date]))
Please find the attached and mark the answer if helpful for you so that it can help others as well, you can change the format
Thanks,
Ritesh
@RITESH there is nothing inside the workbook you have attached,. pls send again. thanks
Hi Adam,
For Months and quarters calculation should be used
Check the attached workbook
Regards
Ritesh