runningSum has gaps

Hi community,

I created a running sum over days by channel. The problem is that there are gaps when there is no value in this channel for a specific day.

This is obviously not the desired behavior, any input?

This is an undesired behaviour in your case but kind of expected. Since your values are voming from a running sum, one would expect that visual to fill in any gaps but for other cases it might be undesirable to carry over previous values.

There you seem to have days for which data is not available for all channels. There is no way to tell QuickSight to add rows in an analysis. Right now the available workaround, in the data preparation stage, would be to RIGHT join your data with a dimension table that includes all days and channels.