on 05-26-2017 12:29 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.