When using running sum, how do you fill in the values for missing dates?

Hey there,

I’m currently working on a table calculation, and I’ve noticed that the running sum isn’t functioning correctly due to missing values in the dates. In the provided image, you can see that for Q1, the sales data is missing for day 4 and day 5. In this scenario, I’m wondering if it’s possible to carry forward the value of 1.16M from day 3 to day 4 and day 5 when using the running sum calculation.

The calculation for the running sum is as follows:
nullIf(runningSum(sum({Amount (converted)}), [{test - difference} ASC]),0)

In this calculation, the {test - difference} field represents the day of the quarter. For example, if the date is January 1st, {test - difference} would return 1, and for January 2nd, it would return 2, and so on.

If you have any suggestions or insights on how to address the missing values in the running sum calculation, please let me know.

quicksight

Yes, this is currently how quicksight computes running sum.

I’ll mark this as a feature request as it frustrates us as well.

I haven’t been able to get a work around for it.

Thanks for the response, Max! Appreciate it.