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!
Hi @Veronica Qu
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
WoW this is brilliant! Thanks Roberts, you are way more smart than Chatgpt lol. I will try it out with your method !! Really appreciate your answer!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.