Running Totals with actuals vs budget data

Options
elvira_bannon
elvira_bannon Member
in Dashboards

Hello, I am pretty new with Domo and currently trying to figure out if running totals can be calculated for graph that shows daily activity for actual revenue and budget as listed below.

This is a grouped and stacked bar .

Your assistance is greatly appreciated!

image.png

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You can use the Line + Grouped Bar to have your bars plus lines as running totals. You will need to edit your chart properties to this:

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited August 2023

    Yes they can. There is a chart type called "Running total grouped bar". Please explore this chart type, refer to this documentation, and if you still have questions please let me know!
    https://domo-support.domo.com/s/article/360042924974?language=en_US

    If I solved your problem, please select "yes" above

  • elvira_bannon
    elvira_bannon Member

    Thank you Colemen! I would like to keep the bars as shows and show two lines with the running totals; actuals and budget. The information you provided does not show this option.

    I am thinking this may be a beast mode calculation. Do you have other suggestions?

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    You can use the Line + Grouped Bar to have your bars plus lines as running totals. You will need to edit your chart properties to this:

    image.png
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • elvira_bannon
    elvira_bannon Member

    Thank you very much Mark! I have seen lots of your videos and have learned a lot from you.

Categories