# Calculated Measure shows issues that have moved issue types

**URL:** <https://community.eazybi.com/t/calculated-measure-shows-issues-that-have-moved-issue-types/1347>\
**Category:** Questions & Answers\
**Created:** [November 26, 2018, 8:41pm UTC](https://community.eazybi.com/t/calculated-measure-shows-issues-that-have-moved-issue-types/1347 "2018-11-26T20:41:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![breannmcjew](https://community.eazybi.com/letter_avatar_proxy/v4/letter/b/4491bb/32.png) [@breannmcjew](https://community.eazybi.com/u/breannmcjew)\
**Post date:** [November 26, 2018, 8:41pm UTC](https://community.eazybi.com/t/calculated-measure-shows-issues-that-have-moved-issue-types/1347/1 "2018-11-26T20:41:56Z")

</div>

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?

 ![33%20PM](https://community.eazybi.com/uploads/default/original/1X/828c91e17b64c7ee30d5383d9c7acbdffbcde4cd.png)

Thanks,  
Breann

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [November 29, 2018, 8:08am UTC](https://community.eazybi.com/t/calculated-measure-shows-issues-that-have-moved-issue-types/1347/2 "2018-11-29T08:08:36Z")

</div>

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](https://docs.eazybi.com/eazybijira/data-import/custom-fields/advanced-settings-for-custom-fields) (code below) to define new [Javascript](https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields) calculated custom field which you could import (select via [import settings](https://docs.eazybi.com/eazybijira/data-import/jira-issues-import#JiraIssuesImport-JiraCustomFields)) 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

---

<div class="post-metadata">

**Author:** ![breannmcjew](https://community.eazybi.com/letter_avatar_proxy/v4/letter/b/4491bb/32.png) [@breannmcjew](https://community.eazybi.com/u/breannmcjew)\
**Post date:** [November 29, 2018, 8:15pm UTC](https://community.eazybi.com/t/calculated-measure-shows-issues-that-have-moved-issue-types/1347/3 "2018-11-29T20:15:14Z")

</div>

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