# Drill through issue shows too many results

**URL:** <https://community.eazybi.com/t/drill-through-issue-shows-too-many-results/12135>\
**Category:** Questions & Answers\
**Tags:** multiple-dimensions, jira\
**Created:** [March 20, 2023, 4:34pm UTC](https://community.eazybi.com/t/drill-through-issue-shows-too-many-results/12135 "2023-03-20T16:34:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Niklas](https://community.eazybi.com/user_avatar/community.eazybi.com/niklas/32/9308_2.png) [@Niklas](https://community.eazybi.com/u/Niklas)\
**Post date:** [March 20, 2023, 4:34pm UTC](https://community.eazybi.com/t/drill-through-issue-shows-too-many-results/12135/1 "2023-03-20T16:34:04Z")

</div>

Hello, this is my first question within this community and I hope I’ll describe it clearly:

I try the following:  
A want to display the amount of tickets that match two criterias:

- specific word in summary
- issue resolved

For the first criteria I created a new calculated member within the dimension “Issue”:

```auto
Aggregate(
  Filter(
    [Issue].[Issue].Members,
    [Issue].CurrentMember.Name MATCHES ".*Logging.*"
  )
)

```

For the combination of the two criterias I created a new calculated measure:

```auto
([Issue].[LoggingIssue], [Measures].[Issues resolved])

```

The results shown in the table or within the line chart are correct, **BUT** when I select “Drill through issue” on any of the shown points within the chart the result lists of JIRA tickets are way too big. They seem to be the lists of any Issues resolved.

Any idea what I can change to get the same result related to the calculated amounts but with a correct list when I “Drill through issue”?

Thanks in advance,  
Niklas

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [March 27, 2023, 12:13pm UTC](https://community.eazybi.com/t/drill-through-issue-shows-too-many-results/12135/2 "2023-03-27T12:13:06Z")

</div>

Hi @Niklas ,  
Welcome to the eazyBI community! 👋

We strongly suggest NOT creating an aggregate member in the Issue dimension, as that can impact the performance of your reports. With larger complexity, the reports may slow down.  
The best would be to use JavaScript calculated field that would return you ‘true’ if the values matches `".*Logging.*"`

And then, use this field value in your tuple.

See a JavaScript example in this post:

> [@Filter open issue by summary](https://community.eazybi.com/t/filter-open-issue-by-summary/6046/2):
>
> Hi @karim , I don’t recommend defining such calculated members in the Issue dimension. They are a performance risk. If you don’t have the option to create a new custom field in Jira, define a new JavaScript calculated custom field in eazyBI. See more details on how to do that here - [JavaScript calculated custom fields - eazyBI for Jira](https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields). Add parameters similar to the one below to your eazyBI advanced settings: [jira.customfield\_developer\_issue] name = "Issue summary Developer" data\_type = "st…

best,  
Gerda // [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![Niklas](https://community.eazybi.com/user_avatar/community.eazybi.com/niklas/32/9308_2.png) [@Niklas](https://community.eazybi.com/u/Niklas)\
**Post date:** [March 27, 2023, 12:22pm UTC](https://community.eazybi.com/t/drill-through-issue-shows-too-many-results/12135/3 "2023-03-27T12:22:31Z")

</div>

Hi @gerda.grantina ,

thanks for your answer. I understand the performance risk and I already have created few custom fields with java script and I think I would be able to create this custom field too.

But my question wasn’t about performance but about the wrong list when using “Drill through issue”. I would like to understand if this is a bug of eazyBI or if I still have to correct my knowledge about how eazyBI works. With my current knowledge and even with your answer I still don’t know why I didn’t get the correct list even if the calculated result is correct.

Can you help me with that one too?

Thanks in advance and kindly regards,  
Niklas