Bar/Line View: Negative numbers and Mean values?

Phillipa · April 30, 2015 12:26PM

Hi Guys,

I am doing a relatively simple bar diagram to show the expected change in use of a substance in the next 6 months.
Each record (doctor) has a number which can be positive to show an increase or negative to show a decrease in use.
I have taken the mean value without any weight to show the overall expected change.

However, here is the problem - the positive values are being calculated and the average taken and it appears as if the negative values are being calculated separately. This means I have one doctor with a -50% and his value is shown as -50% whilst the other 13 doctors have positive values where the mean of all their values is taken at 27%.

I now have a total value of -22.9%, which is not correct. I have tried aggregating but can't seem to get rid of the -50%.

Am I overlooking something?

Thanks for any help.

Phillipa

paola · April 30, 2015 12:56PM

Not sure what method you used to calculate the mean? Formula in the DataManager, Table in Data Explorer, or Formula as a measure in the Bar/Line view?
It is better to use a formula field, in which case I cannot reproduce the issue.

Phillipa · May 4, 2015 4:14AM

Hi Paola,

Thanks for the answer. My mistake....

The problem was that I was using a stacked bar chart.

Omniscope was giving me mean values for each stack and then stacking the mean values.

Phillipa

paola · May 5, 2015 2:01PM

Sum of means is difficult to interpret, so depending on the scenario perhaps you could try different method, either comparing the outcome of the individual categories (+/-%) or calculating a single weighted mean figure as a global indicator.

Welcome!

Categories

Ideas Parade

Tagged