Hi everyone!
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.
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
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:
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.
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.
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:
