Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to get a bar chart to display the rolling last 12 months in order.
My count is case code's where the start date is in the last 12 months.
My dimension is a calculated one of [start month] & [start year] which are calculated at script level as month([start date]) & year([Start date]).
I've tried sorting it in different ways but can't get it to sort in order. Any help would be greatly appreciated.
Use the following expression instead:
=Date(MonthStart(Start),'MMM YYYY')
Preferably this should be added in the script, but it works fine as calculated dimension also.
/HIC
Use the following expression instead:
=Date(MonthStart(Start),'MMM YYYY')
Preferably this should be added in the script, but it works fine as calculated dimension also.
/HIC