Adding a cumulative total line in a multi line chart in Domo

snguyen
snguyen ⚪️
edited May 9 in Card Building

Hi everyone,

Does anyone know how to add a cumulative total line chart in a multi-line chart? I have 3 different lines that I want to show on the same line graph and I want to sum up the 3 lines and put that line on the same graph so a total of 4 line on a single graph. For example, Blue = 1, Yellow = 2, Red = 3, and I want to show the total of Blue, yellow, and red ~ 6 on the same graph. Thank you!


Thanks.

Tagged:

Answers

  • amehdad
    amehdad 🔵

    Hi @snguyen, here is a write-up outlining how to get calculated fields for running total: https://dojo.domo.com/discussion/comment/56863#Comment_56863. It is also worth noting that in a Bar + Line graph option, one can specify the number of lines and bars you want to display as running totals (through Chart properties under General).

  • snguyen
    snguyen ⚪️

    Sorry, I meant to say cumulative total say for example A = 2, B = 3, C = 5. I want to show A, B, C and the total of ABC ~ 10 on the same multi line graph.

  • GrantSmith
    GrantSmith Indiana 🥷

    You can use a beast mode to add all three values together and plot that as your fourth value



    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**
  • snguyen
    snguyen ⚪️

    I'm new to Domo, how would I go about doing that?

  • GrantSmith
    GrantSmith Indiana 🥷

    Create a beast mode and just add your values together:

    `Field 1` + `Field 2` + `Field 3`
    


    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**