Box and Whisker Plot Not correct when aggregate

Options
user012140
user012140 Member
in Charting

I'm doing a box and whisker plot for number of followers each user has grouped by clients - so my chart is catergory names = Client, Column containing dataset = total followers. When I filter for individual clientname, the low, median, high values are correct but when I don't filter for a specific client and try to show all clients, the low value are all much higher and all the clients have the same low values. Not sure what's causing this.

Comments

  • GrantSmith
    GrantSmith Coach
    Options

    Hi @user012140 

    The box and whisker plot doesn't necessarily plot the min and max of your data but rather plots the 25th, 50th (median) and 75th quartiles. The whiskers are equal to 1.5 * the Interquartile Range (IQR) on either side. The IQR is the 75th quartile - 25th quartile (the size of the box).  When displaying all of your data you're adding more data points to your graph it affects the percentiles that are calculated. In turn this affects the IQR and will cause your whiskers to plot different values will all the data compared to a specific client.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
This discussion has been closed.

Categories