This content has been marked as final.
Show 5 replies
-
1. Re: To dipslay, Year, Month, Quarter as aggregated KPI as BIG Number in dashboard
Ritesh Bisht Jan 15, 2019 8:35 PM (in response to Adam Aliz)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
-
KPI_ 292947.twbx 2.3 MB
-
-
2. Re: To dipslay, Year, Month, Quarter as aggregated KPI as BIG Number in dashboard
Adam Aliz Jan 15, 2019 8:50 PM (in response to Ritesh Bisht)@RITESH there is nothing inside the workbook you have attached,. pls send again. thanks
-
4. Re: To dipslay, Year, Month, Quarter as aggregated KPI as BIG Number in dashboard
Ritesh Bisht Jan 15, 2019 9:03 PM (in response to Adam Aliz)Its 2.3 MB there.
-
5. Re: To dipslay, Year, Month, Quarter as aggregated KPI as BIG Number in dashboard
ritesh kodolikar Jan 15, 2019 9:49 PM (in response to Adam Aliz)Hi Adam,
For Months and quarters calculation should be used
Check the attached workbook
Regards
Ritesh
-
KPI.twbx 2.3 MB
-