cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

amitrathi239
Active Contributor
0 Kudos

try this.

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

amitrathi239
Active Contributor
0 Kudos

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]))