Rolling Month Data

[manojkulkarni]

Hi Everyone,

I have one requirement, where in we need to show 12 months cumulative data over 12 months.

eg: for each month we need to calculate data backward for 12 months & same has to be continued for rolling 12 months.

Your solution is much appreciated.

[sujeetsingh]

Where you want the rolling presentations to be in your UI or script.

There are different way to implement --In UI for bars there is option of accumulation in qlicview.

--IN Script

--In UI for bars there is option of accumulation , in Pivot table there are logic of expressiosn to handle

[manojkulkarni]

required in charts. Accumulation option will accumulate only the data available in chart. But my requirement is,

if Starting point is Jan14, then data should be calculate from last 11 months i.e from Feb13 to Jan14.

Like this i need show bar chart for 12 months. Jan14 to Dec14.

In every point, it should calculate data for last 12 months.

[Anonymous]

Hi Manoj,

In chart properties, under Expression tab select the Full accumulation option for you expression.

Hope this will solve your problem.

Regards,

Laxmi

[sujeetsingh]

You need to go for a logic then