# Is there a way to see the number of tickets that span releases?

**URL:** <https://community.eazybi.com/t/is-there-a-way-to-see-the-number-of-tickets-that-span-releases/4465>\
**Category:** Questions & Answers\
**Tags:** fix-version, javascript, jira\
**Created:** [May 22, 2020, 3:26pm UTC](https://community.eazybi.com/t/is-there-a-way-to-see-the-number-of-tickets-that-span-releases/4465 "2020-05-22T15:26:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![leigh.crawford](https://community.eazybi.com/letter_avatar_proxy/v4/letter/l/e8c25b/32.png) [@leigh.crawford](https://community.eazybi.com/u/leigh.crawford)\
**Post date:** [May 22, 2020, 3:26pm UTC](https://community.eazybi.com/t/is-there-a-way-to-see-the-number-of-tickets-that-span-releases/4465/1 "2020-05-22T15:26:23Z")

</div>

We use fix versions to tag epics (and others) to a quarterly release plan. At times we miss delivery and we add another fix version to show it is now a part of a new quarter plan.

Example:  
UNI-1 is slated for Release 2020.1. It was not finished in 2020.1 and will be finished in 2020.2.

UNI-1 has Fix Version = 2020.1.

PO adds Fix Version 2020.2 to UNI-1, so now 2020.1 and 2020.2 are in the Fix Version field for the ticket.

I’d like to be able to report on the number of tickets that span multiple releases; what is the easiest way to do this?

Thank you!

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [May 29, 2020, 2:45pm UTC](https://community.eazybi.com/t/is-there-a-way-to-see-the-number-of-tickets-that-span-releases/4465/2 "2020-05-29T14:45:19Z")

</div>

Hi @leigh.crawford,

I understand that you would like to identify and count issues that have more than one Fix version.

One option is to create new calculated measures that go through all fix versions and count how many are related to each individual issue. This method works if you have individual issues on rows. Check out this community post for where is a solution how to Generate() the list of fix version, but you may use a similar calculation to Count() fix versions for each issue:

> [@How to display fix version of each issue in a cloum](https://community.eazybi.com/t/how-to-display-fix-version-of-each-issue-in-a-cloum/1151/2):
>
> Hi, This behavior seems related to the way how the Issue Fix version is calculated. Perhaps you have the formula like this in the calculation of the Issue Fix version: Generate( Filter([Fix Version].[Version].Members, [Measures].[Issues created]\>0 ), [Fix Version].CurrentHierarchyMember.Name, "," ) Note that this formula contains the condition on the Issues created measure which works fine with many of the standard dimension from the eazyBI data model. But you may check that the me…

A more convenient approach is to group issues by how many fix versions they have using **JavaScript calculated custom field**. Then you may import version count into eazyBI as **dimension** or **interval dimension** and use it to group and filter issues by fix version count.

There is an example of advanced settings with JavaScipt that counts how many fix versions each issue has and defined intervals 0, 1, 2 and more.

```
# count of fix versions
[jira.customfield_versioncount]
name = "Fix version count"
data_type = "integer"
dimension = true
intervals = "1,2"
javascript_code = '''
if (issue.fields.fixVersions) {
  issue.fields.customfield_versioncount = issue.fields.fixVersions.length;
} 
'''

```

More details on how to build, test, and import JavaScript calculated custom field is here:  
[https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields](https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields)

After data import, you can use the new dimension **“Fix version count”** to show how many issues get in each category, 0 versions, 1 version, or 2 and more versions. If you like, you may edit the intervals for version counts ([Interval dimensions](https://docs.eazybi.com/eazybijira/analyze-and-visualize/interval-dimensions)).

 ![image](https://community.eazybi.com/uploads/default/original/2X/5/50a819bbc76b918506fda444e49a5940c9fb80c9.png)

Best,  
Zane / [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [May 29, 2020, 2:49pm UTC](https://community.eazybi.com/t/is-there-a-way-to-see-the-number-of-tickets-that-span-releases/4465/3 "2020-05-29T14:49:18Z")

</div>

You may also check out topic on how to build histogram where is used similar approach:

> [@How to create a histogram](https://community.eazybi.com/t/how-to-create-a-histogram/323/2):
>
> Hello David, eazyBI by default imports any numeric value as a measure you will get total value from this custom field. Histogram chart should represent a count of issues with particular numeric value and split by another dimension. You would like to import your numeric custom field as a dimension or interval dimension into eazyBI to see how issues are split by particular values. Here is an example custom field definition that enables importing this custom field as a dimension (interval dimens…