How can I create Historical Open Issues?

Hi, I have some problems creating one measure according what I want.

What I want is to create a measure which permit me to have the historical issues that were opened along the year.

The problem when I use the measure “Open issues” is if one of the issues close today, this issue dissapear and decrease the number of issues on the previous days. The chart is done daily so we can’t modify the issues on the previous days, but this measure modify the chart.

Hi @Guill0,

What’s your definition of issues “Open”?

If you mean when they were reported, you need to use the measure “issues created”. This will count on the date that the tickets were created.



1 Like


I wanted to add that Open issues gives the number of unresolved issues at the end of the corresponding Time dimension period. This means that if the issue is created on Aug 1 and resolved on Aug 4, it will show as open for Aug 1, Aug 2, and Aug 3.

I am unsure how you are stacking the issues from the screenshot, but maybe you are looking for issue status history. Please look at this demo report Unresolved issues by statuses over time - Issues - Jira Demo - eazyBI. While it shows the unresolved issue statuses over time, you can remove the resolution filter from Pages and see all issue statuses over time.

Lauma /

1 Like