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
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
1 Like
This is exactly what I was looking, @martins.vanags! Thank you so much.