EazyBI - MDX for In Progress Aging Tickets

unknown

Hi Experts, May I consult you about writing a MDX in EazyBI for a measurement of our team's current "In Progress Aging Tickets“？I want the measurement to meet the below two criteria:

1.Issues created >=30 days

2. Current issue status is all besides Resolved, Canceled, Closed, Complete, Not Applicable.

And I asked ChatGPT to write one for me however the MDX code it provided as shown in the below screenshot didn't work. Does anyone know what's the problem? Or how should I write the MDX for it? Many thanks!

Roberts Čāčus - eazyBI

Hi @[deleted]

A not too shabby result coming from ChatGPT. However, I would recommend a slightly different and easier-to-achieve approach. Presuming that an issue would receive a resolution date once entering one of the statuses you don't want to include, I recommend importing the issue age interval - https://docs.eazybi.com/eazybi/data-import/data-from-jira#DatafromJira-Additionaldimensionsforusergroups,intervals,andissuelinkfields.

The age interval will group unresolved issues by their age since the creation date. Once the age interval is imported, you can edit its interval - https://docs.eazybi.com/eazybi/analyze-and-visualize/interval-dimensions.

In your case, you want to group unresolved issues that are 30 days and older. The interval settings could look similar to the one below:

0,7,14,30

You can then use the Age Interval dimension member "30 - ..." to retrieve the desired number of issues:

Let me know how this goes.
Best,
Roberts // support@eazybi.com