This content has been marked as final.
Show 2 replies
-
Re: Set Analysis to calculate last day of previous month.
Sunny Talwar Oct 27, 2016 12:15 PM (in response to Giuseppe De Vivo)I think the most ideal way to do this would be to use The As-Of Table
-
Re: Set Analysis to calculate last day of previous month.
Federico Casarotto Oct 27, 2016 12:45 PM (in response to Giuseppe De Vivo)Ciao Giuseppe
simply use three variables:
1. vLastDayPreviousMonth=max( {<Mese={'$(#vMonth)'}, Data=>} Data)
2. vMonth=max(Mese)-1 where Mese is num(month(Data)) as Mese
3. vValuePreviousMonth =sum({< Data ={'$(#vLastDayMonth)'}, Mese=>} MisureX)
In the chart you will create an expression like (sum(MisureX)/vValue)-1
You'll have to select only the month (Mese).
Ciao