# Count number of times a test case has been mentioned in other tickets

**URL:** <https://community.eazybi.com/t/count-number-of-times-a-test-case-has-been-mentioned-in-other-tickets/1122>\
**Category:** Questions & Answers\
**Created:** [October 10, 2018, 8:48pm UTC](https://community.eazybi.com/t/count-number-of-times-a-test-case-has-been-mentioned-in-other-tickets/1122 "2018-10-10T20:48:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fabian.lim](https://community.eazybi.com/letter_avatar_proxy/v4/letter/f/0ea827/32.png) [@fabian.lim](https://community.eazybi.com/u/fabian.lim)\
**Post date:** [October 10, 2018, 8:48pm UTC](https://community.eazybi.com/t/count-number-of-times-a-test-case-has-been-mentioned-in-other-tickets/1122/1 "2018-10-10T20:48:07Z")

</div>

I’m looking for a method to calculate how many times a specific “Test Case No” has been identified in various open/closed tickets:

- All tickets have only 1 Test Case Number (string) assigned to them
- Only the open tickets are listed on the table.
- Failure count is what I’m trying to determine (last column)

See example below of what I would like to achieve:

 ![image](https://community.eazybi.com/uploads/default/original/1X/0c0b9aaca8014bc7d85cb44da95752f8edf4d48f.png)

Any help is appreciated.

Thanks,

Fabian

---

<div class="post-metadata">

**Author:** ![fabian.lim](https://community.eazybi.com/letter_avatar_proxy/v4/letter/f/0ea827/32.png) [@fabian.lim](https://community.eazybi.com/u/fabian.lim)\
**Post date:** [October 12, 2018, 4:28pm UTC](https://community.eazybi.com/t/count-number-of-times-a-test-case-has-been-mentioned-in-other-tickets/1122/2 "2018-10-12T16:28:26Z")

</div>

An example:

 ![image](https://community.eazybi.com/uploads/default/original/1X/fff51b4df9b7a50267e71260a14b137a0142c9f5.png)

For SADM-2129 STC Failure Count should be 2 since the Test Case No “STC-621” is mentioned on SADM-2129 and SADM-2133.

---

<div class="post-metadata">

**Author:** ![fabian.lim](https://community.eazybi.com/letter_avatar_proxy/v4/letter/f/0ea827/32.png) [@fabian.lim](https://community.eazybi.com/u/fabian.lim)\
**Post date:** [October 17, 2018, 8:36pm UTC](https://community.eazybi.com/t/count-number-of-times-a-test-case-has-been-mentioned-in-other-tickets/1122/3 "2018-10-17T20:36:25Z")

</div>

Instead of using Eazybi, we used a SIL script custom field in Jira to calculate the counts and then imported it as a property.

---

<div class="post-metadata">

**Author:** ![ilze.leite](https://community.eazybi.com/user_avatar/community.eazybi.com/ilze.leite/32/19_2.png) [@ilze.leite](https://community.eazybi.com/u/ilze.leite)\
**Post date:** [October 18, 2018, 8:56am UTC](https://community.eazybi.com/t/count-number-of-times-a-test-case-has-been-mentioned-in-other-tickets/1122/4 "2018-10-18T08:56:16Z")

</div>

Hi,

You may want to import “Test case No.” as a dimension, and then, using this dimension together with measure “Issues due”, you would see number of unresolved issues per test case (for instance, in rows then would be STC-621 as a member of the dimension “Test case No.” and the value for it would be 2 (as a number of unresolved issues related to the test case)).

If it is not what you are looking for, please, contact [support@eazybi.com](mailto:support@eazybi.com) for more detailed assistance.

Ilze, eazyBI Customer Support