Forum Discussion

Barrie2020's avatar
Barrie2020
Frequent Visitor
6 years ago
Solved

Show Stats between hours completed

Hello   I currently have some data that each row contains a specific taskID number, there is a task Start and and Task complete column, and finally there is a tasklength column that shows how long ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Barrie2020,

    You can create 3 measures for calculating the count of this different task length type:

     

    tasklength<24 = CALCULATE(count('Task'[Task ID]),'Task'[TurnaroundTime(Hrs)]<24)
24<=tasklength<=48 = CALCULATE(count('Task'[Task ID]),'Task'[TurnaroundTime(Hrs)]>=24&&'Task'[TurnaroundTime(Hrs)]<=48)
tasklength<24 = CALCULATE(count('Task'[Task ID]),'Task'[TurnaroundTime(Hrs)]<24)

     

    Best Regards

    Rena

Barrie2020's avatar
Barrie2020
Frequent Visitor
6 years ago

Hi

 

Many thanks for your quick response

 

If it helps i already have a column that shows the time in hours, ee preview below

 

How can i create a bucket from this, i have not done switch buckets before, apologies

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Barrie2020,

You can create 3 measures for calculating the count of this different task length type:

 

tasklength<24 = CALCULATE(count('Task'[Task ID]),'Task'[TurnaroundTime(Hrs)]<24)
24<=tasklength<=48 = CALCULATE(count('Task'[Task ID]),'Task'[TurnaroundTime(Hrs)]>=24&&'Task'[TurnaroundTime(Hrs)]<=48)
tasklength<24 = CALCULATE(count('Task'[Task ID]),'Task'[TurnaroundTime(Hrs)]<24)

 

Best Regards

Rena