Forum Discussion

zurimae's avatar
zurimae
Frequent Visitor
4 years ago

Averaging data by certain skill levels

Hi

I have need to combine data from  % within service level column by "stroke", "urgent" and "Emergent", everyday to get one "average" daily. example I need the total average of  Emergent % within service level "40", Stroke % within service level "77" and Urgent % within service level "64" for each day.  Is there an easy way to create a column getting this average from a select split skill?

 

Need Help

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi  zurimae 

    Thanks for reaching out to us.

    What is the numerator and denominator of total average? Can you share your mathematical formula for each Split/skill?

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.