http://forums.visokio.com/discussions/tagged/negative-positive-values/feed.rss Mon, 30 Oct 17 16:19:41 -0400 Tagged with negative-positive-values - Visokio Forums en-CA http://forums.visokio.com/discussion/2921/barline-view-negative-numbers-and-mean-valuess Thu, 30 Apr 2015 12:26:16 -0400 Phillipa 2921@/discussions
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
]]> http://forums.visokio.com/discussion/2155/idea-barline-view-hide-mixed-values-warnings Mon, 20 May 2013 17:34:46 -0400 username 2155@/discussions
Thanks!
]]> http://forums.visokio.com/discussion/1487/bar-view-additional-features Thu, 19 Apr 2012 10:56:37 -0400 andy_white 1487@/discussions
This would mean you could have stacks with negative values (automatically appear below the x axis) or when you have for instance 2 stack values, have one appear above and one appear below the axis. - Andy]]>