Donut Graph with negative number

  • 1
  • Problem
  • Updated 3 years ago
  • In Progress
What one of the two points of a donut graph is a negative the circle turns three dimensional and displays off the screen. I know the donut graph is quite limited, has anyone been able to fix this?
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
^bump^
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Um.. Negative numbers and donuts don't work well together.  Here are some options: 

1. use a different chart type.  Columns, lines, etc. 
2. Add a UI only field on your model that limits values to positives.  (something like  if {{FieldName}}<0,0,{{FieldName}})

Here is the question.  What is the business scenario you are trying to show with this donut? Why can it have negative numbers? 
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
Hey Rob,

Thanks for the reply! I see donuts and negatives don't play nicely.

I tried your first scenario but who I building the chart for would really prefer a donut chart.

2. I thought of that same idea this morning. It should work, it just a big workaround because this a large report with a lot of different charts and this logic will have to be built for each one.

Use Case:

Create a graph to show the Sales vs Goals per team by quarter. There are 6 different teams and I need to show the sales vs goal data for each team. You can have a negative number when you started the quarter out with a large return. 
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Another tactic would be to create a before render snippet that stripped the negative numbers.  This one snippet could be used by all your visualizations.  (but I don't have time today to write it for you...) 
Photo of Tami Lust

Tami Lust

  • 5,280 Points 5k badge 2x thumb
Thank you for the other suggestion. I created a Ui-only field with an IF statement pulling in the field with the value. If the value of the field is less than 0 it shows 0 if greater it shows the number. It is working perfectly and didn't take too long.

Now if we could just alter the middle section of a donut!!