Is there a way to create Running Total using Beast Mode?

lvtrujillot · 2022-01-28T15:27:31+00:00

There was an error rendering this rich post.

lvtrujillot

Hi,

I'm building a table card and I would like to create a column that performs a cumulative sum, like the following:

| Week | Amount | Running Total

| 1 | 100 | 100 |

| 2 | 50 | 150 |

I tried to do this using SQL Dataflow, it works fine. However, I want to be able to add filters that modifies the Running Total and thus, the approach that I used with SQL doesn't help me much (since it performs the sum of the whole dataset row by row).

Any light on this would be much appreciated

Thanks

Find more posts tagged with

Beast Mode

Accepted answers

GrantSmith

Hi @lvtrujillot

You can utilize window functions in beast modes to accomplish this. You'll need to talk with your CSM to get it turned on. I've done a previous write up of window functions and running totals before. You can read up on it here: https://dojo.domo.com/discussion/52681/domo-ideas-conference-beast-modes-running-totals#latest

All comments

GrantSmith

Hi @lvtrujillot

lvtrujillot

@GrantSmith Thank you so much! It worked using SUM(SUM(..)) OVER (ORDER BY ..)