2 Replies Latest reply on Feb 17, 2016 1:48 PM by Joe Baker

    Week over Week Change of Latest Date in View

    Joe Baker

      I would like to create a KPI like table showing Absolute Week over Week Change, Week over Week % Change, Month over Month % Change, and Year over Year % Change.  Similar to the following but with the measures I just listed replacing the ones shown in my view:


      I would like the measures to calculate on the last day shown in the Order Date Filter (in this case 12/31/2014).  So my first measure would be Avg Sales, but only for 12/31/2014.  The next measure would be the Absolute Week over Week Change of Avg Sales on 12/31/2014 - Avg Sales on 12/24/2014, etc...