Avg of Previous month vs Current month

[kumarkp412]

Hi All,

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

Month	Value
Mar	100
Apr	120
May	90
Jun	80

The required outut is

Month	Previous month value	current Value	Avg
mar		100
Apr	100	120	110
May	120	90	105
Jun	90	80	85

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

Thanks

Kumar KVP

[tresesco]

Could you share your sample qvw that demonstrates the issue in line chart?

[Anil_Babu_Samineni]

May be this?

Previous month value

********************

Above(Sum(Value))

Current Value

*************

Sum(Value)

Avg

***

Above(Sum(Value)) + Sum(Value) / 2

OR

RangeAvg(Above(Sum(Value)), Sum(Value))

[kumarkp412]

Hi Anil,

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.

Thanks

kumar KVP

[Anil_Babu_Samineni]

Looks like working?

[kumarkp412]

Hi Anil,

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.

For sample:

Month	Value
Mar-17	100
Apr-17	120
May-17	90
Jun-17	80

kindly help me on this.

Thanks

Kumar KVP

[Anil_Babu_Samineni]

Image of your expected visualization. Not sure whether there is any Fiscal Fields having in the script