# \#mdx **URL:** https://community.eazybi.com/tag/mdx/2.md [Latest](https://community.eazybi.com/latest.md) · [Categories](https://community.eazybi.com/categories.md) · [Tags](https://community.eazybi.com/tags.md) --- ## [Drill-through list when setting dimensions for a text field](https://community.eazybi.com/t/drill-through-list-when-setting-dimensions-for-a-text-field/20786)
**Author:** [@sso](https://community.eazybi.com/u/sso)\ **Replies:** 3\ **Last updated:** [June 30, 2026, 10:06am UTC](https://community.eazybi.com/t/drill-through-list-when-setting-dimensions-for-a-text-field/20786 "2026-06-30T10:06:18Z")
I enabled the Jira text field named ‘PR’ as a dimension. Additional advanced settings: \[jira.customfield\_17131\] data\_type = “string” dimension = true The values ​​for ‘PR’ include TPHA, TPHB, TPHC, TPHD, TPHE, a… --- ## [Best way to report worklogs added AFTER resolution date?](https://community.eazybi.com/t/best-way-to-report-worklogs-added-after-resolution-date/20755)
**Author:** [@UmutEkinAL](https://community.eazybi.com/u/UmutEkinAL)\ **Replies:** 8\ **Last updated:** [June 3, 2026, 4:16pm UTC](https://community.eazybi.com/t/best-way-to-report-worklogs-added-after-resolution-date/20755 "2026-06-03T16:16:26Z")
Hi everyone, I need to build a report showing worklogs entered strictly after an issue is resolved (excluding the resolution day). I also need to see this data broken down by the “Logged by” and “Time” (Day level) dimen… --- ## [Comparing Team Capacity (Excel) with Hybrid Workload (Project + Squad Field) by Quarter](https://community.eazybi.com/t/comparing-team-capacity-excel-with-hybrid-workload-project-squad-field-by-quarter/20756)
**Author:** [@UmutEkinAL](https://community.eazybi.com/u/UmutEkinAL)\ **Replies:** 1\ **Last updated:** [May 15, 2026, 5:45pm UTC](https://community.eazybi.com/t/comparing-team-capacity-excel-with-hybrid-workload-project-squad-field-by-quarter/20756 "2026-05-15T17:45:15Z")
Hi everyone, I am looking for the best approach to build a capacity vs. workload report that compares planned figures from an external Excel file with actual Jira issues. My goal is to see a side-by-side comparison of a… --- ## [Help creating cumulative flow diagram](https://community.eazybi.com/t/help-creating-cumulative-flow-diagram/20744)
**Author:** [@Jrabellus](https://community.eazybi.com/u/Jrabellus)\ **Replies:** 6\ **Last updated:** [May 15, 2026, 1:42pm UTC](https://community.eazybi.com/t/help-creating-cumulative-flow-diagram/20744 "2026-05-15T13:42:17Z")
Hello, I’ve been having a huge problem for quite some time and have never found a solution. I’m trying to create a cumulative flow diagram in Eazybi, where I can see the bottlenecks by status, WIP, cycle time, etc., but … --- ## [Discrepancy Between Drill‑Through Issue Count and Expected Results](https://community.eazybi.com/t/discrepancy-between-drill-through-issue-count-and-expected-results/20734)
**Author:** [@NextLife](https://community.eazybi.com/u/NextLife)\ **Replies:** 1\ **Last updated:** [April 9, 2026, 11:25am UTC](https://community.eazybi.com/t/discrepancy-between-drill-through-issue-count-and-expected-results/20734 "2026-04-09T11:25:34Z")
Hello! eazyBI community everyone, I am encountering an issue with a bar‑chart report and would appreciate any guidance you can provide. Bar-Chart report Page Filters: Time Rows: Project, Group Columns: Measures In t… --- ## [How to add images~](https://community.eazybi.com/t/how-to-add-images/20728)
**Author:** [@sso](https://community.eazybi.com/u/sso)\ **Replies:** 1\ **Last updated:** [April 8, 2026, 12:54pm UTC](https://community.eazybi.com/t/how-to-add-images/20728 "2026-04-08T12:54:50Z")
Hi, I am making excellent use of Eazybi to display Jira data. However, I would like to add reference images for the data around the gadgets on the dashboard. I have not been able to find a way to do this. I would lik… --- ## [Sparkline Report by defined dates](https://community.eazybi.com/t/sparkline-report-by-defined-dates/20678)
**Author:** [@David\_Horne](https://community.eazybi.com/u/David_Horne)\ **Replies:** 2\ **Last updated:** [March 26, 2026, 7:41pm UTC](https://community.eazybi.com/t/sparkline-report-by-defined-dates/20678 "2026-03-26T19:41:27Z")
Hey team, I am trying to build a summary report that I can snip and share to a number of external reports. Sparkline reports seem to be favoured, but I want to define the time period as defined dates i.e. Increment One… --- ## [Reducing Report Load Time 7~8 sec – Help Optimizing](https://community.eazybi.com/t/reducing-report-load-time-7-8-sec-help-optimizing/20658)
**Author:** [@NextLife](https://community.eazybi.com/u/NextLife)\ **Replies:** 1\ **Last updated:** [February 20, 2026, 2:51pm UTC](https://community.eazybi.com/t/reducing-report-load-time-7-8-sec-help-optimizing/20658 "2026-02-20T14:51:04Z")
Hello eazyBI Community everyone! I am currently building a report in EazyBI. The Rows contains Measures dimensions, and the Columns contains the Group dimensions. The report includes the same SUM calculation about fou… --- ## [Grouping hours spent per Tempo Account through the hierarchy](https://community.eazybi.com/t/grouping-hours-spent-per-tempo-account-through-the-hierarchy/20649)
**Author:** [@FrancescoVl](https://community.eazybi.com/u/FrancescoVl)\ **Replies:** 5\ **Last updated:** [February 20, 2026, 7:36am UTC](https://community.eazybi.com/t/grouping-hours-spent-per-tempo-account-through-the-hierarchy/20649 "2026-02-20T07:36:49Z")
In JIRA, I have the hierarchy Deliverables - Epics - Stories - Subtasks. We’re using Tempo to register the hours spent and this can be done on each level: a programmer usually registers time on subtasks or stories. An an… --- ## [How to count issues by time since last update when Rows is not Issue](https://community.eazybi.com/t/how-to-count-issues-by-time-since-last-update-when-rows-is-not-issue/20644)
**Author:** [@Kawanaka](https://community.eazybi.com/u/Kawanaka)\ **Replies:** 1\ **Last updated:** [February 12, 2026, 12:38pm UTC](https://community.eazybi.com/t/how-to-count-issues-by-time-since-last-update-when-rows-is-not-issue/20644 "2026-02-12T12:38:59Z")
I am currently creating a table in eazyBI. My goal is to create measures that group issues by how much time has passed since their last update, so that I can follow up on issues that have not been updated for a while. … --- ## [EazyBI: Creating different labels per column in a table](https://community.eazybi.com/t/eazybi-creating-different-labels-per-column-in-a-table/986)
**Author:** [@Andre\_Freitas](https://community.eazybi.com/u/Andre_Freitas)\ **Replies:** 4\ **Last updated:** [February 5, 2026, 3:07pm UTC](https://community.eazybi.com/t/eazybi-creating-different-labels-per-column-in-a-table/986 "2026-02-05T15:07:23Z")
Hello, I’d like to know if there is a way to rename each column of a table differently. I have a calculated time as a dimension (containing the previous week, current week and next week as columns) and time spent as Me… --- ## [Exclude vacation weeks from calculation](https://community.eazybi.com/t/exclude-vacation-weeks-from-calculation/20622)
**Author:** [@Marilou](https://community.eazybi.com/u/Marilou)\ **Replies:** 3\ **Last updated:** [January 29, 2026, 4:57pm UTC](https://community.eazybi.com/t/exclude-vacation-weeks-from-calculation/20622 "2026-01-29T16:57:55Z")
Hi, I have multiple trend and predictions based on the last X time periods which currently include the 2 weeks of christmas break and it throws off my trends. Is there a way to exclude them from the considered time per… --- ## [Importing data from 3rd Party with custom dimensions](https://community.eazybi.com/t/importing-data-from-3rd-party-with-custom-dimensions/20606)
**Author:** [@oldmancook](https://community.eazybi.com/u/oldmancook)\ **Replies:** 1\ **Last updated:** [January 21, 2026, 11:40pm UTC](https://community.eazybi.com/t/importing-data-from-3rd-party-with-custom-dimensions/20606 "2026-01-21T23:40:09Z")
Hi. We use Jira extensively as our work tracking software. We have a 3rd party plug in called “productive.io” which is used to track time entries. This 3rd part system has an understanding of Customer, Project, Budget… --- ## [Getting median for Closed Tickets](https://community.eazybi.com/t/getting-median-for-closed-tickets/20550)
**Author:** [@Timi](https://community.eazybi.com/u/Timi)\ **Replies:** 3\ **Last updated:** [January 14, 2026, 11:04am UTC](https://community.eazybi.com/t/getting-median-for-closed-tickets/20550 "2026-01-14T11:04:15Z")
I’m trying to get median of closed tickets. I want to use IM Issues Closed, a calculated member, with the formula: NonZero(\[Measures\].\[Issues resolved count\] \[Measures\].\[IM Issues Resolved - dupe\] \[Measures\].\[IM Is… --- ## [Count of Total Stories Committed, Added & Removed during a sprint](https://community.eazybi.com/t/count-of-total-stories-committed-added-removed-during-a-sprint/20548)
**Author:** [@B.Roy](https://community.eazybi.com/u/B.Roy)\ **Replies:** 1\ **Last updated:** [January 10, 2026, 2:39pm UTC](https://community.eazybi.com/t/count-of-total-stories-committed-added-removed-during-a-sprint/20548 "2026-01-10T14:39:14Z")
I am trying to get the count of only stories Committed, Added & Removed during a sprint: I tried the following: (\[Measures\].\[Sprint Issues Committed\],\[Issue Type\].\[Story\]) + (\[Measures\].\[Sprint Issues Added\],\[Issue T… --- ## [eazyBI MDX: Dynamic Current Member in Filter() Always Returns 0](https://community.eazybi.com/t/eazybi-mdx-dynamic-current-member-in-filter-always-returns-0/20524)
**Author:** [@JAKO](https://community.eazybi.com/u/JAKO)\ **Replies:** 2\ **Last updated:** [December 17, 2025, 2:11pm UTC](https://community.eazybi.com/t/eazybi-mdx-dynamic-current-member-in-filter-always-returns-0/20524 "2025-12-17T14:11:42Z")
Hi there, I’m running into an issue in eazyBI with a Parent-Child setup in Jira: Hardcoded works perfectly: Count( Filter( \[Issue\].\[Issue\].Members, \[Issue\].CurrentHierarchyMember.Get('Parent link issue key'… --- ## [Filter based on past status](https://community.eazybi.com/t/filter-based-on-past-status/20509)
**Author:** [@dqng](https://community.eazybi.com/u/dqng)\ **Replies:** 2\ **Last updated:** [December 11, 2025, 9:20am UTC](https://community.eazybi.com/t/filter-based-on-past-status/20509 "2025-12-11T09:20:53Z")
Hi, I am trying to create some reports based on whether scheduled issues were completed by their target end date. I am quite new to eazyBI and MDX and finding it very difficult to use for anything more than trivial char… --- ## [Pivot table average](https://community.eazybi.com/t/pivot-table-average/19952)
**Author:** [@Patricio\_Gonzalez](https://community.eazybi.com/u/Patricio_Gonzalez)\ **Replies:** 1\ **Last updated:** [December 3, 2025, 9:54am UTC](https://community.eazybi.com/t/pivot-table-average/19952 "2025-12-03T09:54:42Z")
Hi my name is Patricio, I need please if you can help me with something that I have not been able to do. I need to get the total average, in this example it gives me 2.12 average in the header because it calculates all … --- ## [Translating a JQL with linked issue function to calculated measure](https://community.eazybi.com/t/translating-a-jql-with-linked-issue-function-to-calculated-measure/20500)
**Author:** [@divya.s](https://community.eazybi.com/u/divya.s)\ **Replies:** 1\ **Last updated:** [December 1, 2025, 4:05pm UTC](https://community.eazybi.com/t/translating-a-jql-with-linked-issue-function-to-calculated-measure/20500 "2025-12-01T16:05:30Z")
Hi all, I need some help translating this JQL to a calculated measure in eazyBI report so that i can filter issues based on labels of linked issues issueFunction in linkedIssuesOf(“type in (‘L1 Technical Feature’, ‘L2 … --- ## [How to import AgileHive Capacity to eazyBI?](https://community.eazybi.com/t/how-to-import-agilehive-capacity-to-eazybi/20482)
**Author:** [@Vijay\_Chandra](https://community.eazybi.com/u/Vijay_Chandra)\ **Replies:** 1\ **Last updated:** [November 21, 2025, 2:42pm UTC](https://community.eazybi.com/t/how-to-import-agilehive-capacity-to-eazybi/20482 "2025-11-21T14:42:59Z")
We use AgileHive on Jira DC which adds the capacity to the sprint properties. I am trying to get the capacity value from the sprint’s properties. Can you help please? https://jira.mycompany.com/rest/agile/1.0/sprint/533… --- ## [Calculated measure to filter tasks based on the status of a linked issue](https://community.eazybi.com/t/calculated-measure-to-filter-tasks-based-on-the-status-of-a-linked-issue/20490)
**Author:** [@divya.s](https://community.eazybi.com/u/divya.s)\ **Replies:** 1\ **Last updated:** [November 21, 2025, 2:39pm UTC](https://community.eazybi.com/t/calculated-measure-to-filter-tasks-based-on-the-status-of-a-linked-issue/20490 "2025-11-21T14:39:20Z")
Hello there, I am fairly new to eazyBI. I am trying to create a report that shows task status over time. But i only want to show tasks that are linked to features in status “Verification“ How would one go about this? … --- ## [How to reproduce Jira Control Chart “Average Cycle Time” in eazyBI](https://community.eazybi.com/t/how-to-reproduce-jira-control-chart-average-cycle-time-in-eazybi/20474)
**Author:** [@emersonsoaresdasilva](https://community.eazybi.com/u/emersonsoaresdasilva)\ **Replies:** 4\ **Last updated:** [November 20, 2025, 6:24pm UTC](https://community.eazybi.com/t/how-to-reproduce-jira-control-chart-average-cycle-time-in-eazybi/20474 "2025-11-20T18:24:33Z")
Hi everyone, Imagine you manage several Jira projects. Instead of opening the Control Chart in each project one by one to check their Average Cycle Time, I’d like to have a single eazyBI report that shows these values s… --- ## [Continuing the discussion from How to reproduce Jira Control Chart “Average Cycle Time” in eazyBI:](https://community.eazybi.com/t/continuing-the-discussion-from-how-to-reproduce-jira-control-chart-average-cycle-time-in-eazybi/20477)
**Author:** [@Kelvin\_Starcode](https://community.eazybi.com/u/Kelvin_Starcode)\ **Replies:** 0\ **Last updated:** [November 11, 2025, 11:48am UTC](https://community.eazybi.com/t/continuing-the-discussion-from-how-to-reproduce-jira-control-chart-average-cycle-time-in-eazybi/20477 "2025-11-11T11:48:49Z")
Continuing the discussion from How to reproduce Jira Control Chart “Average Cycle Time” in eazyBI: --- ## [Mismatch on count of issues from CFD versus the actual inflow/outflow](https://community.eazybi.com/t/mismatch-on-count-of-issues-from-cfd-versus-the-actual-inflow-outflow/20459)
**Author:** [@K\_D](https://community.eazybi.com/u/K_D)\ **Replies:** 4\ **Last updated:** [October 30, 2025, 7:38am UTC](https://community.eazybi.com/t/mismatch-on-count-of-issues-from-cfd-versus-the-actual-inflow-outflow/20459 "2025-10-30T07:38:52Z")
Hello all, I have 2 charts: cumulative flow of Problem Reports and Throughput chart showing of Inflow/Outflow of Problem Reports. However, comparing the data between these two, I see several discrepancies. Theumulative… --- ## [How to calculate Issue Aging from the last transition to Open (excluding Deferred time)](https://community.eazybi.com/t/how-to-calculate-issue-aging-from-the-last-transition-to-open-excluding-deferred-time/20424)
**Author:** [@B.Roy](https://community.eazybi.com/u/B.Roy)\ **Replies:** 3\ **Last updated:** [October 24, 2025, 5:01pm UTC](https://community.eazybi.com/t/how-to-calculate-issue-aging-from-the-last-transition-to-open-excluding-deferred-time/20424 "2025-10-24T17:01:05Z")
Hi Team I am currently using the pre-defined Average age days predefined measure to compute defect aging. However, I have an issue: For defects that were once moved to Deferred and then later brought back to In Progres… --- ## [Dynamic total of issue types count without using default eazybi total](https://community.eazybi.com/t/dynamic-total-of-issue-types-count-without-using-default-eazybi-total/20436)
**Author:** [@Naveen.Penta](https://community.eazybi.com/u/Naveen.Penta)\ **Replies:** 1\ **Last updated:** [October 9, 2025, 7:34pm UTC](https://community.eazybi.com/t/dynamic-total-of-issue-types-count-without-using-default-eazybi-total/20436 "2025-10-09T19:34:04Z")
Hi, How can we sum rows data to a new calculated member without using total. Row: Time Column: issue created,Issue type(bug 1, task 2, story 4 ,total 7) Column: Issue resolved, issue type (bug , task ,story,total) I… --- ## [Count issues in specific status at the end of each month (historically)](https://community.eazybi.com/t/count-issues-in-specific-status-at-the-end-of-each-month-historically/20426)
**Author:** [@Kal](https://community.eazybi.com/u/Kal)\ **Replies:** 4\ **Last updated:** [October 1, 2025, 12:03pm UTC](https://community.eazybi.com/t/count-issues-in-specific-status-at-the-end-of-each-month-historically/20426 "2025-10-01T12:03:25Z")
I’m currently building a dashboard which includes two reports that have been causing me a lot of trouble. The first report: A table with “Open Issues” in columns and “Status” in rows. I have two calculated measures in “S… --- ## [Workdays in specific status under predefined timeframe (period)](https://community.eazybi.com/t/workdays-in-specific-status-under-predefined-timeframe-period/17423)
**Author:** [@Ignas](https://community.eazybi.com/u/Ignas)\ **Replies:** 1\ **Last updated:** [July 31, 2024, 10:35am UTC](https://community.eazybi.com/t/workdays-in-specific-status-under-predefined-timeframe-period/17423 "2024-07-31T10:35:25Z")
Hey guys. I have a task under calculated measure creation. Lets say I need to gather all the workdays under status ‘In Progress’, during specific period of time. The main problem here, is that if the transition occurs, … --- ## [I am trying to calculate SLA Status but some of them shows wrong](https://community.eazybi.com/t/i-am-trying-to-calculate-sla-status-but-some-of-them-shows-wrong/20407)
**Author:** [@iclalaslan](https://community.eazybi.com/u/iclalaslan)\ **Replies:** 1\ **Last updated:** [September 18, 2025, 9:45am UTC](https://community.eazybi.com/t/i-am-trying-to-calculate-sla-status-but-some-of-them-shows-wrong/20407 "2025-09-18T09:45:53Z")
I have 4 statuses, and I measure the time spent until an issue passes through each status. If the issue is still in that status, I measure the time it has remained there. Each status has its own SLA time — for example, s… --- ## [I am trying to create a table showing Downtime by month - a bit stuck](https://community.eazybi.com/t/i-am-trying-to-create-a-table-showing-downtime-by-month-a-bit-stuck/20415)
**Author:** [@Terry86](https://community.eazybi.com/u/Terry86)\ **Replies:** 1\ **Last updated:** [September 12, 2025, 11:45am UTC](https://community.eazybi.com/t/i-am-trying-to-create-a-table-showing-downtime-by-month-a-bit-stuck/20415 "2025-09-12T11:45:18Z")
We have fields based on tracking an Outage Start and Outage End, along with separate fields tracking hours and minutes. What I cant seem to do is just create a simple table that will track the data based on the Outage S… [Next page](https://community.eazybi.com/tag/mdx/2.md?match_all_tags=true&page=1&tags%5B%5D=mdx)