Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using Canonical Calendar in my script and need to show only last 12 months . The graph shows missing months when plotted as is but i need to display the graph for only last 12 months. When I try to show last 12 months then the months where there is a blank value is not shown in the graph and is skipped.
I have used the below in the Dimensions.
=if(Month<MonthStart(today()) and Month>monthname(AddMonths(today(),-14)),Month)
Can anybody please help as to what is going wrong in my chart?
Use set analysis filters in the chart expressions rather than a calculated dimension. I also add a month sequence number to my calendars which makes this type of analysis much simpler:
Define the field something like this in your calendar load:
(Year(tmpDate) - 2000) * 12 + Month(tmpDate) as MonthSequence,
Then use this in your expressions with Month as a dimension:
Sum({<MonthSequence = {">=$(=Max(MonthSequence) - 12)"}>} Value)
Turn off suppress zero values to see the 0 value months.