We haven’t had eazyBI for Jira very long and I am delving into understanding how to build custom reports. Can you help with:
How do I add a Cube?
How do I create a custom report with the following constraints:
Measures (6) specific Users
Stories and Tasks, only
Status = Closed
Time range = last 30 days
I have been through the guide, but am still doing something wrong. It “seems” all measurements are within the “Measures” area, but how do you add custom measurements? I.e., “Stories = Closed” is listed, but not “Tasks = Closed”. -please see below:
eazyBI created the new data cube automatically when you import data from the new data source for the first time.
In eazyBI reports, you can set dimensions for criteria on pages and use them to filter data by issue type, status, period, and other criteria. Those filtering criteria are applied to the measurements in the report. In your case, you might want to build a report like this:
Select measure Issues resolved and Issues closed on columns (as you already have done).
Set dimensions Status , Issue Type, and Project on pages. Then select values matching your criteria in the report filers.
Set Time dimension on pages as well and select member “Last 30 days”. Then you will be able to pick up “Last 30 days” also as filter value in the report.
On rows set Assignee dimension and bookmark specific users as you already have done.
To make the report more readable, you may order users by column “Issues resolved” or “Issues closed” value.