http://forums.visokio.com/discussions/tagged/average-or-mean/feed.rss Mon, 30 Oct 17 16:19:25 -0400 Tagged with average-or-mean - Visokio Forums en-CA http://forums.visokio.com/discussion/2936/barline-view-displaying-flat-average-lines Mon, 18 May 2015 12:46:06 -0400 benjamin 2936@/discussions Is there any way to have a line on a bar chart view which just shows the flat average for the period shown ?
Thanks, Ben]]> http://forums.visokio.com/discussion/2791/idea-defining-default-weighting-fields-for-each-columns Wed, 17 Dec 2014 05:32:00 -0500 Mees 2791@/discussions
I have a Bar/Line View where I measure averages.

Defining on which field to weight the average is working fine, but when we switch the value to another field, Omniscope loses the weighting of the initial field. Going back to the initial value measure, we have to set the weighting again.
This is not ideal as we want our users not to worry about this.

Would it be possible to define the weighting settings per field in the Field Settings (the Ctrl+F menu, not sure what the English menu name is)

Many thanks

]]> http://forums.visokio.com/discussion/827/historical-moving-average Thu, 16 Jun 2011 10:55:38 -0400 Wayne 827@/discussions http://forums.visokio.com/discussion/670/formulae-ignoring-blank-cells-when-calculating-averages Mon, 07 Mar 2011 04:08:33 -0500 Paul 670@/discussions
Could someone help me please with the best way to configure Omniscope to calculate an average which ignores or excludes the blank cells, such that it calculates the average of the 4 fields in the above example as 10, as Excel would do as standard using the AVERAGE function?

The above example is the first row in a dataset - subsequent rows have decimal values in all 4 fields and so the AVG function calculates the average 'correctly'

Thanks, Paul
]]>