Estimated hours disappear with "Logged By" dimension on

Hi everyone! :slight_smile:
I’m having some troubles with a report, and can’t understand what’s wrong.
I was asked to create a report that should display in which issues people logged the hours, the hours spent, the original estimated hours, and the remaining ones (plus more infos).
With only “issues” as dimension, I can see the requested infos:
When I put the “Logged by” dimension in “rows” or “pages”, the estimated and remaining hours disappear.

Why? :slight_smile:
Moreover, I’m thinking that the “hours spent” refers to the total logged hours, and not the ones logged by that specific user… Am I right?

Thanks a lot for the support! :smile:

Hi Roberto,

The Logged by dimension works together with Hours spent measure showing how much hours each user has logged (per issue, if issue dimension is also selected). The Original estimate, on the other hand, has “nothing to do” with the user who is logging the hours, it is the estimate for the issue, not the logging user. So if you look at Logged by All users level, you see the Original estimate, but when for an individual user, you only see the hours spent

Maybe the above is a better way of building the report as it shows the total logged hours and estimate as well as all the users and how much they have logged?

Or you can create a new calculated measure for Original estimate (and similar for Remaining estimated hours) that would ignore the Logged by user selected and show total Original estimate with the following formula

  [Measures].[Original estimated hours],
  [Logged by].DefaultMember

Lauma /

Thanks a lot, Lauma!
This worked absolutely GREAT! :star_struck:
And the explanation was perfect and clear!

Have a nice day :smile:

1 Like

Hi @lauma.cirule, I have a similar problem but I also have the Time dimension in the columns.
So I made this calculated measure:
But it appears empty.

Could you please help me with this issue?
Thank you!

Hi @glando!

In general, Time should not be a problem as the Original estimate is tied to Time on the Issue creation date.
Still, if you would like to ignore Time, it could depend on which Time hierarchy you have in columns, e.g., weeks?
If you wish to ignore the Time entirely, try specifying the current hierarchy:

  [Measures].[Original estimated hours],
  [Logged by].DefaultMember,

If this does not help, please give more details of what other dimensions you have on rows, columns, and pages. The whole report context plays a part in the final visible value.

Lauma /

Hi Lauma, thank you very much!
But it didn’t work :face_with_diagonal_mouth:
I have also the dimension Issue Type, so I added this dimension to the tuple, but it neither worked:

@glando ,

Thank you for the screenshot! I see you are using the Logged by and Logged by Group. Both of these dimensions are not related to the Original estimate. Please try the following formula where I removed the Time but added the Logged by Group:

  [Measures].[Original estimated hours],
  [Logged by].DefaultMember,
  [Logged by Group].DefaultMember

Several users can log hours to issue, but by default, Jira does not provide the option to estimate the Time per user. This is why Original estimate is not related to Logged by dimensions, but the above will show the Original estimate based on all other report context.

Lauma /

@lauma.cirule ,

Thank you!
I guess we are closer … now the measure appears, but the “All users” value is repeated for every user:


Hi @glando,

Yes, currently we are ignoring the Logged by users so the value shows the same as for all users. If you wish to put them in context, e.g. to get the original estimate from the issues this logged by user is assigned to, you would also need to specify it in the formula. Here are a couple of similar cases:

Lauma /