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?
eazyBI calculates time spent per some transition for statues only based on issue changelog entries.
Please take into account, data structure on how Jira and eazyBI stores and tracks values for Assignee and Custom fields differs.
Here are some points you may want to check:
History entries contain to/from and toString/fromString values. Please use string representation for Custom fields, and to/from for assignee.
History entries reference custom field by case sensitive name. Assignee (other default fields) should be addressed in lower case. Please check how custom field current value is stored as well - data structures could vary by custom field type.
Daina / email@example.com