Drill through worklogs shows more items then schould be

i’ve got a worklog report running. showing logged hours per project and only for the logged in user.

  • Pages: time selection works
  • Pages: Logged by “Eingeloggter User” is a calculated member: with this
[Logged by].[User].getMemberByKey(CurrentUser())
  • Rows is: “Project”
  • Dimension: Logged Hours

When I click on “Drill through worklogs” then it shows too much items, in sum its more than the 33 hours visible in this bar. Here it seems to show all worklogs wor the project for the specified time. (But the header in the table shown, indicates, that total should be 33 hours and only items for the “current user”. but it shows also items from other users.

When I click “Drill through issues” - or “Drill into”, then only items corresponding to the initial selection are shown which in sum are 33 hours.

is this a feature or bug or do i have to configure it differently? clicking on “Drill through worklogs” i would expect to see only the worklogs for the current user, which is the selection for the report?

thanks for your help.

Hi @Matthias_Schindler,

A warm welcome to the eazyBI community.

Thank you for bringing this to our attention. The combination of CurrentUser() and the approach eazyBI takes when drilling through worklogs from the measure “Hours spent” seems to produce this strange behavior.

Currently, I have identified two workarounds. The first uses the Logged by dimension both in report rows and pages, with the “User” level in report rows and the calculated member in the pages.

The other option is updating the Logged by dimension calculated member formula and putting the current statement inside the Aggregate() function. See the suggested formula below:

Aggregate({
  [Logged by].[User].getMemberByKey(CurrentUser())
})

I also registered a bug regarding your finding in our backlog. Currently, I don’t have any estimates as our developers will have a look at it.

Best,
Roberts // support@eazybi.com

1 Like

Hi Robert,

great thank for the solution which is totally fine for me. don’t need to wait for the fix of the bug :slight_smile:

Thanks for the quick help.
Matthias

1 Like

Hello @roberts.cacus,

we are facing a similar issue in our report (easyBI4Jira 6.6.0) with Time dimension as row and “[Measure].[Hours spent] over [Project]” as column.
Drill through Issues works as expected but drill through worklogs in project [abc] shows issues from other projects (e.g. [def] and [ghj]) in addition.

Do you have any further information about this bug and its current state?

Thanks a lot and best regards,
Sascha

Hi @swv,

We have fixed the bug, and it is deployed in Cloud versions of eazyBI. We are still in the process of finalizing the version for Data center and Server. We will let you know once it is released. Alternatively, you can watch the eazyBI for Jira app in the Atlassian marketplace - eazyBI Reports and Charts for Jira | Atlassian Marketplace.

Although, the bug was explicitly identified to the CurrentUser() function. Please share more details about your use case or open a support ticket at support@eazybi.com.

Best,
Roberts // support@eazybi.com

Hi @swv ,
I wanted to let you know that we have released eazyBI version 7.0 recently. We included in this version the bug fix for when the combination of CurrentUser() and drilling through worklogs for the measure “Hours spent” is used.

Please see a list of all changes: Changelog - eazyBI for Jira.

best,
Gerda // support@eazybi.com