http://forums.visokio.com/discussions/tagged/weighted_means_averages/feed.rss Mon, 30 Oct 17 15:22:13 -0400 Tagged with weighted_means_averages - Visokio Forums en-CA http://forums.visokio.com/discussion/3184/default-function-for-data-fields Thu, 03 Nov 2016 06:25:55 -0400 bfromson1 3184@/discussions
If "mean" is chosen as the function, is there a way to specify a weighting field, as would be possible when directly applying a function to the field in a table. If not could this be added?

Thanks,

Bernard

(using 3.0 b6569, but applies to 2.9 as well)]]> 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/2757/formulae-weighted-average-in-content-view-stacked-bar-chartss Fri, 07 Nov 2014 05:06:09 -0500 DominicChan 2757@/discussions
Also, when doing a weighted average in the Bar View, after stacking the bars, the figure displayed at the top of the bars are the sum of the stacking buckets. How can I make the figures on top of the bars to display an overall weighted average?

Thanks
Dom]]> http://forums.visokio.com/discussion/2687/aggregation-calculating-weighted-meanss Fri, 15 Aug 2014 08:40:24 -0400 Alexander 2687@/discussions
I am encountering a problem that I am aggregating a rather large dataset, but I am not able to choose a weight for the fields that I want to result as the average of the aggregated data.

Do you get what I mean?

The same problem is occuring as discussed in http://forums.visokio.com/discussion/2606/aggregation-why-are-some-fields-not-editables.

Please advise.

(Using custom build: Hotfix Function not supported 2.8 b 1276)]]> http://forums.visokio.com/discussion/2179/aggregation-weighted-average-functions Mon, 03 Jun 2013 12:58:40 -0400 peterg_at_aps 2179@/discussions
I want to calculate the mean latitude and longitude weighted by quantity demanded for some customer locations. However as soon as I select the mean for these fields a line appears next to the field with no options.]]> http://forums.visokio.com/discussion/2039/content-view-calculating-weighted-averages-in-an-html-display-table Wed, 06 Mar 2013 09:25:05 -0500 Phillipa 2039@/discussions
The problem is that I need to weight my mean values to arrive at the correct figure. Is there a simple solution?

Thanks, Phillipa]]> http://forums.visokio.com/discussion/1882/aggregation-dm-block-single-average-record-unweighteds Thu, 01 Nov 2012 14:11:54 -0400 ygulla 1882@/discussions
I need to aggregate all records into one "total" row. Field A needs to aggregate as an average weighted by Field B.

When I drop in an Aggregation block, don't select any splits and the choose function for Field A to be mean and the weight to be Field B. The resulting value is unexpected... the result seems to be an unweighted mean?

NB: to make it work I had to add a constant field One (equals 1 for all records) and "split" by it.

See attached file for a trivial example.

Edit: I use 2.7 b441 x64]]> http://forums.visokio.com/discussion/1226/idea-content-view-spreadsheet-cellss Thu, 19 Jan 2012 05:22:40 -0500 rajeshbalu29 1226@/discussions ]]>