For example if there are 10 tasks i have done in total. And there are ratings for each calculated depending on my submission date.
I would like to show a final rating depending on these
Like out of 10 tasks, 6 are “exceeds expectations”, then my total rating is “exceeds expectations”.
This is the question, can you please help me with this
For example if there are 10 tasks i have done in total. And there are ratings for each calculated depending on my submission date.
I would like to show a final rating depending on these
Like out of 10 tasks, 6 are “exceeds expectations”, then my total rating is “exceeds expectations”.
Hello @SmritiDabar !
If your “Performance Rating based on submission” column is a relation column, you could assign a score for each of possible status and find out the average score of submitted task to display the final rating.
Here is a quick example to get you started :