I am new to EasyBi. I am trying to build a report to show estimates hours vs logged hours by sprint and assignee. I’m finding it very difficult to try and build.
First, The sprints are showing from late 2022 and early 2023. Its not populating the most recent sprints. How do I get the most recent sprints to show?
Second, can anyone suggest any videos on how to build this report?
Hi @AnneDixon
Welcome to eazyBI community! Thanks for reaching out to us!
I suggest to check out this report in our Demo account - Sprint Time Tracking (Remaining Estimate) balance - Issues - Jira Demo - eazyBI. It seems to be something similar to what you are looking for. You will notice that the particular report is filtered for the last 5 boards.
You can add the Assignee dimension in Rows, to see the split per Assignee as well.
But please note that “Hours spent” measure collects the hours from the users who Logged them (Logged By dimension). Assignee might not always be the person who logged the hours.
If you want to show the hours spent per assignee, then you can use a calculated measure that will return the hours from logged by users and display them to the corresponding assignee member. See an example report here, copy the formula (“Hours spent by user”), and create measures (Calculated measures and members) in your report: Logged hours by user on assigned and unassigned issues - Issues - Jira Demo - eazyBI
Best wishes,
Elita from support@eazybi.com