Get number of issues with status by date

[Alen Dibra]

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 :)

[Jack Nolddor _Sweet Bananas_]

Hi Alen,

Have you consider to use the Cumulative Flow Diagram instead?

Regards

[Alen Dibra]

i like it, but how would i get the raw data out of it?

[Jack Nolddor _Sweet Bananas_]

So you must go for eazyBI instead see:
History of Unresolved Issue Statuses  Chart

Try to press different Tabs:

• Table
• Bar
• Line

To see different representations of the data. You can also press the 'Export Data' button to export the contento to CSV, Excel or PDF file formats.

Regards

[Alen Dibra]

thank you, unfortunately not an option