# \#mdx

**URL:** https://community.eazybi.com/tag/mdx/2.md?match_all_tags=true&page=1&tags%5B%5D=mdx

[Latest](https://community.eazybi.com/latest.md) · [Categories](https://community.eazybi.com/categories.md) · [Tags](https://community.eazybi.com/tags.md)

**Page:** 2

---

## [Counting issues transitioned from specific assignees to another one](https://community.eazybi.com/t/counting-issues-transitioned-from-specific-assignees-to-another-one/20333)

<div class="topic-metadata">

**Author:** [@Marilou](https://community.eazybi.com/u/Marilou)\
**Replies:** 3\
**Last updated:** [August 20, 2025, 6:53am UTC](https://community.eazybi.com/t/counting-issues-transitioned-from-specific-assignees-to-another-one/20333 "2025-08-20T06:53:22Z")

</div>

Hi, I would like to calculate how many issues per month were transitioned from Assignees XYZ to Assignee A. Since both transition to assignee and transition from assignee are measures, I can’t make a tuple out of it. …

---

## [Working with double dimension time and issue](https://community.eazybi.com/t/working-with-double-dimension-time-and-issue/20343)

<div class="topic-metadata">

**Author:** [@davidp](https://community.eazybi.com/u/davidp)\
**Replies:** 2\
**Last updated:** [August 19, 2025, 7:22am UTC](https://community.eazybi.com/t/working-with-double-dimension-time-and-issue/20343 "2025-08-19T07:22:59Z")

</div>

Hello, I want to list in a table all the issues that we should work on accross the months, according to Target Start and Target End properties from Advanced Roadmap. I have a calculated ‘IssueInPeriod’ which seems to w…

---

## [Risk Register Fields -Risk Reporting - Calculated Measure or Calculated Member](https://community.eazybi.com/t/risk-register-fields-risk-reporting-calculated-measure-or-calculated-member/14145)

<div class="topic-metadata">

**Author:** [@David\_Horne](https://community.eazybi.com/u/David_Horne)\
**Replies:** 18\
**Last updated:** [August 12, 2025, 7:55am UTC](https://community.eazybi.com/t/risk-register-fields-risk-reporting-calculated-measure-or-calculated-member/14145 "2025-08-12T07:55:12Z")

</div>

Hi team, I have been asked to better report on our risks within a Project, and I am struggling to achieve this in EAZYBI. What we would like to achieve is a Report by Issue Type (Risk) where we can summarize the “Inher…

---

## [Created Bugs vs Resolved Tasks by Affects Version and Fix Version](https://community.eazybi.com/t/created-bugs-vs-resolved-tasks-by-affects-version-and-fix-version/20280)

<div class="topic-metadata">

**Author:** [@egor.muradkhanyan](https://community.eazybi.com/u/egor.muradkhanyan)\
**Replies:** 1\
**Last updated:** [August 11, 2025, 8:40am UTC](https://community.eazybi.com/t/created-bugs-vs-resolved-tasks-by-affects-version-and-fix-version/20280 "2025-08-11T08:40:51Z")

</div>

Hello everyone, I need to create a report that will show how many tasks were closed and how many bugs were created in each version. The problem is that the created bugs need to be filtered by Affects Version, and the clo…

---

## [Sumar en grafico de linea](https://community.eazybi.com/t/sumar-en-grafico-de-linea/20263)

<div class="topic-metadata">

**Author:** [@Jorge\_Marambio\_Castr](https://community.eazybi.com/u/Jorge_Marambio_Castr)\
**Replies:** 1\
**Last updated:** [August 6, 2025, 11:28am UTC](https://community.eazybi.com/t/sumar-en-grafico-de-linea/20263 "2025-08-06T11:28:08Z")

</div>

Estimados, tengo este grafico Lo que quiero es sumar todos los casos de prueba, tanto los ejecutados como los no ejecutados. Actualmente, cuando marco solo los ejecutados, la línea roja (que representa los ejecutados…

---

## [Xray Test plan execution status](https://community.eazybi.com/t/xray-test-plan-execution-status/1574)

<div class="topic-metadata">

**Author:** [@ValorHeart](https://community.eazybi.com/u/ValorHeart)\
**Replies:** 26\
**Last updated:** [August 3, 2025, 11:32am UTC](https://community.eazybi.com/t/xray-test-plan-execution-status/1574 "2025-08-03T11:32:46Z")

</div>

Hello, The issue type “Test Plan” is presenting the latest tests execution status and also make some calculations, it looks like that: i would like to copy that kind of status and place it it eazyBI chart i know th…

---

## [Show only the initiative with the highest "No Tri" value per Team](https://community.eazybi.com/t/show-only-the-initiative-with-the-highest-no-tri-value-per-team/20282)

<div class="topic-metadata">

**Author:** [@Roniel\_Flegler\_Reic1](https://community.eazybi.com/u/Roniel_Flegler_Reic1)\
**Replies:** 2\
**Last updated:** [July 31, 2025, 3:41pm UTC](https://community.eazybi.com/t/show-only-the-initiative-with-the-highest-no-tri-value-per-team/20282 "2025-07-31T15:41:27Z")

</div>

Hi everyone, I’m trying to display only the initiative with the highest value of a custom measure called “No Tri” (which uses \[Measures\].\[issues created\], \[Fix Version\].\[T3.25\]) for each Team. The report rows are struc…

---

## [Need Help Optimizing a Formula](https://community.eazybi.com/t/need-help-optimizing-a-formula/20268)

<div class="topic-metadata">

**Author:** [@NextLife](https://community.eazybi.com/u/NextLife)\
**Replies:** 1\
**Last updated:** [July 24, 2025, 9:29am UTC](https://community.eazybi.com/t/need-help-optimizing-a-formula/20268 "2025-07-24T09:29:08Z")

</div>

Hello everyone Eazybi Community, I’m currently using the following formula, but I’m experiencing issues with the report charts not rendering due to memory errors and query timeouts. I’ve spent the last two days trying …

---

## [How to find words in "Description" field?](https://community.eazybi.com/t/how-to-find-words-in-description-field/20241)

<div class="topic-metadata">

**Author:** [@agreg](https://community.eazybi.com/u/agreg)\
**Replies:** 1\
**Last updated:** [July 18, 2025, 4:49pm UTC](https://community.eazybi.com/t/how-to-find-words-in-description-field/20241 "2025-07-18T16:49:44Z")

</div>

Hi! I’m trying create a measure which will help me with searching words in “Description” field I’ve made a measure which can find words in “Summary” field, but function “GetString” doesn’t show me the “Description”. Y…

---

## [Transition to status first date breaks whenever I try to aggregate](https://community.eazybi.com/t/transition-to-status-first-date-breaks-whenever-i-try-to-aggregate/20206)

<div class="topic-metadata">

**Author:** [@Gergo\_Cser-Kovacs](https://community.eazybi.com/u/Gergo_Cser-Kovacs)\
**Replies:** 2\
**Last updated:** [July 14, 2025, 1:15pm UTC](https://community.eazybi.com/t/transition-to-status-first-date-breaks-whenever-i-try-to-aggregate/20206 "2025-07-14T13:15:29Z")

</div>

I have two different reports. In one of them, I have a scatter plot of tickets, x axis is dates, y axis is the number of hours it took for the ticket to get in “In Progress” for the first time. For this, I have a calcula…

---

## [Labels create except some labels](https://community.eazybi.com/t/labels-create-except-some-labels/20180)

<div class="topic-metadata">

**Author:** [@Viviane\_Da\_Silva\_Mor](https://community.eazybi.com/u/Viviane_Da_Silva_Mor)\
**Replies:** 2\
**Last updated:** [July 7, 2025, 4:14pm UTC](https://community.eazybi.com/t/labels-create-except-some-labels/20180 "2025-07-07T16:14:58Z")

</div>

Hello! “How can I create a metric in eazyBI that considers all labels except those starting with ‘GV’?”

---

## [Exclude Outdated issues in Eazybi](https://community.eazybi.com/t/exclude-outdated-issues-in-eazybi/20164)

<div class="topic-metadata">

**Author:** [@Ajay](https://community.eazybi.com/u/Ajay)\
**Replies:** 1\
**Last updated:** [June 27, 2025, 6:13pm UTC](https://community.eazybi.com/t/exclude-outdated-issues-in-eazybi/20164 "2025-06-27T18:13:09Z")

</div>

Recently, while reviewing the reports, we noticed that many issues remain open for 1,000 or more days—these are outdated issues that have not been moved to “Done” or “Resolved.” To improve the accuracy of our reports, we…

---

## [Need Help with eazyBI Dashboard: Task Priority Visualization](https://community.eazybi.com/t/need-help-with-eazybi-dashboard-task-priority-visualization/20111)

<div class="topic-metadata">

**Author:** [@agreg](https://community.eazybi.com/u/agreg)\
**Replies:** 5\
**Last updated:** [June 23, 2025, 7:29am UTC](https://community.eazybi.com/t/need-help-with-eazybi-dashboard-task-priority-visualization/20111 "2025-06-23T07:29:14Z")

</div>

Hi, I’m having trouble creating a dashboard that shows the priority value of a task in each quarter. I need to figure out how to display tasks that have had their priority change over time - I need to show this on a gra…

---

## [Is it possible to obtain the information of the related jobs in a release?](https://community.eazybi.com/t/is-it-possible-to-obtain-the-information-of-the-related-jobs-in-a-release/20131)

<div class="topic-metadata">

**Author:** [@Patricio\_Gonzalez](https://community.eazybi.com/u/Patricio_Gonzalez)\
**Replies:** 3\
**Last updated:** [June 19, 2025, 1:04pm UTC](https://community.eazybi.com/t/is-it-possible-to-obtain-the-information-of-the-related-jobs-in-a-release/20131 "2025-06-19T13:04:35Z")

</div>

Hello, my name is Patricio, and I have a question. Is it possible to obtain the information of the related jobs in a release? A customer is asking me for this information and when I select the Release in a filter, it wi…

---

## [Counting sum of total open issues with a certain severity](https://community.eazybi.com/t/counting-sum-of-total-open-issues-with-a-certain-severity/20139)

<div class="topic-metadata">

**Author:** [@KimSe](https://community.eazybi.com/u/KimSe)\
**Replies:** 3\
**Last updated:** [June 18, 2025, 7:20pm UTC](https://community.eazybi.com/t/counting-sum-of-total-open-issues-with-a-certain-severity/20139 "2025-06-18T19:20:44Z")

</div>

Hi I need to count the sum of total open issues with a certain severity. I have made the following MDX but I currently only get “0” as a result. I am not sure if I am counting correctly or the my setup is unavailible to…

---

## [Backlog Burndown](https://community.eazybi.com/t/backlog-burndown/19489)

<div class="topic-metadata">

**Author:** [@felix.geelhaar](https://community.eazybi.com/u/felix.geelhaar)\
**Replies:** 2\
**Last updated:** [June 11, 2025, 2:24pm UTC](https://community.eazybi.com/t/backlog-burndown/19489 "2025-06-11T14:24:08Z")

</div>

Hi there, I’m currently struggling building a report that shows a burndown to a specific number, but not 0 by a target date. the 1st thing I’m struggling is to calculate a Measure that describes the specific number men…

---

## [eazyBI Community Day 2023: Hands on Training](https://community.eazybi.com/t/eazybi-community-day-2023-hands-on-training/12651)

<div class="topic-metadata">

**Author:** [@ilze.leite](https://community.eazybi.com/u/ilze.leite)\
**Replies:** 0\
**Last updated:** [May 19, 2023, 6:22am UTC](https://community.eazybi.com/t/eazybi-community-day-2023-hands-on-training/12651 "2023-05-19T06:22:26Z")

</div>

Hi! This is a script for Day 2 hands-on training. Step 1: You can use your own eazyBI account (only Jira Core standard measures will be used and dimension members names you can easily adjust). Or clone a traings accou…

---

## [Sum resolved story points for epics that have a specific label](https://community.eazybi.com/t/sum-resolved-story-points-for-epics-that-have-a-specific-label/20086)

<div class="topic-metadata">

**Author:** [@Spencer\_Tiller](https://community.eazybi.com/u/Spencer_Tiller)\
**Replies:** 1\
**Last updated:** [June 6, 2025, 6:42pm UTC](https://community.eazybi.com/t/sum-resolved-story-points-for-epics-that-have-a-specific-label/20086 "2025-06-06T18:42:44Z")

</div>

I am wanting to generate a calculated member formula that will find all stories under all epics that have a specific label and then sum the story points of those stories. When I have gotten the syntax correct, it does n…

---

## [Number of stories under Initiative](https://community.eazybi.com/t/number-of-stories-under-initiative/19956)

<div class="topic-metadata">

**Author:** [@mctaggartm](https://community.eazybi.com/u/mctaggartm)\
**Replies:** 6\
**Last updated:** [May 30, 2025, 9:02am UTC](https://community.eazybi.com/t/number-of-stories-under-initiative/19956 "2025-05-30T09:02:10Z")

</div>

Hi, I have a structure in Jira that is Agile Initiative → Epic → Story. What MDX do i use in a calculated measure to return the number of stories within a specific Agile Initiative with status ‘Ready for Development’? T…

---

## [Help filtering out epic issue types from a custom measure](https://community.eazybi.com/t/help-filtering-out-epic-issue-types-from-a-custom-measure/19939)

<div class="topic-metadata">

**Author:** [@tsusa](https://community.eazybi.com/u/tsusa)\
**Replies:** 4\
**Last updated:** [May 29, 2025, 3:43pm UTC](https://community.eazybi.com/t/help-filtering-out-epic-issue-types-from-a-custom-measure/19939 "2025-05-29T15:43:25Z")

</div>

Hi everyone — I’m working on a report that returns the oldest issue in “In Progress” status. There’s a page filter applied to limit results to Bugs, Stories, and Tasks, but Epics are still being returned unexpectedly. H…

---

## [List Xray TCs that are not PASS and not linked with open bugs](https://community.eazybi.com/t/list-xray-tcs-that-are-not-pass-and-not-linked-with-open-bugs/20022)

<div class="topic-metadata">

**Author:** [@cfousteris](https://community.eazybi.com/u/cfousteris)\
**Replies:** 1\
**Last updated:** [May 28, 2025, 12:53pm UTC](https://community.eazybi.com/t/list-xray-tcs-that-are-not-pass-and-not-linked-with-open-bugs/20022 "2025-05-28T12:53:17Z")

</div>

Hello, i would like to have a list of tests that are part of specific Test Executions, that are not PASS yet and are not linked to Open Defects. Everything is using Xray so links are made through Test Execution Details …

---

## [Need help in calculating members for three level hierarchy](https://community.eazybi.com/t/need-help-in-calculating-members-for-three-level-hierarchy/19917)

<div class="topic-metadata">

**Author:** [@ranjandutta](https://community.eazybi.com/u/ranjandutta)\
**Replies:** 2\
**Last updated:** [May 19, 2025, 12:47pm UTC](https://community.eazybi.com/t/need-help-in-calculating-members-for-three-level-hierarchy/19917 "2025-05-19T12:47:29Z")

</div>

I have three levels of hierarchy - Feature Link, Issue & Linked Defects. I want to generate a report to show - The number of Stories associated with each Feature The number of Defects and Test Cases associated with eac…

---

## [Average days in transition status till the end of period](https://community.eazybi.com/t/average-days-in-transition-status-till-the-end-of-period/19925)

<div class="topic-metadata">

**Author:** [@sn1ffer](https://community.eazybi.com/u/sn1ffer)\
**Replies:** 1\
**Last updated:** [May 15, 2025, 6:51am UTC](https://community.eazybi.com/t/average-days-in-transition-status-till-the-end-of-period/19925 "2025-05-15T06:51:26Z")

</div>

Hi! I need to build statistics to calculate the average time spent by a task in status, quarterly at the end of each period, taking into account all tasks. I plan to do it like this: Get all tasks created for the enti…

---

## [Calculate availability of Asset objects](https://community.eazybi.com/t/calculate-availability-of-asset-objects/19563)

<div class="topic-metadata">

**Author:** [@Cr0w](https://community.eazybi.com/u/Cr0w)\
**Replies:** 1\
**Last updated:** [May 14, 2025, 10:24am UTC](https://community.eazybi.com/t/calculate-availability-of-asset-objects/19563 "2025-05-14T10:24:59Z")

</div>

Hello, hope someone will be able to help. We have the following: A schema in assets with a set of machines A JSM project that logs issues with those machines Now we need to calculate availability of those machines in…

---

## [Show measure only to relevant value in Row](https://community.eazybi.com/t/show-measure-only-to-relevant-value-in-row/9606)

<div class="topic-metadata">

**Author:** [@Daniel\_Luevano](https://community.eazybi.com/u/Daniel_Luevano)\
**Replies:** 6\
**Last updated:** [May 14, 2025, 6:15am UTC](https://community.eazybi.com/t/show-measure-only-to-relevant-value-in-row/9606 "2025-05-14T06:15:56Z")

</div>

Hi, I created the calculated measure “CR NPS Detractor” that basically filter only the value of the Detractor option, this is my definition: Sum( {\[Customer NPS Rating\].\[Detractor\]}, \[Measures\].\[Issues created\] )…

---

## [How to create an Assignee - Epic table?](https://community.eazybi.com/t/how-to-create-an-assignee-epic-table/19923)

<div class="topic-metadata">

**Author:** [@Gergo\_Cser-Kovacs](https://community.eazybi.com/u/Gergo_Cser-Kovacs)\
**Replies:** 1\
**Last updated:** [May 13, 2025, 9:10am UTC](https://community.eazybi.com/t/how-to-create-an-assignee-epic-table/19923 "2025-05-13T09:10:46Z")

</div>

Hi All, I need a table where I can easily determine epics the assignees in my project are working on (indirectly via the issues assigned to them and linked to the epics). The rows should be the assignees, the columns sh…

---

## [Counting number of assignee under an epic](https://community.eazybi.com/t/counting-number-of-assignee-under-an-epic/19933)

<div class="topic-metadata">

**Author:** [@HRivest](https://community.eazybi.com/u/HRivest)\
**Replies:** 1\
**Last updated:** [May 12, 2025, 1:58pm UTC](https://community.eazybi.com/t/counting-number-of-assignee-under-an-epic/19933 "2025-05-12T13:58:43Z")

</div>

Hi eazyBI Community, I’m trying to count the number of assignees, but I want to exclude the “Unassigned”. Count( Filter( \[Assignee\].\[User\].Members NOT (“Unassigned”), \[Measures\].\[Issues created\] \> 0 ) ) But it …

---

## [Sum of bugs in parent AND child objects](https://community.eazybi.com/t/sum-of-bugs-in-parent-and-child-objects/19536)

<div class="topic-metadata">

**Author:** [@Paul44](https://community.eazybi.com/u/Paul44)\
**Replies:** 6\
**Last updated:** [May 12, 2025, 1:18pm UTC](https://community.eazybi.com/t/sum-of-bugs-in-parent-and-child-objects/19536 "2025-05-12T13:18:26Z")

</div>

I have an assets custom field which includes two objects: “services” and “components”. (This is not the in-built Jira component but our own assets object) Components are child objects of services. They include all the a…

---

## [How can I calculate the contractual penalties for issues that are in SLA breached?](https://community.eazybi.com/t/how-can-i-calculate-the-contractual-penalties-for-issues-that-are-in-sla-breached/4033)

<div class="topic-metadata">

**Author:** [@Fra](https://community.eazybi.com/u/Fra)\
**Replies:** 11\
**Last updated:** [May 9, 2025, 11:18am UTC](https://community.eazybi.com/t/how-can-i-calculate-the-contractual-penalties-for-issues-that-are-in-sla-breached/4033 "2025-05-09T11:18:20Z")

</div>

I would like to reproduce the following table and create the formula for calculating penalties: Type SLA A is within 4 working days, on the fifth day the penalty is 80 €, from the sixth day the penalty is 50 € Typ…

---

## [Sum of Hours for Issues with earlier due date](https://community.eazybi.com/t/sum-of-hours-for-issues-with-earlier-due-date/19935)

<div class="topic-metadata">

**Author:** [@canedha](https://community.eazybi.com/u/canedha)\
**Replies:** 1\
**Last updated:** [May 5, 2025, 8:13am UTC](https://community.eazybi.com/t/sum-of-hours-for-issues-with-earlier-due-date/19935 "2025-05-05T08:13:31Z")

</div>

Hi, I’m importing some Jira ticket with a couple of custom fields (import as Measure and property). I now want to show a list of all tickets (Issues in rows) with the following columns: “Name\_Val” (customfield string)…

[Previous page](https://community.eazybi.com/tag/mdx/2.md?match_all_tags=true&tags%5B%5D=mdx)

[Next page](https://community.eazybi.com/tag/mdx/2.md?match_all_tags=true&page=2&tags%5B%5D=mdx)
