MTD Beast Mode

user04740 · June 2018

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 · June 2018

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 · June 2018

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 · June 2018

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.

MTD Beast Mode

Comments

Categories