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:
([Measures].[Issues created],[Status].[Closed]) > 0
the above code count issues in Closed status
then I tried to count
but it’s not correct data. Any ideas?
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):
[Measures].[Issues closed] > 0
Then the percentage calculation should work fine.
Thanks a lot. I’ll try!
How can I get the average in days in a month/week?
The code works perfectly fine on days.
In a monthly period
The total seems not correct since it is calculating the resolved and created on the same month.
Thank you so much