cumulative sum

Find more posts tagged with

Accepted answers

is `Total Revenue` ever null?

try

IFNULL(`Total Revenue`,0) / (SUM(IFNULL(`Total Revenue`,0)) OVER())

All comments

guitarhero23

I'm not sure if you can do it in a beastmode or not but you can achieve something like that you're looking for in an ETL.

Use the Rank & Window block with a function of SUM based on your Total Revenue field and make it unbounded with a preceeding of 0.

Dojo Help 701.JPG

When I look just at those columns you can see it's a running total.

Dojo Help 702.JPG

@meadow_ryan - I'm trying to understand your use case. You want to calculate a running total so that you can take the max() of that field to get a grand total?

Unless there is more to this, why not just sum the column?

If the intention is to understand what percentage of total revenue is coming from each company, you can to this using beastmodes.

For `Grand Total (Revenue)`

(sum(`Total Revenue`) over ())

for % of revenue

`Total Revenue` / (sum(`Total Revenue`) over ())

This will give you something like this:

The advantage to doing this in the beastmode is that the grand total and the percentage will recalculate as you apply any filters to the card

I added the following to my card and the card doesn't display any data now

`Total Revenue`/(sum(`Total Revenue`) over ())

entering as it looks in the attached screenshot and its not taking it?

is `Total Revenue` ever null?

try

IFNULL(`Total Revenue`,0) / (SUM(IFNULL(`Total Revenue`,0)) OVER())

don't believe it ever will be, but when I add the beast mode function receive the following in the screenshot

You need to make sure that none of the other fields are aggregate functions as well.

I'm guessing that =Profit is an aggregate field. Try taking it off or removing the aggregate from the beastmode formula

=Profit is

SUM(`Total Revenue` - ABS(`Total Cost`))

change it to:

`Total Revenue` - ABS(`Total Cost`)

getting the following now

change the field to display as a percent with 2 decimals