Eazybi: Average WORKDAYS in transition status?

Be default a Measures calculated member exists which computes average days in status where status is defined via Transition Status selection.

I am trying to do this same activity but only looking counting Workdays. I feel counting weekends skew the results I'm looking for.

I found documentation for workdays in regards to task resolution, but have struggled when trying to apply it to days in transition status.

Average Resolution Workdays
Avg(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod([Issue].CurrentMember.get('Resolved at'),
[Time].CurrentHierarchyMember) AND
([Time].CurrentHierarchy.DefaultMember,
[Measures].[Issues resolved]) > 0
),
DateDiffWorkdays([Issue].CurrentMember.get('Created at'),
[Issue].CurrentMember.get('Resolved at'))
)

Has anyone done this before?

 

3 answers

Hi Neal!

At the moment, eazyBI does not have a convenient way to calculate Workdays in transition status. Such feature is added to the development queue, but I am not able to give you any forecasts yet.

As issue can get in and out of the status several times then "Days in transition status" is a pre-calculated measure used for 'Average days in transition status'. DateDiffWorkdays(), like DateDiffDays(), works between two dates, it can't be added to a single measure, like a "Days in transition status". 

Currently what I can suggest is to use Jira Misc plugin to calculate workdays in transition status. You can get the dates of transitions and calculate the workdays between these dates with this plugin and then import them to eazyBI.
More about Jira Misc https://docs.eazybi.com/display/EAZYBIJIRA/JIRA+Misc+Custom+Fields . 

If you are ready to use this plugin and would need assistance to create some calculations to get workdays in particular transition status, please let me know to support@eazybi.com!

Kind regards,
Lauma / support@eazybi.com 

hey Lauma,

Is there any update about this feature.

I would like to show working days in transition status too.

Thanks

Tal

hey,

I see that eazybi version 4.2.0 as well as in eazyBI for JIRA Cloud supports this feature.

Here's a post explaining how to enable it (look at the Time dimension section)

https://docs.eazybi.com/display/EAZYBIJIRA/JIRA+Issues+Import

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,042 views 13 18
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot