Get rid of Warning message in Pie Chart

verytiredgirl
verytiredgirl Member
in Cards, Dashboards, Stories
image.png

Is there any way to get rid of this Warning? I am intended to show the numbers as negative though.

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    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.

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    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 <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • MichelleH
    MichelleH Coach

    If you have both positive and negative values, I'd consider a different chart type to display the data, like a waterfall chart.

  • verytiredgirl
    verytiredgirl Member

    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)

  • MarkSnodgrass
    MarkSnodgrass Coach
    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.

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories