I am trying to create an auditing dashboard showing reports such as: how many features and stories are in the backlog, features that are open and are categorized as trivial, stories/features that are open and unassigned.
Any help with how to create these 3 reports is greatly appreciated. My company does not allow any custom reporting or importing any jira fields, so I am very limited to what is already available in Dimensions and Measures.
Hi,
There can be different solution to your report. Please find here some ideas for the solution. All of them can be implemented using tuples.
If the backlog is currently unresolved issues you may use the standard measure Issues due. You can join this measure in tuple with an issue type or an aggregated member in the Issue type dimension:
([Measures].[Issues due],
[Issue Type].[Feature])
+
([Measures].[Issues due],
[Issue Type].[Story])
You can extend the tuples further with other standard dimensions for your report (Priority, Assignee):
([Measures].[Issues due],
[Issue Type].[Feature],
[Priority].[Trivial],
[Assignee].[(unassigned)])
+
([Measures].[Issues due],
[Issue Type].[Story],
[Priority].[Trivial],
[Assignee].[(unassigned)])
Kindly,
Janis, eazyBI support