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
- 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