In bars chart display all numeric categories in x-axis without creating a new dataset
We have a dataset with a numeric category that ranges from 1 to 10, and we’re trying to build a bars chart with that category on the x-axis and a count of elements in the y-axis. Sometimes not all of the categories have values to display. Is there a way to maintain all numbers shown in the axis even if the count of their elements is zero (without having to create a new dataset or modify the one that we’re using)?
We have a workaround for this by creating a new dataset that left joins numbers from 1 to 10 with the original, but it just seems too much overhead.
Any advice would be appreciated.
Thanks!
Comments
-
Hello osmararv,
Cards are designed to display data that exists in the dataset they are built on (after filters are applied). If values do not exist in that data, they cannot be included on the card. The only current exception to this is the Time Scale that creates a scale for date and datetime values.
Requests have been made to include a "Value Scale", similar to the time scale, but for numerical values. Our development team is considering the requests, but I do not have information yet on whether that option will be included in the future.
The workaround you are using, to inject the extra values into your data, is the current best method for achieving your goal.
Please let me know if you have any further questions on this topic.
Thanks!
Steve Cook
Domo Technical Support
Starlord
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks Steven!
I agree with you that a Value Scale would be a great addition to the card builder. Do you know if there is a related Idea in the community that I can vote for?
0 -
Hello osmararv,
I am not aware of this idea already being posted in the Ideas Exchange. Please feel free to add it if you would like, so that others can vote on it as well.
Thanks!
Steve Cook
Domo Technical Support
Starlord
**Say “Thanks” by clicking the “heart” in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"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
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive