How to display issues dependant on their custom field values in reports

Questions & Answers
1

Hi there,

I’m fairly new to eazyBI and MDX.
How do I show/filter issues in dependance of their custom field values? For example I want to display all issues, where customfield “System Integration” == “Service Desk”.

Is my approach to create a new measure for each custom field value correct? For example I created a new measure for value = Service Desk. Upon selecting the measure only Issues with value “Service Desk” should be shown.

Here’s the code I used for creating the measure:

[Issue].CurrentHierarchyMember.get(‘System Integration’)
data_type = “string”
dimension = true
name = “System Integration”
javascript_code = ‘’’
if(issue.fields.customfield_15904) {
var jsonObject = JSON.parse(issue.fields.customfield_15904);
var sysInt = “”
jsonObject.forEach(function(value) {
if(value.Service Desk !== null) {
sysInt = value.Service Desk;
}
});
issue.fields.customfield_ttsWorkingDuration = sysInt;
}

Thank you in advance!

image
image1581×716 68.8 KB

2

Hi,

The custom fields from Jira should be possible to import with standard data import options:

image
image2030×1020 128 KB

The standard types of the custom fields are recognized and should be visible in the custom field list. The dimension contains all the values of the custom field as the members of the dimension.

Is there a reason to rewrite this field with Javascript?

Kindly,

3

Hi Janis,

thanks for your reply.
What fields are considered to be standard? For example field “System integration” is a text type customfield and it can only be imported as a property. Are dimensions only refering to select list fields?