3 Replies Latest reply on Sep 22, 2016 6:08 AM by ra.sae.0

    Creating calculated table showing 'This Week', 'Last Week', and 'This Week Last Year' values.

    Filipe Hemsworth

      Hi,

       

      As the title describes, i'm trying to create a table with 3 columns, showing the values for 'This Week', 'Last Week', and 'This Week Last Year'. I would like to do this for 5 different measures shown in the screenshot below (sessions, transactions, Conversion, AOV, and Revenue)

       

      The data is a direct feed from Google Analytics, and so far I have only been able to show the values for the current week selection. How would I go about adding 2 additional calculated columns to this table to show the previous values named above?

       

       

      Many thanks in advance!