Nesting Bar Chart not showing totals after filter
Hello,
I've created a nesting bar chart and it shows the totals when I have all the data selected, however when I try to filter down to a specific format, the totals go away even though there are markets and stations still in there. Any filtering removes a total and I would like totals implemented. Any advice?
Best Answer
-
Hi @user031517
When you filter your data you're telling Domo to ignore your other data rows so when it goes to plot your single filtered rows and has no context of your other rows / totals so you only have a single value which is your total value as well.
Instead of filtering you can still plot the data and keep the context but hide the visualization of the data by clicking on the elements in the legend. It will hide them but should still display your overall total.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3
Answers
-
Hi @user031517
When you filter your data you're telling Domo to ignore your other data rows so when it goes to plot your single filtered rows and has no context of your other rows / totals so you only have a single value which is your total value as well.
Instead of filtering you can still plot the data and keep the context but hide the visualization of the data by clicking on the elements in the legend. It will hide them but should still display your overall total.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 -
That helps, but is there a way to keep the total with filters at all? We filter on actually many different variables and not just the one.
0 -
No because the filter happens before the data is displayed so it's not there to show the totals since your card doesn't know about those rows.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Understood, thank you.
0 -
as @GrantSmith when you apply filters it sets the context for what data is available as you calculate the denominator in the percent of total calculation.
there is a new beta feature in development that will allow one visualization to support 'filter groups'. the title of the feature may have changed, but the gist of the idea is that you can define a filter group that will not respond to certain filters. so for example if you set a group "South West" and then you filtered where State = "Arizona" (which is in the South West), the South West group would include all states in the SW.
Ask your CSM for more information about the beta program, this feature may help you accomplish your visualzation requirement.
@GrantSmith -- do you remember off top what hte feature was called?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
I don't but I'm sure the CSM can help translate the request to the beta feature.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Thanks, I will contact our CSM
0 -
I think you are referring to Filter Views that is in Beta right now, but you could be referring to something else.
**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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive