runningSum however, the new calculated field will stop summing values after a defined period

Hi,

I am trying to create a calculated field which would have a similar output as the runningSum function, however, the new function/calculated field will stop summing values after a defined period (Week, month, etc…), return the summed value (i.e 26th to 29th of march) and start again for the next period (i.e. Apr 5th to April 29th) as shown in the example below.
The required field will be “datetime” and “value”. the column “balance” should present the expected output

Is there a way to do it?

Best

image

Hi @Moise_Dakouri,

I think the periodToDateSumOverTime - Amazon QuickSight function can solve this problem for you.

I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

1 Like