I need to display the latest month that may be present in the sheet. Dates are stored in Text format as field name Outage_Month. Values in this field are stored as 11/1/2016,12/1/2016 etc.
I have to display the outage mins for the latest month that may be present at any given point in time.
I used the below dimension in the chart and expression as sum of Mins. This dimension works fine in a text object but when put in a straight chart it should 'Error in calculated dimension'
=if(num(monthstart((max(Outage_Month))))=num(addmonths(monthstart(today()),-1)),monthname(max(Outage_Month)),monthname(AddMonths(today(),-2)))
