I have been struggling to create a parameter and a calculation to get visualization like the one below:
I created donuts charts before, but I do not know how to make it so it links the common strengths and themes of each employee and calculates their similarity score..
I have found that I need a parameter and a calculated field, but I am not sure how to create them. The maximum score that each employee can have is 75. Each common strength is 15 points, and a common category is 5 points. So if employee does not have a strength but fall in the same theme they still earn points.
Any suggestions are welcome!
Thanks in advance!
This is an interesting question, can you provide a sample workbook?