# How do I remove merged issues within the Issues Created count

**URL:** <https://community.eazybi.com/t/how-do-i-remove-merged-issues-within-the-issues-created-count/14092>\
**Category:** Questions & Answers\
**Tags:** report-specific\
**Created:** [October 26, 2023, 5:59pm UTC](https://community.eazybi.com/t/how-do-i-remove-merged-issues-within-the-issues-created-count/14092 "2023-10-26T17:59:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paul\_Min](https://community.eazybi.com/user_avatar/community.eazybi.com/paul_min/32/10830_2.png) [@Paul\_Min](https://community.eazybi.com/u/Paul_Min)\
**Post date:** [October 26, 2023, 5:59pm UTC](https://community.eazybi.com/t/how-do-i-remove-merged-issues-within-the-issues-created-count/14092/1 "2023-10-26T17:59:14Z")

</div>

Hi there!

I have a issue in the rows column and issues created as a measure in column but one issue in the table is counting for two instead of one. I looked up the ticket in Jira and found it was merged with another duplicate ticket.

How can I remove the merged tickets to count just one?

I tried removing resolution != duplicate but that didn’t work and still showing as count = 2 for that one issue.

Any assistance will be much appreciated

---

<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 1, 2023, 2:17pm UTC](https://community.eazybi.com/t/how-do-i-remove-merged-issues-within-the-issues-created-count/14092/2 "2023-11-01T14:17:28Z")

</div>

Hi Paul,  
How exactly do you merge tickets in Jira? I couldn’t find this feature on my Jira sandbox environment.

Anyway, you can try using the **JQL** filter in the import options page to exclude duplicates from the import.  
[https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-JQLqueryfilter](https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-JQLqueryfilter)

Martins / eazyBI
