Remove 0s from data labels
Comments
-
Hi @hamza_123
You could create a new beastmode to return an empty string if the value is 0 otherwise return the value
CASE WHEN `value` = 0 THEN '' ELSE `value` END
Put this calculated field into the Tooltip 1 field and then set the data value label to be Tooltip 1 instead.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Grant's solution would likely be the most comprehensive for a variety of different scenarios.
I'm also curious as to how your Data Label Settings are configured. If "Show When Zero" is unchecked, it should automatically hide all your "0" values. Seems to work for all my charts.
----------
Serving up data insights since 2002...1 -
For the first solution provided: empty thread even shows if beast mode selected.
For the second solution provided: My shows 0 box is unchecked. Even then this is hapenning. I don't get it
0 -
@hamza_123 How are your data label settings defined? Did you change it to reference %TOOLTIP1 instead of leaving it blank?
What do you mean by empty thread?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I've realized that although the line seems its equal to zero, when I hover over it it actually has a value. That is why it keeps on showing.
Thank you everyone for the input : )
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