Help with a nested Bar chart
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?
Best 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 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
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 any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Mark, thank you for responding. I should add I am very new to domo, where so I add that field and choose not in?
0 -
@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)
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive