Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 26, 2017 at 03:13 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 29, 2017 at 08:34 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded