Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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. 


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.



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 -

could you send it t ome too? Please

Thank you

Hi Gary,

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

Olga Videc Community Leader Mar 20, 2019


Can someone share this doc?



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 Thanks in advance.

Hello, everybody!

Would you please send me the doc to 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


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.


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 

Martins / eazyBI support

Like # people like this

Can you plz share the document


Is this ready for public ? :) 




Gonchik Tsymzhitov



There is no such document as you might think.

Instead, please find our documentation page about historical measures:


And see multiple report examples on our demo account.

Some useful discussions can be found also on our community page:


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 Weaver  @Gary Pasquale will you please share me the document  with me also it is so important for me please.Kindly share this to me to the following mail id.

Thanks in advance.

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:


Please also check two eazyBI sample reports:



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


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 !

@Karthiga Sethuraj 

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.


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.

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


​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 Karthiga Sethuraj 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 @Karthiga Sethuraj 

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.

Martins / eazyBI support

Like Karthiga Sethuraj 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



Biweekly custom hierarchy.PNG

Hi @Karthiga Sethuraj 

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.

Martins / eazyBI support

calculated member.png

Like Karthiga Sethuraj likes this

Thank you Martins!

Suggest an answer

Log in or Sign up to answer

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