Leaderboard

Jessica Howell

Hi All,

I'm looking to build a leaderboard that displays top performance by job function.

I am struggling due to there being multiple sheets, and the performance expectation for each job function is not the same. There are approximately 400 employees, but I'm looking to have 1 name displayed for each category, per period.... Keeping in mind there are 4 weeks in a period, and each colleague would have 4-5 data sets per week.

I'm wondering if anyone has any suggestions as per the best way to go about it? I can share some reference images if needed as well

Thanks!

Colleen Patterson

@Jessica Howell Please share some reference images to help visualize your ask.

Jessica Howell

@Colleen Patterson

I will try and break this down alittle better too...

I have a list of teams, i made this one as an example,

Each person on the list has a job function, and as per that job function has a performance score, in the form of a percentage

Ill use IP score for example,

Each User ID/ Name will have an STD score percentage, by week.

Essentially, at the end of each period I'm looking to update the week or period data at the top, and pull that persons total score for that time frame, and then have a leaderboard or ranking system so we know who the top performers are...

I hope this makes sense!

Colleen Patterson

@Jessica Howell To return the highest value in the array, you would want to use the MAX function, paired with Index to return the name value and week noted.

Then, you would want to write that formula into pulling in the return per sheet.

example:

=IF([Job Function]@row = "Job Name Here", MAX(COLLECT({Date Range}, {Employee IP Score}, @cell = Name@row))

Without knowing your exact column names, I am writing some of the above in generic, but something like that should work for you. You would need to point at your different source sheets.