I would like to be able to query a date range of a project,
and get the number of issues per status,
for each date in this date range.
Example, let's say i have these issues:
+-------+-------------------+-------------------+-------------------+
| Issue | Status 01.01.2019 | Status 01.02.2019 | Status 01.03.2019 |
+-------+-------------------+-------------------+-------------------+
| JP-1 | open | resolved | done |
| JP-2 | open | open | open |
| JP-3 | resolved | done | done |
| JP-4 | open | resolved | resolved |
| JP-5 | done | done | done |
+-------+-------------------+-------------------+-------------------+
ideally i would get something like:
+------------+------+----------+------+
| Date | open | resolved | done |
+------------+------+----------+------+
| 01.01.2019 | 3 | 1 | 1 |
| 01.02.2019 | 1 | 2 | 2 |
| 01.03.2019 | 1 | 1 | 3 |
+------------+------+----------+------+
Is there a way to achieve this?
Thank you and sorry for the clunky tables 