Getting an overall percentage of conditions met

#1

I am creating a dashboard to show how our team is doing with training objectives. I have the percentage of training each person has completed, and am now trying to show that 37.5% of the staff met Q1 training goal (25% completed).
image

The count of "Q1 Goal Met’ is showing as expected – 3 people are over 25%
The % Met Q1 Goal is not working as I’d like it to. Currently I have the formula as
return
SUM($Q1 Goal Met$) / SUM(($Constant (1)$))

It gives the 37.5% for each person, a total of 300…and when I remove “name”, it gives me 100% (overall we’re at 36.9%). I know I must be close to the right way to do this, and am hoping someone can push me in the right direction.

#2

Hi Rachel,

If I understand your problem correctly, you may need to add another placeholder $Name$ in your formula. Your formula then being SUM($Q1 Goal Met$, $Name$)/SUM(($Constant (1)$))

With that formula, the results are shown below:

image

Hope this is helpful.

Derek

1 Like
#3

Thank you, that is very helpful! I appreciate your response.