Calculated Measure shows issues that have moved issue types


#1

Hi,

I’m trying to create a report that shows Average Workdays in Transition Status for issues with Project = KAI and Issue Type = Project (see screenshot). Although I have filters for both Project and Issue Type, the report is showing JIRAs that were previously in the Project issue type but were moved to a different issue type. How do I remove these JIRAs from the report?

Thanks,
Breann


#2

Hi,

“Issue Type” dimension, when used with transition-related measures, would not just return issues based on current issue type. It behaves based on historical changes when used together with transition-related measures.

For your use-case, you could use eazyBI advanced settings (code below) to define new Javascript calculated custom field which you could import (select via import settings) as a separate dimension and then additionally add to page filters of your report to filter issues that are currently in “project” issue type.

[jira.customfield_curisstype]
name = "Current Issue Type"
data_type = "string"
dimension = true
javascript_code = '''
if (issue.fields.issuetype) {
    issue.fields.customfield_curisstype = issue.fields.issuetype.name;
}
'''

Martins / eazyBI support


#3

This is exactly what I was looking, @martins.vanags! Thank you so much.