How to create a new member/measure to calculate the rate based on each categorize

Questions & Answers
1

Hi.
I have a database table like this. (Since we don’t use Jira SM, I had to create a new calculated members called “SLA Met”)

image
image1618×643 44.5 KB

Now I want to calculate the Met SLA rate which is
= Number of “Done” ticket & have SLA Met? is “Yes”/ total number of “Done” ticket
Or = Number of SLA Met? “Yes” ticket/ (Number of SLA Met? “Yes” ticket + Number of SLA Met? “No” ticket)
From this Met SLA rate I can create a chart to show the rate for each type of priorities and the trend of the rate for each type of priority.
Since I’m struggling to create a new measure or a new member to do that.
Can someone help me with this? I’m quite new to eazyBI.
Thank you so much.

2

Hi @Do_Thao

Welcome to the eazyBI community!

You would want to create a measure that iterates through all issues and filters them by “SLA Met?” to count resolved issues with the value “Yes”, then divide by all resolved issues (I imagine that “Done” issues means resolved issues). The formula would be the following:

CASE WHEN  [Measures].[Issues resolved]>0
THEN
Sum(
 Filter(
   Descendants([Issue].CurrentMember,[Issue].[Issue]),
   [Measures].[SLA Met?] = 'Yes'),
 [Measures].[Issues resolved])
/
 [Measures].[Issues resolved]
END

Set percentage formatting!
Hope it gives you the expected result!

IlzeLA
support@eazybi.com