Hi community,
we just implemented EazyBI in our JIRA and are really happy with it.
Nevertheless we are struggling with a report we would like to get. Let me explain what we want to know:
We want a report on a daily basis, how many tickets have been in a certain status (opened and reopened) in our JIRA ServiceDesk on January, 1st, January, 2nd, January, 3rd and so on. On the other hand, we want to know, how many of these tickets have been changed in status at these days (all other statuses than opened and reopened). We dont want to know how many tickets have been changed generally at these days. only these tickets wich have been in status opened and reopened at this exact day. When for example 4 tickets have been in status opened on January 1st, and all of them have been changed to work in progress at this day, we want a “0” in our report.
I dont know if I described it understandable, but I would be very happy about any replies 
Thanks!
Cheers,
Lars
One additional info:
We already found a report which would suit partly. We have a report about how many ticktes have been in status openend and reopened on January 1st, 2nd, 3rd and so on. BUT, they count up… The sum gets higher and higher.
01.01.19: 2
02.01.19: 3
03.01.19: 6
Our intention would be:
01.01.19: 2
02.01.19: 1
03.01.19: 3
Furthermore the report changes… So when a ticket which was in status open on 01.01.19 gets in “work in progress” on for example 10.01.19, the report changes and subtracts the changed ticket from the sum on 01.01.19
This should not happen. Do you know what I mean?
Hi @l.blaschka,
You can analyze a change history of issues over time using historical measures and dimensions. See the list of available measures and dimensions here: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history.
In your case, to see how many issues were in each status at the end of a period, you might want to use historical measure “Issues history” with dimension “Transition Status” (see picture below).
Check out also report example in eazyBI Demo account:
https://eazybi.com/accounts/1000/cubes/Issues/reports/50046-history-of-unresolved-issue-statuses
Feel free to explore other reports, to get more ideas on how to build reports. If you find something useful, you can export report definition and import it into your eazyBI (https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Exportandimportreportdefinitions).
Best,
Zane / support@eazyBI.com
