Can anyone help me to understand if there is a way for me to create a report where I use the number of issues (issue count) that are In Progress (Transition Status must be In Progress) and Issues Resolved on that day? The problem is that for me to see the number of Issues Resolved, I must not exclude the status Done from my chart. What should I do in order to create a report using the timeline view?
Could you please tell me more about the report you want to achieve?
Issues resolved are counting those issues that have resolution and resolution date. On the Time dimension grouped by issue resolution dates. So it doesn’t exclude any statuses.
There are several ways on how to see issues that were in progress. See other community answers about those topics:
I understand you would like to represent issue current status and historical statuses. For current status representation, you may use dimension Status and measure Issues created. On the other hand, to analyze issue change history, you might want to use measures and dimension designed for that, like, dimension Transition Status and measure Transition from status issue count.
One approach would be to create two separate reports, one with the current status and another with historical sta…
To see which issues have been Reopened, you need to use Issue history change measures .
There are two ways how you can check if the issue was Reopened.
1.If you have a specific status for reopened issues, then by using that you can create this calculated measure in Measure dimension that checks issues that have been transitioned to it:
[Measures].[Transitions to status issues count]
2.Or if you count all issues that hav…
To give a better answer, it would be useful to get some more details about the final report you want to create.
Gerda // support@eazyBI.com