Need help translating jql code into code for eazyBI

Colleagues, good afternoon!
I need your help in translating jql code into code for eazyBI.

Below is a jql query

“if (
( JQL {(project = S4SVS AND issuetype in (new_business requirement, “new_business requirement from SM”) AND (“Category of the effect of the change” in (“For clarification by the Product Owner”, “Needs to be clarified”) OR “The category of the effect of the change” is EMPTY ))});
1;
( JQL { (project = S4SVS AND issuetype in (new_business requirement, “new_business requirement from SM”) AND “Change effect category” in (Other) AND component = HCM)});
2;
(JQL { (project = “S4 launch for Severstal Group” AND issuetype in (New_business requirement,“New_business requirement from SM”) and “Category of the effect of the change” in (“Legal requirements”,“Audit recommendations”,“External client requirements”, “Risk reduction”,“Reduction of user errors”, etc.) AND “Text description of the effect” is EMPTY)});
2;
(JQL{( project = “S4 launch for Severstal Group” AND issuetype in (New_business requirement,“New_business requirement from SM”) and “Category of the effect of the change” in (“Additional income from the implementation / change of the process”,“Cost reduction from the implementation / change of the process”) AND the currency is EMPTY)});
2;
(JQL{(project = “S4 launch for Severstal Group” AND issuetype in (New_business requirement,“New_business requirement from SM”) and “Category of effect of change” in (“Reduction of labor costs”) AND Labor costs is EMPTY)});
2; 3)”

I need to create a measure for this request. Please tell me is this even possible? and whether you can help me.

All fields are custom fields, with a drop-down list.
this query should output values for a specific task using this data.

All these fields are used in my report, and additionally sprint, issue is used
Thank you for your help in advance

Hi, @jon33367

Most of the JQL criteria could be replicated in eazyBI as page filters. For example: Project, Issue type. Please see my collages training video here: Training videos on specific topics

Since your JQL is complex (have if, and values assigned based on criteria), please consider creating a JavaScript-calculated field to cover this. And import as a dimension: New calculated fields

Kindly,
Ilze support@eazybi.com

Good afternoon
Can you help me make up all these values?
I don’t think I have enough skills for this