How to filter specific issues as a calculated member

Hello friends! I hope you are doing well.

I’m newbie in EazyBI. Likewise, I know how to use my dimensions and members, and sometimes I create a dimension, with your help.

I would like help in getting an information that I think is simple.

Context:
My issues have a custom field called “escalation”, a data field. What I want is to get only the issues that have this custom field “escalation”.

Problem:
I want to get the average SLA and time in status transition, but only from those issues with “escalation”. But, when I have Issue Type in the Rows, eazybi gives me the average of all issues, not just the ones with “escalation”. And doesn’t matter what SLA measure I use, it will always give me the average of them all.

Objective:
I managed to create a measure that only calculate the average of those issues, returning no data for the others. So, I want to cross this measure with the Issue Type that only considers these specific Issues with “escalation”.

So, how do I create a custom member that uses Issue Type from a subset of all my issues?

Hi @Filipe_Oswaldo_Lima,
You can import “Escalation” in your account as a dimension and use it as a filter parameter.
Or you can create a JavaScript field that would only return Yes/No values if the “Escalation” field is or is not empty in your issues.
Add the below custom field definition to eazyBI advanced settings or ask Jira administrator to do this for you (only Jira administrators have access to eazyBI advanced settings).

[jira.customfield_escalated]
name = "Escalated"
data_type = "string"
dimension = true
javascript_code = '''
var escalated = issue.fields.customfield_NNNNN;

if(escalated){
  issue.fields.customfield_escalated = 'Yes' 
}
else{
  issue.fields.customfield_escalated = 'No' 
}

'''

Don’t forget to change NNNNN to customfield ID.

Further, you need to select the custom field for import as a dimension in eazyBI source data import.

Then use it in Pages to filter only escalated issues:

best,
Gerda // support@eazyBI.com

1 Like

Woah! Perfection, Gerda!
Thank you very much :heart:

1 Like