Forum Discussion
Average Data
All of this heavily depends on the context in which you're calculating this average. Is it only when you have a manager selected, or if no manager is selected, should it average all associates? Once you've selected a manager, should the comparison average never change?
So just to be clear, you have performance data for associates. Individuals are grouped under a manager. You want to display each individual's aggregate data in a chart, as well as displaying the same aggregate data for the entire team in the same chart.
Is this correct? What kind of visualization are you using? Do you still want the average of the team as a comparison line, or should the team show up as another "person" in the list alongside the associates it is aggregating?
Hello,
Thanks for the reply.
I am using a line chart, and a bar chart for different points of data. I would like the manager's team average to be shown when that manager is selected. I would prefer to have the average of the team shows as another "person" so we can compare side by side. In the excel example shown above that is what I created with the charts. I had a line for the average of the team that was always constant. Then I selected the average, and the associate in a slicer to compare.