Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Please Help me,
I want to know how many active employees get scores above 80? in my raw data in one month there are 2 score values, I'm confused about how to add avg in the formula, this formula is not working because all employee counts are supposed to be one employee only counts average
Count({<[EmpStatusByMonth] = {[Active]}, [Score MQ] = {'>=80'}>}DISTINCT [Emp No])
Thanks
May be this
Count({<[EmpStatusByMonth] = {[Active]}, [Emp No] = {"=Avg([Score MQ]) >=80"}>} DISTINCT [Emp No])
May be this
Count({<[EmpStatusByMonth] = {[Active]}, [Emp No] = {"=Avg([Score MQ]) >=80"}>} DISTINCT [Emp No])
Thank you for the information, this formula works.😊