topic Re: Negative values in pie chart in App Development

Negative values in pie chart

Wed, 02 Mar 2016 08:25:49 GMT

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

Re: Negative values in pie chart

Chanty4u — Wed, 02 Mar 2016 08:30:59 GMT

pi chart is not the right object when you have negative values...! You need to use bar chart or line chart.

Re: Negative values in pie chart

Chanty4u — Wed, 02 Mar 2016 08:31:57 GMT

or u can use

FABS(expression) to use absolute value.

lik

FABS(Sum(Value))

Re: Negative values in pie chart

undergrinder — Wed, 02 Mar 2016 08:45:08 GMT

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)

Re: Negative values in pie chart

puttemans — Wed, 02 Mar 2016 09:19:40 GMT

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

Re: Negative values in pie chart

Wed, 02 Mar 2016 09:30:11 GMT

Hi Betty,

Try changing your measure expression like

sum({$<YourMeasure={">0"}>}YourMeasure)

Regards,

Rohan