runningSum - how to avoid NULL values

Question & Answer
1

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:

image

here’s the formula i’ve generated:

runningSum

(

distinct_count({items}),

[truncDate(“MM”,{date}) ASC]

)

2

Unfortunately this is a limitation of QuickSight.

The only way around it is to do some SQL work and make like a calendar, where you have a row for everyday and then join your data onto that.

1 Like