How can I show number of open tickets at the end of each week in a graph on Jira Dashboard

[Marieke Cozijnsen]

I can retrieve the amount of tickets that were open at the end of each week using the JQL query of e.g.

Project = Y AND status was in ("Open", "In Progress") ON startOfWeek()

Project = Y AND status was in ("Open", "In Progress") ON startOfWeek(-1)

Project = Y AND status was in ("Open", "In Progress") ON startOfWeek(-2) etc.

Any way to show this in a graph on a Jira Dashboard? Or another way to do it instead of above formulas?

Preferably using a bar chart e.g:

[Thomas Heidenreich]

You could add a custum field, which is updated by workflow post functions.

[Mizan]

AFAIK an issue follows a single workflow at a time , Even if you are able to add another status field it will show the same status .

If you want you can set issue security level .