Hello,
I am trying to figure out how to do a cumulative window sum based on filter selection
So I want the running_sum to start and stop in the window of the date range
Here the date range (1/3 - 1/7)
Here I have moved the date range (1/5 - 1/9)
Any help would be appreciated!
Oct 23, 2019 4:36 PM
Hi, Thomas
have you tried the running_sum() function?
Hope this helps
ZZ
Hi Zhouyi,
You are right, running_sum() does work perfectly with a normal filter. I realized my attached workbook was actually an oversimplification of the problem I am experiencing. In the case of using a parameter as a filter, running_sum() ignores the parameter.
I did solve my problem with your help, by creating two calculated fields:
Check if date matches parameter filter
[field 1]
IF DATE(LOOKUP(ATTR([Date]),0)) = [Date Parameter]
THEN SUM([Visits])
ELSE 0
END
Running Sum of parameter measures only
[field 2]
RUNNING_SUM([field 1])
Thank you!
Oct 24, 2019 4:20 PM
Hi, Thomas
Glad to help. If you don't have further question, can you mark my answer either as correct or helpful to close the thread? ta
ZZ