I am trying to compare the maximum value of a metric with a selected value of a metric.
Consider this my data:
Name Metric_1 John 50% Dave 60% Tom 55%
I'm trying to create a dashboard that would show how many percent
John is less than or greater than the maximum value of a
The dashboard should show the following data:
Metric_1 -10 %
Is it also possible to add the name of the
Name who holds the maximum value
Metric_1 so the dashboard would look like this:
Metric_1 -10 % Dave
John, because I only want to compare
John values, is 10% behind
Dave which holds the maximum value of 60%
Thanks for your suggestions.