Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to graph the monthly growth, this should be a comparison of the month vs the same month of the previous year.
Appreciate your help
HI,
Try below
Dimension : MONTH
Exp for MoM growth rate;
NUM( (sum({<YEAR={$(=max(YEAR))}>}Salary) -sum({<YEAR={$(=max(YEAR)-1)}>}Salary) )/
sum({<YEAR={$(=max(YEAR))}>}Salary) ,'#,##0.00%')
Thanks, but don't work
'NUM( (sum({<Fecha={"$(=max(Fecha))"}>}Total) /sum({<Fecha={"$(=max(Fecha)-1)"}>}Total) ),'#,##0.00%')'
Please check Fecha format it should be YEAR filed, and what is Total ?? is it a measure?