Box and Whisker Plot Not correct when aggregate

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 Indiana 🔴

    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.

This discussion has been closed.