I have the data on month on month. I were struct in calculate average of current month vs previous month .
Also i have created the master calendar to get the months as fiscal year.
The data is like below
The required outut is
|Month||Previous month value||current Value||Avg|
To show the output in table i am getting the output properly, but when i use the same expression for the line chart it was not giving the correct value .
Can any one help me on this to show these results in a line chart .
Thanks in advance
May be this?
Previous month value
Above(Sum(Value)) + Sum(Value) / 2
When I use the mentioned functions it was near to that value.
I am using a Line chart will the months of one year (i.e from Apr to Mar). The above function for the month of April it was not showing the value.
Thanks in advance.
Looks like working?
Thanks for your reply.
I agree it was coming in this line chart with data i provided . But when we are going to represent the current fisical year(17-18) months into the chart.
It was not giving the value for the month April.
kindly help me on this.
Image of your expected visualization. Not sure whether there is any Fiscal Fields having in the script