Help with a nested Bar chart

karlysindelar_2023
karlysindelar_2023 Member
in Charting

So I have a data set that I have the month and the total number of invoices and then breaking those out by type. When I to the nested, it is giving me the sum of each type plus adding in the total, giving false info. How can I fix this. See attached. The farthest left is my total, but the group total is adding that in also, So I would like the light blue to be the group total. Does that make sense?

Capture.PNG

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    If Invoices Keyed is actually your overall total, you could filter out that type by adding that field to your filter properties and choose Not In and then selected Invoices Keyed.

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

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    If Invoices Keyed is actually your overall total, you could filter out that type by adding that field to your filter properties and choose Not In and then selected Invoices Keyed.

    **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.
  • karlysindelar_2023
    karlysindelar_2023 Member

    Mark, thank you for responding. I should add I am very new to domo, where so I add that field and choose not in?

  • MarkSnodgrass
    MarkSnodgrass Coach

    @karlysindelar_2023 glad you are getting in and using Domo. Happy to help. I am assuming that in your nested bar chart you have a field in the series which contains the values of (Invoices keyed, Rail, Port, SSL, Other, Inland).

    If you drag that field over into the Filters Properties, you are then given the option to select a filter criteria. You can then choose Not In and then check the box next to Invoices keyed)

    image.png
    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.

Categories