Create a Line Chart that shows the different series while also showing the aggregate of the series?

Options
joebenz
joebenz Member

I'm looking to make a line chart that shows each country region as a separate line, while also showing the aggregate grand total as its own line. Is this possible? If so, how would I go about doing so?

I'm attaching one Domo screenshot, and one screenshot from Excel (which is what I want the domo one to look like).

Thank you.

Tagged:

Best Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    You could take your entire dataset, set the series column value to 'Grand Total' and then stack that with your original dataset so you then have a Grand Total value in your series to get the format you're looking for.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Sean_Tully
    Sean_Tully Contributor
    Answer ✓
    Options

    I think @GrantSmith's suggestion is probably the best way to do this. If you only have a few country values in your dataset, though, you could also do this by building beast modes for the metric for each country one at a time, then a total beast mode, and plotting them all together.

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @joebenz You could also create a Segment for your grand total. Here is more information about Segments: https://domo-support.domo.com/s/article/4403089503383?language=en_US

  • MarkSnodgrass
    Answer ✓
    Options

    The easiest way I have found to do this is to use the Segments feature.

    https://domo-support.domo.com/s/article/4403089503383?language=en_US

    In the columns to create a segment, select the column that is in your series and then either select all the items in the selection, or choose match values and choose does not contain and enter something like zz which you know will not be in the list. (this 2nd option is helpful when you the series values may change).

    Add the segment to the chart in the now present segment field and it will aggregate the same way your y-axis is aggregating. (I'm assuming you already have the y-axis set to sum).

    **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

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    You could take your entire dataset, set the series column value to 'Grand Total' and then stack that with your original dataset so you then have a Grand Total value in your series to get the format you're looking for.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Sean_Tully
    Sean_Tully Contributor
    Answer ✓
    Options

    I think @GrantSmith's suggestion is probably the best way to do this. If you only have a few country values in your dataset, though, you could also do this by building beast modes for the metric for each country one at a time, then a total beast mode, and plotting them all together.

  • MichelleH
    MichelleH Coach
    Answer ✓
    Options

    @joebenz You could also create a Segment for your grand total. Here is more information about Segments: https://domo-support.domo.com/s/article/4403089503383?language=en_US

  • MarkSnodgrass
    Answer ✓
    Options

    The easiest way I have found to do this is to use the Segments feature.

    https://domo-support.domo.com/s/article/4403089503383?language=en_US

    In the columns to create a segment, select the column that is in your series and then either select all the items in the selection, or choose match values and choose does not contain and enter something like zz which you know will not be in the list. (this 2nd option is helpful when you the series values may change).

    Add the segment to the chart in the now present segment field and it will aggregate the same way your y-axis is aggregating. (I'm assuming you already have the y-axis set to sum).

    **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.