Skip to Content
0

RunningSum from 24 months back to be shown on a chart only 12 months back

May 26, 2017 at 11:29 AM

34

avatar image
Former Member

Hello,I have to show on a chart only 12 months back rolling sum, which need to be calculated taking values from 24 months back. Is it possible somehow to cut the period on a chart? Once I use additional data provider to cut the period - this works but rolling sum values are sum per this cut period. But I do not want to change the values comming from 24 months back.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
May 26, 2017 at 03:13 PM
0

Apply the filter at report level to exclude first 12 month/Year.After that use nofilter() function in measure object to calculate from starting.

Sameple=NoFilter(RunningSum([Sales revenue]))

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 29, 2017 at 08:34 AM
0

Hello, Thank you for your hint. I have done the filter on a report and also apply the function in my measure and still it calculates the measure according to cut time interval, but I need to keep the same calculation as with -24 months back.

My measure looks like below, now:

=NoFilter( (RunningSum([AVG Response Time Hrs per SR]) - RunningSum(Previous([AVG Response Time Hrs per SR];12)))/12 )

Kind regards.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

try this.

=NoFilter(RunningSum([AVG Response Time Hrs per SR])) - nofilter(RunningSum(Previous([AVG Response Time Hrs per SR];12)))/12

0