How to set the hours spent to a specific value?

Questions & Answers
1

Hi, All
I am facing trouble. For the hours spent, it only returns the hours logged by users. I want to add a condition when Hours spent is less than 8 and issue status is done, which hours spent equals to 8 if possible.

Thank you!

2

Hi @shengjie0624

Welcome to the eazyBI community!

You may want to create a calculated measure (in Measures) where you go through all “Done” issues and, for those issues, having logged any hours less than 8 hours, count full 8 hours, and the original logged work for the rest. Done issues without any hours logged, won’t be counted.
Notice, as this measure iterates through issues, it can be slow for a larger set of issues or in a complex report.

Sum(
--iterate through all issues
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issue status] = "Done"
    AND
    --filter for optimisation if Time dimension is selected
     case when [Time].CurrentHierarchyMember <> [Time].CurrentHierarchy.DefaultMember
     then DateBeforePeriodEnd([Issue].CurrentMember.Get('Created at'), [Time].CurrentHierarchyMember)
     else 1=1
     end
  ),
--sum 8 hours for issues having any value less than 8 hours, and original logged hours for the rest
  IIF([Measures].[Hours spent]<8,8, [Measures].[Hours spent])
)

Best,
Ilze / support@eazybi.com