This content has been marked as final.
Show 3 replies
-
1. Re: Window Cumulative Sum
Zhouyi ZhangOct 23, 2019 4:36 PM (in response to Thomas Nakamoto)
-
window_cumulative_sum_v10.2.twbx 13.8 KB
-
-
2. Re: Window Cumulative Sum
Thomas Nakamoto Oct 24, 2019 9:17 AM (in response to Zhouyi Zhang)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!
-
3. Re: Window Cumulative Sum
Zhouyi ZhangOct 24, 2019 4:20 PM (in response to Thomas Nakamoto)
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