I’m trying to solve a problem where I need to report the total time Jira issues spend in certain “groups” until they are resolved. The different groups are pre-defined in a custom field; let’s call it “Resolver Group”. There’s a very limited amount of groups each issue can be in, and an issue can only be in a single group at any given time. I’m quite new to EazyBI and MDX, so my question is:
Is there any recommended way to tackle this problem?