title: Merge two date fields in Google Data Studio
body: <p>I have the following set-up in a spreadsheet</p>
  
  <pre><code>Order | Open date | Completion date | Order status
  --------------------------------------------------------------
  Ord1  | 01/01/2020 | 01/02/2020      | Success
  Ord2  | 01/01/2020 | 01/01/2020      | Rejected by the client
  </code></pre>
  
  <p>In this scenario I have:</p>
  
  <ul>
  <li>2 orders opened in Jan</li>
  <li>1 order success order in Feb</li>
  <li>1 order rejected in Jan </li>
  </ul>
  
  <p>If I want to put this in a line graph and compare <strong>Total number of orders vs Succes vs  Rejected</strong> , I would have to merge somehow the two date fields in a single date field, correct?</p>
  
  <p>I say this because I have to use a date field for filtering, but if I filter based on <strong>Open date</strong> I don't get the correct date for the two statuses that link to <strong>Completion date</strong> and same the other way around. </p>
  
  <p>Any ideas how to to this comparison in Google Data Studio? </p>
  
  <p>Open date</p>