Days with workload

Questions & Answers
1

Hi,
Is there any way to calculate how many days has an issue workloads. (workload is an hour spent).

If I have open a issue 10 days, but I only I have workloads on monday and friday, I want to have 2 as resultant

thanks

2

Hi @aelexpuru

If you are using Issues in Rows, you can define a new calculated measure in the Measures dimension with the following formula that would iterate through all the days between the Issue created date and now, and gather on which days there are some hours spent:

Count(
  Filter(
    [Time].[Day].DatemembersBetween(
      [Measures].[Issue created date],
      Now()
    ),
    [Measures].[Hours spent]>0
  )
)

Be sure to set the Formatting to Numeric → Integer for this formula.

​Let me know if this fits your use case or if you have any additional questions!
​Best regards,
​Nauris / eazyBI support

3

Thanks @nauris.malitis ,
that works weel, and know if I want to do the same but with [logged by] dimension. How many diferent colaborators have logged time in that issue?
Thanks