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

[tumcat]

Hi!

I am a very new in MDX queries.

I have a JIRA cube, and i try calculate a funnel of recruitment process.

I put to Rows Statu and calculated measures to Columns.

I was able to calculate how much is ish is now in the status (in), how many was in a certain status (Was Ping)
But I can not calculate the metric (Was In) how much ishju was in the status from Raw but now in a different status.

Please, help.

[zane.baranovska]

@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 statuses, and place then side by side in the dashboard.

Another approach would be to represent current and previous statuses in one report by defining new calculated measures for each status. For calculations, you may use a tuple of status and measure. For example, to count issues which are currently in status “In” the tuple might look like this:

([Measures].[Issues created],
[Status].[In])

To count issues which were in status “Ping” a tuple might look like this:

([Measures].[Transitions from status issues count],
[Transition Status].[Ping]) 

Best,
Zane / support@eazyBI.com

[Yuri_Sant_Ana]

Hello guys!

Please, may I have some help?

I have a workflow that an issue is sent to approval and may be rejected. If it happens, the issue must be re-worked by the agent and sent to approval again.
I would like to know how to count the number os issues rejected by time.

Something like:

[zane.baranovska]

Hi @Yuri_Sant_Ana,

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, you might want to use measure Transitions to status with dimension Transition Status or Transition.

Please see a similar use case here: Qa status not appearing in report.

Best,
Zane / support@eazyBI.com

[Yuri_Sant_Ana]

Hi @zane.baranovska
Thanks for the orientation.

One of my reports gave me as result the number 22 (it means that transition was used 22 times).
But, I would like to know how many issues did it.

As you can see in my image, the row count is 17. That is the value I’m looking for.
Some issues went through this transition 3 times.
How do I get this report?

[Yuri_Sant_Ana]

[zane.baranovska]

@Yuri_Sant_Ana, in this case, you can use measure Transitions to status issues count to get count of issues, which had transitioned to a particular status.

[Eduar_Londono]

Hello!

How can i count issues than pass to Done and then come back to In Progress o Pending?

Thanks!

[zane.baranovska]

Hi @Eduar_Londono,

You may also count issues that had a particular transition, like, from status “Done” to status “In Progress”. In that case, use dimension Transition and select transition of interest Done => In Progress.

Check out those community posts on similar use cases to count re-opened issues:

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…

Is there a way to count number of reopens in a sprint and how many times each ticket got reopened

[quote=“zane.baranovska, post:6, topic:340”] ([Measures].[Transitions to status], [Sprint Status].[Active]) [/quote Thanks Zane in advance for your support… Sorry for the ambiguity in the earlier query… here is what i was looking for i want to create a calculated member which gives the Reopened ‘count’ which is the aggregation of all the reopens which includes multiple times each issue got reopened and single reopen… Please note i wanted to use user defined calculated members rather than …

Best,
Zane / support@eazyBI.com