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

joebenz

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.

GrantSmith

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.

Sean_Tully

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

@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

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

GrantSmith

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.

Sean_Tully

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

@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

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