This content has been marked as final. Show 3 replies
I have a chart with Name as dimension, and bottom 3 names are displayed according to value compared to total avg of all values:
Every name is connected to a particular profession.
What I really want to do is to display the bottom 3 names that has the lowest value compared to the avg of the values in its own profession (not the total as it currently is). The fact that Adam is an accountant and Mike is a programmer should not stop them from appearing in the same chart.
Is this possible? I have been trying with set analysis for a couple of hours, but cannot get it to work. Any help is appreciated.