Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Pro's,
In my data set data available month wise and year wise. Requirement is like displaying the total delay month wise for last 12 months only based on dimension(i.e Month year field) but not with expression using set analysis.
Kindly help to achieve this.
Here in this chart months dec,nov and oct are belongs to 2018 and remaining are of 2019.
Final output will be display like dimensions order(only last 12 months data)
oct 2018
nov 2018
dec 2018
then
Jan2019
feb 2019
and so on..
I believe you would just need to sort by year ascending and then by month ascending.