Visokio website     Downloads     Video tutorials     KnowledgeBase  
Content View: Calculating weighted averages in an HTML display table - Visokio Forums
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
  • 2 Comments
  •     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!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership