nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

EazyBI - Time in Status

Ariel Rosa

Hello guys,

I have been looking for a config in EazyBI for a while now without success.

I need a way to calculate the average time issues stay in a specific status, like:

Bar 1 = Number of issues in 'To Do' Status
Bar 2 = Average time issues stay in 'To Do' Status

The 'Average Days in Transition' that comes as Default with EazyBI is not quite that, it calculates the average time is takes issues to get to that transition, if i'm not wrong.

Thanks for any insights on this issue.

Accepted answers

Lauma Cīrule

Hi Ariel!

The 'Average days in transition status' is the measure you are looking for. It is showing average days that issue stayed in status that is selected in Transition status dimension.

It is calculated when issue is transitioned from this status (when Transitions from status measure is recorded) and will be shown on Time dimension on date when transition from this status happened. If you are not using the Time dimension then the Average of 'all time' will be displayed.

Please see example report I created with To Do and In Progress statuses selected on rows. If you click on any of the bars and select 'Drill through issue' you would see which issues are included in the calculation and can go to JIRA to double check the time they they spent in status.

Please let me know if you have any additional questions!
Lauma / support@eazybi.com

All comments

Lauma Cīrule

Hi Ariel!

The 'Average days in transition status' is the measure you are looking for. It is showing average days that issue stayed in status that is selected in Transition status dimension.

Please let me know if you have any additional questions!
Lauma / support@eazybi.com

Lisa Reilly

Hi @Lauma

I am looking for the same thing as Ariel I think

Say in the example below I have To Do - In Progress - In Review - Done

I've created a report - see diagram:

bi.png

The Average days in transition status shows how long the issue spent in the previous transition.

Our WF goes - Input Queue > In Progress > In Review > Validation > Done.

DZ-1656 hasn't been In Review for 28.39d, that's how long it was In Progress, and it entered In Progress on 3rd July.

Is there a way to report on how long the issue is in the current status?

Thanks

bi.png

Lauma Cīrule

Hi Lisa! Unfortunately I do not see what Status dimension you are using. The Transition Status dimension should be used with Transition status measures to see historical values. For the current status you would use the Status dimension. Please see an example report here https://eazybi.com/accounts/1632/cubes/Issues#report/test%20days%20in%20current%20status that shows Issue current status and there is also a 'Days in Current Status' calculated measure that calculates difference from Status updated date until now. Please let me know if you have further questions regarding this! Lauma / support@eazybi.com

Lisa Reilly

Thanks Laura! I used one of the custom calculated measures you had added and will be using plenty more, thanks for sharing that report it's great!!

Lisa Reilly

Hello Laurma! I have been trying to do another report My WF is Input Queue > In Progress > In Review > Validation > Done. I want to get the average time it takes for issues to get from Input Queue to Validation (to go through part of the Workflow) Could you explain/do a sample report? It would be of great help I have a WF with about 20 steps in it and want to get the average time from Step 5 to Step 7, Step 11 to Step 15 and so on Thanks!!!

Daina Tupule eazyBI

We created a new report for tracking last status change.

Please see our new demo report "Days in current status" here:

https://eazybi.com/accounts/1000/cubes/Issues/reports/69885-days-in-the-current-status

Neil Zaccari

Hi there! I opened the report, but could not see any of the Colomes, Pages or Row configuration. What I really want is a used defined measure of the number of days in a status, NOT the Average. Is this possible?

Lauma Cīrule

The links in above answer are outdated. Please see the description of Average days in transition status here.

There is also a new example for a report with Days in current status. If you do not see values in this report, please check the last import date in analyze tab of the account - it might be that the latest values (e.g. updated in last 8 days) have not been imported.

Lauma / support@eazybi.com

Peter Andréasson_lk631t

Hi Lauma,

How could you combine Ariels example above as Bar 2 as bars and Bar 1 as line?
I can never get it to work together.

//Peter

Lauma Cīrule

Hi Peter,

To change the style of each measure, you can click on the label color box. See example here https://docs.eazybi.com/display/EAZYBI/Create+charts#Createcharts-Customizemeasuredisplayoptions and let me know if you have any other question about this!

Lauma / support@eazybi.com

hash_8u6uy9

hello all,

Need report to measure Time In Status --to create reports on issues that show how much time each issue spent on each status, each assignee or each group. This report can be used to identify bottlenecks in process, to measure performance or even for SLA targets.

Can we achieve through EazyBI??

Need helping answers!!

Thanks

Ramaiah Pendli_e9undi

Hi Lauma,

I need to calculate the total workdays age of each and every issues which i need to exclude the last status - closed, In that total age of one issue, i need to exclude one status stayed age.

This is required for SLA calculation and which I need to exclude the pending on customer issue, which tickets are moving to "Pending on Customer" status.

Thanks!

Daina Tupule eazyBI

I noticed several unanswered questions here.

1. from Neil. Days in a current status report shows an average calculation when you work with all issues grouped by selected dimensions on Rows. On an issue level it will show total days in status.

We made a new demo report Issue days in current status

2. from Hash. Time in status split by assignee, status, group. By default, eazyBI supports calculations for time in status. Default measures do not split this time by assignee. You can add a calculation during import to with calculated JavaScript custom field to split total resolution days of an issue by assignees. You can modify the code for any other scenario as well.

3. from Ramaiah. Total resolution days of issue, except time in statuses. You would like to use some custom calculations for this now. Here is an example calculation for total days in a set of statuses (cycle) for resolved issues. I have cycle defined by statuses In Progress and In Review:

IIF(
 [Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember,
 -- calculation for default time
 Aggregate({
 [Transition status].[In Progress],
 [Transition status].[In Review]},
 ([Measures].[Days in transition status],
 [Status.category].[Done],
 [Time].CurrentHierarchy.DefaultMember))
 /
 [Measures].[Issues resolved] ,
 -- per period calculation on issue level
 NonZero(AVG(
 Filter(
 Descendants([Issue].CurrentMember, [Issue].[Issue]),
 DateInPeriod(
 [Measures].[Issue resolution date],
 [Time].CurrentHierarchyMember
 )
 AND
 [Measures].[Issues resolved] > 0),
-- aggregattin list of cycle transtion statuses
 Aggregate({
 [Transition status].[In Progress],
 [Transition status].[In Review]},
 ([Measures].[Days in transition status],
 [Time].CurrentHierarchy.DefaultMember))
 )
 )
)

Daina / support@eazybi.com

Ramaiah Pendli_e9undi

Hi Daina,

For each issue, can we get how many days in that status like it should show for all status.

Thanks

Ramaiah Pendli

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration

eazybi

addon-com.eazybi.jira.plugins.eazybi-jira