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
Hi Ritesh,
I was going through this forum. i need one suggestion from you.
If you go through the month filter, you can view . february is before January. Is it possible to arrange in January, February, March order wise.
The logic :
Month YYYY=
DATENAME('month',[Order Date])+' '+str(year([Order Date])) are making the months unordered like February, January,March 2018. I want them to be sorted in january, February,march
Regards
Dhritiman
Hi Dhritiman,
You Can Create a Custom Date
ex. order date>create>Customdate>Month/Year
Regards
Ritesh Kodolikar