MTD Beast Mode

user04740

Hello, 

I am trying to gather a running total of an amount for a Bar Line Chart Card. Mathematically it should go:

June 1st (Σ  June 1st's Amount)

June 2nd (Σ June 1st's Amount, June 2nd's Amount)

June 3rd (Σ June 1st's Amount, June 2nd's Amount, June 3rd's Amount)

...

June 31st (Σ June 1st's Amount, June 2nd's Amount, June 3rd's Amount,..., June 31st's Amount)

Is this something that I could do in beastmode?

I really appreciate any help in advance.

 

rado98

Check out this thred for a couple of options

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Adding-Two-Rows/m-p/34211#M5365

BlueRooster

Another option instead of a BeastMode would be to use either the Running Total Bar or Line graph. You could then set the date range to graph by day and get the result you're looking for.

 

You can read more about it here:

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Running_Total_Line_Graph

 

user04740

That was close, but I forgot to add that I need a comparitive Year over Year trend line over it as well... I tried just adding it to the running total card but it keeps just forcing it back to the Bar Line chart.