1 Reply Latest reply on Apr 12, 2018 3:00 PM by Joe Oppelt

    Creating a Calculated Field Metric // Level of Detail

    Marc Levy

      In the attached workbook, I want to create a metric that divides the row in sheet 1 (e.g. the first row is Jog, Reached 25%) by the Pageviews in the Jog category (shown in sheet 2).  So it would be 508/534,000. How would you do that for each row in sheet 1?  The 'Run' rows in sheet 1 would be divided by the Run pageviews in sheet 2.  The stair climb rows in sheet 1 divided by the stair climb figure in sheet 2, etc.

       

      Thanks,

      Marc