Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Efficiency calculation

Task Name Task Start Task End Student Student Start Date Student End Date Task 1 1/1/2017 Null Student 1 1/1/2017 4/1/2017 Task 1 1/1/2017 Null Student 2 4/2/2017 4/5/2017 ...
General Comment
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

How do you calculate Load% or Efficiency %?  Show the expected result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    It's basically calculating average number of tasks done by a student when he is working. This shall also get filtered by any date that I choose in the slicer.

    • afzalphatan's avatar
      afzalphatan
      Resolver I
      8 years ago

      Can you please show the expeceted result in a pic with intended formula

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Could you please show the output with the formula?

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      8 years ago

      OK, so COUNT of Tasks is you numerator it sounds like, what is your denominator? Since this is a %. Is it the COUNT of all tasks (regardless of student), the number of days the student is working?