Assistance needed to create a work logged by users of a team report in eazyBI 4 Jira Datacenter

Hi,

We want to create a report that shows number of hours logged per issue by users of a particular team.

This is supposed to be done for every week and then it should show the percentage as well for the week.

I tried to modify the sample reports available in eazyBI but firstly it is showing no data if we select a month in the time dimension. The timesheets are submitted monthly.

For weeks it is displaying the results.

Secondly, I cannot see the required hours column though it was imported as a measure.

I am also curious to know how the report will behave if a holidays falls on any weekday. Will it calculate it accordingly.

Customer has also requested for sub team and the data should be visible as per the sub team. But couldn’t find any way to add sub team. If you have any suggestion for this pls provide.

Otherwise we will do it for teams itself. The customer has shared an image of what is expected to be in the report.

Regards,
Muddassir

Hello @qazimuddassir ,
“Tempo required hours” work with dimensions “Time”, “Logged By”, and “Logged by Team”. If you are filtering the report by any other dimension, then I suggest creating a new measure to ignore the that dimension selection. Use this formula to create a calculated measure in the Measure dimension: Calculated measures

([Measures].[Tempo required hours], 
[Dimension].CurrentHierarchy.DefaultMember)

Kind regards,
Gerda // support@eazybi.com