Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Does anyone know what "Data set contains negative values that can't be shown in the chart"? I've tried to supress the zeros, but it doesn't work. So I'm wondering how to Skip that line under the pie chart. A little help please? 😃
Sincerely,
Betty Habtemariam
pi chart is not the right object when you have negative values...! You need to use bar chart or line chart.
or u can use
FABS(expression) to use absolute value.
lik
FABS(Sum(Value))
Hi Betty,
If you want to just exclude zeros you should make off the show zeros functions at the properties panel, and change your formula like this:
if(myformula<=0,'',myformula)
G.
Hello Betty,
First question I have when I get such a message is whether there should be negative values... Most of the times, the negative values I got were wrong calculations that distorted the results. So my first solution would be to look critically at the data. Do they make sense if they are negative?
If they do make sense, then as already mentioned, a pie chart may not be the right way to show them (as a pie chart works in a cumulative way, you cannot create 'extra' pie with negative values).
Kind regards,
Johan
Hi Betty,
Try changing your measure expression like
sum({$<YourMeasure={">0"}>}YourMeasure)
Regards,
Rohan