Eazybi Report

[shaibaz Qureshi]

I am trying to create report using Eazybi for below columns I want original estimate and hours spent(logged hours in a ticket)for June on a cumulative basis for each project.

but I have given condition as if the data is added in the original estimate or hours logged in a ticket in the month of June that June.

2nd scenario if the original estimate is updated in the month of June but we have worked on the ticket in July and logged hours for the same, here if I select June eazybi only shows data in original estimate and if select July it shows hours spent.

How I can take out both the data in 2nd scenario?

[Janis Plume _eazyBI_]

Hi,

Different measures in the eazyBI data model work differently with the Time dimension.

Original estimated hours are shown in the period by the issue creation date, hours spent are shown by the period for which the timesheet is logged.

Custom formulas allow for redefining the standard measures and show the data in different periods.

The following custom formula shows the original estimate for all issues in the period where the issue had hours spent:

Sum(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
[Measures].[Hours spent]>0
),
([Measures].[Original estimated hours],
[Time].CurrentHierarchy.DefaultMember)
)

Note that this measure will count original estimate of an issue for all periods when it has a worklog.

Please contact support if you need further guidance on your report.

Kindly,

Janis, eazyBI