title: How to get only the last records in quicksight?
body: <p>I have a dataset composed by something like this <code>id&lt;String&gt;, date&lt;Date&gt;, status&lt;String&gt;</code> filled with data like this:</p>
  
  <pre><code>+-------+------------------+----------------+
  |   id  |       date       |     status     |
  +-------|------------------|----------------+
  |   1   | 25/05/2020 10:30 |      OPEN      |
  +-------|------------------|----------------+
  |   2   | 25/05/2020 10:31 |      OPEN      |
  +-------|------------------|----------------+
  |   3   | 25/05/2020 10:32 |      OPEN      |
  +-------|------------------|----------------+
  |   1   | 25/05/2020 12:30 |      CLOSED    |
  +-------+------------------+----------------+
  </code></pre>
  
  <p>I want to have a visual that shows me the count of status, but geeting only the actual status of each id, in this example the visual should be formmed by this data:</p>
  
  <pre><code>+-------+------------------+----------------+
  |   id  |       date       |     status     |
  +-------|------------------|----------------+
  |   2   | 25/05/2020 10:31 |      OPEN      |
  +-------|------------------|----------------+
  |   3   | 25/05/2020 10:32 |      OPEN      |
  +-------|------------------|----------------+
  |   1   | 25/05/2020 12:30 |      CLOSED    |
  +-------+------------------+----------------+
  </code></pre>
  
  <p>I have tried using the count Distinct for the id, but it shows 3 OPENs and 1 CLOSED and I need a 2 OPEN 1 CLOSED result.</p>
  
  <p>I also tried to make a Date filter using the TOP or Botton option, but this filters the data to the day with more records..</p>
  
  <p>So, is there any way to do this? </p>
  
  <p>Thanks in advance.</p>