Hi,
I would like to recreate the results of this Jira report in EazyBI. Is there a way to do it?
JQL code: project = “Group Marketing Production Projects” AND status was “Change Request Review” AND (labels not in (ignore, Ignore) OR labels is EMPTY) AND status = draft AND status changed to draft before startOfDay(-3) ORDER BY “Start Date”, key DESC
Many Thanks
Carly
Hi @CarlyBooth ,
Much depends on the desired report structure. For example, if you want to recreate the Jira report with the Issue dimension in rows, you can add the Status dimension in pages to filter the issues by the current status.
Next, you can add the “Issue labels” property and use the filter rows options with the “Not matches” operator to exclude issues with certain labels.
Up until now, the report could look similar to the one below:
To see issues that have transitioned out of a particular status, define a calculated measure with the formula below:
([Measures].[Transitions from status],
[Transition Status].[To Do])
To see the number of days since the issue was transitioned to the status currently selected in pages, define a calculated measure with the formula below:
DateDiffDays(
([Measures].[Transition to status last date],
[Transition Status].[Transition Status].GetMemberByKey(
[Status].CurrentHierarchyMember.Key
)
),
Now()
)
Again use the filter rows option to return relevant results. To get the desired project issues, you can select the Issue dimension simultaneously in rows and pages. See the result below:
Update the formulas to fit your use case.
See more details in the eazyBI documentation on the filter rows option and using a dimension simultaneously in rows and pages.
Best,
Roberts // support@eazybi.com
Thank you! very much. Useful
