How to compare individual value to the overall team's value using QS insights


I have the following scenario: I need to send a weekly report to users regarding their productivity for the previous week, which contains their individual percentage as well as the percentage of their entire team. (I already have the RLS configured, as well as a filter just for the previous week).

I would like it to be something like this:

"Your productivity for previous week is XX%. Your team overall productivity is XX%. "

I tried using the metric comparison insight, but it doesn’t let me use 2 Categories (‘user’ and ‘team’), it asks me for 2 values instead.

How can I compare the individual user’s productivity % to the overall team productivity %?

Thanks in advance!

Why can’t you make two calculations?