2 Replies Latest reply on May 13, 2015 12:17 AM by Jaideep Rokade

    How can I create a metric that uses the denominator from one table and the denominator from a different table?

    Shankari Panchapakesan

      I am trying to create %Reach metric.

      %Reach TV= Count of panelists who watched TV during a given week/Total number of panelists who are considered for measurement during a given week (or who are In-TAB).

       

      The numerator is calculated from one table.

      The denominator is calculated from a different table which contains the count of In-Tab panelists for each week. This number varies by various demos (gender, race, age, etc).

       

      I've attached a sample excel worksheet to demonstrate the requirement.

       

      Thanks

      Shankari