7 Replies Latest reply on Mar 9, 2016 7:11 AM by Roxana Tudor

    Using a previous partition in the formula but not showing it in the date range

    Roxana Tudor

      Hello,

       

      I want to calculate the Daily % change of the price units based on each calendar day. The formula is fine, but I'm using also a dinamically date range in order for users to select the wanted period of the report.

       

      I'm facing with the following isuse:

       

      I would like to select the date starting with 1 February 2009 and see only the data that I'm interested in. The problem is that in order to have the % change correct calculated I have to insert as Start Date 31 January 2009 in order for Tableau to know the previous value.

       

       

      If I insert as Start Date 1 February 2009, the data is not correct calculated (see below screenschot)

       

       

      Can anyone help me with this, please?

      I have attached also a draft of the workbook.

       

      Thank you!

      Roxana