Content View: Calculating weighted averages in an HTML display table

Phillipa · March 6, 2013 9:25AM

Hi - I am trying to build a simple HTML table in a Content View with various stats.

The problem is that I need to weight my mean values to arrive at the correct figure. Is there a simple solution?

Thanks, Phillipa

Phillipa · March 6, 2013 10:33AM

Hi Again,

I have used a simple formula with subset_sum(value*weight)/ subset_sum(weight), which works well. I presume the easier weighted average is not available in the Content View.

Phillipa

paola · March 13, 2013 8:05AM

The 'intermediate multiplication' calculation for each pair Xi and Wi should be done in the Table View, creating a new field with formula [Value x]*[Weight w].
The Content View formula will divide sums of two columns.
Result will respond to filtering, so you might want to set the Data subset for the Content view to point to 'All values'.

Welcome!

Categories

Ideas Parade

Tagged