Hi all,
I’m currently utilizing runningSum and struggling with situation when aggregating data by months as in below example. is there any way to roll up the “20” for May even if no new items are not added in May yet? I’d like to avoid situation when NULLs are reflecting as in this example:
here’s the formula i’ve generated:
runningSum
(
distinct_count({items}),
[truncDate(“MM”,{date}) ASC]
)