Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

EazyBI - Time in each status

 

I'm new to EazyBi but trying to create a measure that will show how long each issue has spent in each status. i.e if an issue took 40 days from opening to close how do I show it spent 10 days in validation - 10 days in mitigation - 10 days in implementation etc.

Can this be done in EazyBI. 

Thanks

2 answers

1 accepted

2 votes
Answer accepted

Hi @James Weaver,

Yes, eazyBI can be used for that.

And it's relatively simple to set up. We use it for exactly that measurement.

Regards,

Gary

Do you have a demo or an example you can share?

@James Weaver - I have a word doc with some notes I made a while back. But can't attach here. If you share an email address I can forward it to you.

Like rateodoros likes this

Thank you - james-simon-weaver2@hotmail.com

could you send it t ome too? Please

thaynan@shift.com.br

Thank you

Hi Gary,

I would really appreciate it if you could share this with me as well.

ankit.mathur@wunderman.com

Olga Videc Community Leader Mar 20, 2019

Hello, 

Can someone share this doc?

Thanks 

Hi,

No need to share a document

In this case, you could ensure that eazyBI is installed, then create a report with a measure "Days in transition status" and "Transition Status" dimension in columns, and "Issue" dimension in rows.

you could also filter your report by measure "Issues resolved" (by selecting it from Measures, filtering report rows by it and then unselecting it, before you add "Transition Status" dimension) to show only resolved issues in the report.

It would calculate the time in the statuses which are completed (excluding the time in current status).

Martins / eazyBI support

 

days in transition status for resolved issues.png

Like # people like this

Hi, Gary. Would you please send me the doc to raphael.silveira@e-core.com? Thanks in advance.

Hello, everybody!

Would you please send me the doc to raphael.silveira@e-core.com? Thanks in advance.

@James Weaver @Olga Videc @Ankit Mathur @Steve McGee @Gary Pasquale

Hi, @Mārtiņš Vanags  thanks for your solution, works perfect for me.

But, this solution show de "natural" time spent issues in each states... If possible adapt this for the work day? , I need count only time between 8:00AM and 6:00 PM and only of monday to friday

f.e.:

ISSUE_XX1 ( In TO DO between Fri 12:00 PM to Mon 12:00 PM)

* Your solution Show: 72 Hours (3 Days)

* I need that show : 9 hours (6 hours Fri 12:00PM to 18:00PM + 3 hours Mon 9:00 to 12:00 PM)

It this possible ?

I would really appreciate it if you could help me.

Hi,

There is also a measure "Workdays in transition status" which would exclude weekends and holidays, but it would still count full days not working hours.

In order to calculate working hours (for only business hours), there would be a need for a more sophisticated calculation to extract working hours and it gets even more complicated if a user who transitions an issue is in a different timezone.

Unfortunately, I can't share some ready examples for such calculation but you could try reaching out to support@eazybi.com 

Martins / eazyBI support

Like # people like this

Can you plz share the document strawberry07girl@gmail.com

Hi!

Is this ready for public ? :) 

Otherwise, gonchik.tsymzhitov@itiviti.com

 

Cheers, 

Gonchik Tsymzhitov

Hi,

 

There is no such document as you might think.

Instead, please find our documentation page about historical measures:

https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history

 

And see multiple report examples on our demo account.
https://eazybi.com/accounts/1000/dashboards/14871-chart-types

Some useful discussions can be found also on our community page:
https://community.eazybi.com/

 

Martins / eazyBI support

Hi  : Wondering if you could help me here. I would like to display the time in status measure to nearest Tenth s. Eg: Display 288.6934 to 288.7. Thanks!

Edit: I have figured it out. 

Hi James,

 

It would be possible to use eazyBI and calculate the time issue spent in a specific status (or even calculate the average result on the project level) by importing issue change history.

Then you could use "Transition Status" dimension and measure "Days in transition status"

You could read more about the transition-related calculations here: https://docs.eazybi.com/display/EAZYBIJIRA/Import+issue+change+history

 

Please also check two eazyBI sample reports:

https://eazybi.com/accounts/1000/cubes/Issues/reports/145950-average-days-in-transition-status

and

https://eazybi.com/accounts/1000/cubes/Issues/reports/61947-days-in-backlog

 

Martins / eazyBI team

Good stuff.

"Average" is not as valuable as being able to get the actual, specific days in each status for each issue (and more importantly, for each type of work). 

Because when you are able to capture this - which we can do without software - you can

  • generate highly predictable forecasts
  • set reasonable expectations with customers and have everyone be happy
  • manage dependencies easily
  • allocate capacity effectively
  • significantly reduce (eliminate) risk of missing a due date
  • better define policies so staff can make decisions without waiting for managers
  • spend WAY less time estimating, and interrupting expensive people to estimate

etc.

Like rateodoros likes this

@Mārtiņš Vanags 

I tried to create a bar chart using the instructions provided by you in this thread to get the Average time spent by a set of resolved issues in each status for a given time period.

In Rows, I selected the below dimensions:

- Transition status ("All Transition Statuses"  member)

- Issue

- Time

In Columns,  I selected the below Measures:

- Issues Resolved

- Average workdays in transition status

 

I am able to get data when I filter by Month in Time dimension but get an empty table when I filter by Weekly Members or a custom hierarchy to get data biweekly.

 

Could you help debug this issue please ?

 

Thank you for your help !

@Ksethuraj 

Our sample reports on the demo account usually work for all default hierarchies from "Time" dimension?

But could you please share more details about your custom hierarchy for biweekly data?

There is no such hierarchy in the "Time" dimension as far as I know.

Martins

report with weekly hierarchy.png

The report works when I select a month or year or quarter from the Time dimension. As shown in the pic Monthly report. 

Time spent in each status_Monthly data.PNG

 

Then when I try to select All times under the weekly member in the Time dimension, I get an empty result like shown below in the weekly report.

Time spent in each status_Weekly data.PNG

Regarding the custom hierarchy member All times (2 weeks) , I used the instructions given in the below sample to get data for biweekly iterations. That gives me an empty result as well.

https://eazybi.com/accounts/1000/cubes/Issues/reports/103084-issues-created-bi-weekly

Thank you for the help. Let me know if you need more info.

Hi,

​Likely, the wrong level from the "Time" dimension is still selected in rows when you switch between hierarchies in page filter.


​Make sure that you have selected the level in the time dimension (when looking at rows) from the same hierarchy that is also used in the Page filter.
​That can be the case if the "Time" dimension is used in both rows/columns and pages.
​See the attached image.

Martins / eazyBI support

 

level from wrong hierarchy.png

Like Ksethuraj likes this

Thanks Martins , it worked! Appreciate your response.

Hello Martins, 

Is it possible to create a combined page filter for "Time" dimension to be able to filter both by monthly or yearly or quarterly level and the biweekly and weekly levels? 

Right now it seems like either one of these levels (All times or weekly or 2 weeks) can only be enabled as a page filter. 

My requirement is to be able to set up a filter for Time in the pages so that I can easily switch from Monthly/quarterly to weekly or biweekly views on the dashboards, without having to edit the actual chart.

 

Thank you!

Hi @Ksethuraj 

Unfortunately, you can't have a calculated member in page filter that would aggregate members from two different hierarchies.

Weeks and months/quarters are not from the same hierarchy therefore you can't have them both in one report as a page selection.

Perhaps a workaround is custom time hierarchies.

https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-AddcustomhierarchiestoTimedimension

Martins / eazyBI support

Like Ksethuraj likes this

Thank you Martins.

Hello @Mārtiņš Vanags 

Is it possible to rename the biweekly custom hierarchy that I had defined in Time dimension.

I would like to rename the highlighted custom hierarchy members

2W01, Dec 30 2019 to Iteration 1, Dec 30 2019

2W02, Dec 30 2019 to Iteration 2, Jan 13 2020

etc...

 

Biweekly custom hierarchy.PNG

Hi @Ksethuraj 

Unfortunately, It would not be possible to rename custom hierarchies in "Time" dimension.

The only workaround I could think of would be creating new calculated members and replace each member with a new name, but that would be a quite manual process. because every 2 weeks a new member automatically appears in the "Time" dimension.

https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions

Martins / eazyBI support

calculated member.png

Like Ksethuraj likes this

Thank you Martins!

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you