title: How is it possible to calculate value for the same day last week in tableau for every day?
body: <p>I would like to calculate values for yesterday for every date in a table.
  Firstly I have simply calculated the number of orders for each date using COUNTD function.
  But afterwards I encountered some problems trying to calculate values for &quot;yesterdays&quot;.
  Please refer to the image</p>
  <p><a href="https://i.stack.imgur.com/bZBKK.png" rel="nofollow noreferrer">example</a>
  For example for 12th of April I would like to obtain the value for 11th of April.
  On the internet there are a lot of examples using today() or max() or table functions but they do not give the required result because a would like to filter for example 12th April but still see the value for 11 April.
  Could you please help, how is it possible to do this?</p>