RunningSum without taking into account filters

Question & Answer
,
1

Hello,

I have a line chart where I only want to show the last 12 months (using a filter).

In the line axis I’d like to show accumulated monthly values, but from the origin of time (in my case, 5 years ago). That is, I want the May 2024 value to be the accumulated value from the beginning of my series (2020) until May 2024, but having the filter on the graph to show only the last 12 months only partially calculates the accumulated value .

Is there a way to do a RunningSum without taking filters into account?

I’m using:
runningSum(
sum(amounts),
[truncDate(“MM”,date) ASC]
)

Thanks

2

Hello @KLIKIN,

As far as I can see, this is not possible with runningSum to have a PREFILTER. One option to show only the last 12 months can be to use Data Zoom to show only the relevant period?

image
image1093×592 54.4 KB

Hope this helps!

3

Thanks, I was thinking about that, but it’s a weekly report in pdf and every month could change the zoom

4

Hi @KLIKIN,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

5

Hi @KLIKIN,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!