How to get % of issues that were created and transitioned to Close status the same day (time)

Questions & Answers
1

Hello!
I need statistics in percent % that will show the percentage of issues created some day and transitioned to Close (the resolved measure doesn’t suits me) SAME day (24h).

What I’ve done:

NonZero(
        Count(
                Filter(
                        Descendants([Issue].CurrentMember, [Issue].[Issue]),
                        DateInPeriod([Issue].CurrentMember.get('Created at'),
                                [Time].CurrentHierarchyMember)
                        AND
                                ([Measures].[Issues created],[Status].[Closed]) > 0
                )
        )
)

the above code count issues in Closed status
then I tried to count
[Measures].[Closed]/[Measures].[Issues created]

but it’s not correct data. Any ideas?

2

Hi,

You are almost there!
You may want to use a measure “Issues closed”: please read about this measure in eazyBI documentation page: https://docs.eazybi.com/display/EAZYBIJIRA/Issues+closed+measure

In the calculation formula for “Closed”, you would use this “Issues closed” measure instead of the tuple of created and status Closed (as this tuple shows created on that day and currently closed issues, not closed on that day):

NonZero(
        Count(
                Filter(
                        Descendants([Issue].CurrentMember, [Issue].[Issue]),
                        DateInPeriod([Issue].CurrentMember.get('Created at'),
                                [Time].CurrentHierarchyMember)
                        AND
                                [Measures].[Issues closed] > 0
                )
        )
)

Then the percentage calculation should work fine.

Ilze
support@eazybi.com

1 Like
3

Ilze,
hi!
Thanks a lot. I’ll try!

4

Hi

How can I get the average in days in a month/week?
The code works perfectly fine on days.

Example
In a monthly period

image
image231×1264 27.6 KB

The total seems not correct since it is calculating the resolved and created on the same month.

Thank you so much :slight_smile: