What is going on with "Other" in a bar chart?
Hi,
Was hoping someone could either confirm this is a bug or tell me what I am doing wrong please. I am waiting for domo to get back to me on this with a more complex scenario but I thought I would try this with very basic data and to me it doesn't work.
Given the data
When I set the value on the yaxis and on tooltip #1 and set both to display i get this which is correct.
When I set the chart to show the top 2 I get this
The tooltip value in Other isn't being aggregated. It is showing the value for England.
Am I right to expect both to be aggregated?
Best Answer
-
I can reproduce the error. Jones01 is not using "limit rows", they are using "Max items" in the general settings. I would agree this appears to be a bug in how the tooltip is aggregated for "other" bars.
@Jones01 Until they resolve this bug, you could do something similar (but more manual) by creating a rank column in magic ETL, and then you could group based on that rank using a BeastMode (or formula tile).
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1
Answers
-
@MichelleH sure. It is the same as the yaxis. sum(value)
0 -
Can you show us what you are doing with tooltip? I do not get that response from Domo based on what you show…assuming your fields are defined as date, text, and numeric as shown below.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
I still don't get that result with a tooltip. If your data comes from Excel, try formatting the columns before using it.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
-
You are putting 2 into maximum items. That's not top 2. Look where it shows LIMIT ROWs. Set that to 2. And remove 2 from maximum items.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
It seems like Domo is aggregating the data based on the "maximum number of items" setting you've specified. When you set the maximum number of items to 2, Domo is likely displaying the top two countries with the highest values and then grouping the remaining countries under an "Other" category.In your dataset:
- The highest value is 64, corresponding to the US.
- The second-highest value is 48, corresponding to New Zealand.
- The remaining two values (45 for England and 33 for Austria) fall below the top two, so they are grouped under "Other."
This behavior is common in visualization tools when dealing with limited space or when you want to focus on the most significant data points. By setting a maximum number of items, you can control how many data points are directly displayed on the chart, while the rest are grouped for clarity and simplicity. If you want to ensure all data points are visible, you may need to adjust the settings or choose a different visualization method that can accommodate all the data without aggregation.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@ArborRose I want the chart to automatically produce the "Other" bar.
Choosing maximum of 2 items and ordering by totals shows the top 2, or top n
it is the "Other" bar that I am suggesting has the problem.
@ArborRose sorry I just read your last post. I don't think you are understanding the issue.
Why does the yaxis sum(value) differ from the tooltip1 sum(value) on the other bar. That is the issue.
These should be the same
0 -
I can reproduce the error. Jones01 is not using "limit rows", they are using "Max items" in the general settings. I would agree this appears to be a bug in how the tooltip is aggregated for "other" bars.
@Jones01 Until they resolve this bug, you could do something similar (but more manual) by creating a rank column in magic ETL, and then you could group based on that rank using a BeastMode (or formula tile).
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive