title: Show daily count and the total count up to that day in Quicksight
body: <p>I want to create a table analysis in AWS Quicksight that shows the number of new user per day and also the total number of user that has registered up until that day for the specified month.</p>
  <p>The following sample table is what I want to achieve in Quicksight.
  It shows the daily register count for March:</p>
  <pre><code>+-----------+----------------------+----------------------+
  |           | Daily Register Count | Total Register Count |
  +-----------+----------------------+----------------------+
  | March 1st |           2          |          42          |
  +-----------+----------------------+----------------------+
  | March 2nd |           5          |          47          |
  +-----------+----------------------+----------------------+
  | March 3rd |           3          |          50          |
  +-----------+----------------------+----------------------+
  | March 4th |           8          |          58          |
  +-----------+----------------------+----------------------+
  | March 5th |           2          |          60          |
  +-----------+----------------------+----------------------+
  </code></pre>
  <p>The &quot;Total Register Count&quot; column above should show the total count of users registered from the beginning up until March 1st, and then for each row it should be incremented with the value from &quot;Daily Register Count&quot;</p>
  <p>I'm absolutely scratching my head trying to implement the &quot;Total Register Count&quot;. I have found some form of success using <code>runningSum</code> function however I need to be able to filter my dataset by month, and the <code>runningSum</code> function won't count the number outside of the filtered date.</p>
  <p>My dataset is very simple, it looks like this:</p>
  <pre><code>+----+-------------+---------------+
  | id | email       | registered_at |
  +----+-------------+---------------+
  | 1  | aaa@aaa.com | 2020-01-01    |
  +----+-------------+---------------+
  | 2  | bbb@aaa.com | 2020-01-01    |
  +----+-------------+---------------+
  | 3  | ccc@aaa.com | 2020-01-03    |
  +----+-------------+---------------+
  | 4  | abc@aaa.com | 2020-01-04    |
  +----+-------------+---------------+
  | 5  | def@bbb.com | 2020-02-01    |
  +----+-------------+---------------+
  </code></pre>
  <p>I hope someone can help me with this.
  Thank you!</p>