Forum Discussion

adb123's avatar
adb123
Frequent Visitor
4 years ago

calculating average with condition

I need to calculate the average work orders when the "schedule end date" <= "Required date"

 

work orders is a text field and the 2 dates are date fields 

 

any ideas on how to calculate it?

6 Replies

  • adb123's avatar
    adb123
    Frequent Visitor
    4 years ago

    Hi tamerj1  that is correct. I need a measure to caculate it. I need the average count if the condition is true 

     

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Thank you adb123 
      My question was on how do you define the average? What is the numerator? Is it the count or distinct count of work order ID's (if the condition is true)? and what is the denominator?

      • adb123's avatar
        adb123
        Frequent Visitor
        4 years ago

        The count of work orders where the schedule end date <= to the reqired date deviced by the total count of work orders

  • adb123's avatar
    adb123
    Frequent Visitor
    4 years ago

    The count of work orders where the schedule end date <= to the reqired date deviced by the total count of work orders