1 2 Previous Next 15 Replies Latest reply on Nov 4, 2014 10:26 AM by KK Molugu

    How To Visualize Cumulative Results Over Time?

    Jonathan Gogel

      Hello,

       

      I am trying to visualize cumulative click through rates over time. Click through rates are notoriously volatile depending on the amount of impressions served, so I would like to account for fluctuations using a cumulative trend line.

       

      I've tried this using Window_SUM, but it doesn't trend over the date ranges, rather just provides the total figures.

       

      Attached is a packaged workbook with the chart showing weekly click through rates that I'd like to convert into a trended cumulative viz.

       

      Thanks for your help!

        1 2 Previous Next