Get rid of Warning message in Pie Chart
Is there any way to get rid of this Warning? I am intended to show the numbers as negative though.
Best Answer
-
I would suggest hiding the legend with the chart properties and then using the data label settings to show the information that would be in the legend, but within the pie slice, which would allow you to use the tooltip field and show a negative number.
**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
-
The pie chart is going to have a hard time determining a percent of total, and the size of each pie slice, with a negative number.
If all your numbers are negative, you could try creating a beast mode and multiplying the value by -1, or use the ABS() function to force it to be positive. You can then drag that beast mode into your values section for the pie to populate. To display the negative value, you can drag the original value field into the Tooltip1 field and then use the data label settings to show Tooltip1.
**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 -
If you have both positive and negative values, I'd consider a different chart type to display the data, like a waterfall chart.
0 -
Thank you for the response. Yes all my numbers are negative.
However, I also have legend on the side of the pie chart, so if create a BeastMode that uses ABS() & drag that BeastMode into Pie Value, the legend will show all number in positive (which is not what I'd like to show unfortunately)
0 -
I would suggest hiding the legend with the chart properties and then using the data label settings to show the information that would be in the legend, but within the pie slice, which would allow you to use the tooltip field and show a negative number.
**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
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K 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
- 747 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
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 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