Ideas to create a new report

[gerda.grantina]

Hi @marcelomlo1,
Could you please tell me more about the report you want to achieve?

As measure 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:

How calculate issues which was in status, but now in different status

@tumcat 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…

How to count issues that had ever been reopened

Hi @liu.jingjing, 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: ( [Transition Status].[Reopened], [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.

best,
Gerda // support@eazyBI.com