Tableau not showing all data in box and whisker plot

Question

In Tableau, I want to create a box and whisker plot. So for that, I Drag out and drop the fields but it seems like firstly it removes the duplicates and then did its calculations. for example, two rows in my data set have the same value so it removes one and by using the second it did its calculations. This results in dissimilar means from the actual means.

I am not able to find out the problem that why it is not considering all of the data. Tableau should notify me before removing the duplicates. Can anyone help in this regards?

Answer 1

Plotting every data point and plotting a single aggregate point there is another way like, Put any combination of discrete (blue) fields in the visualization to group data points by those dimensions. for better understanding, if you drag and drop the state field in the details shelf, then you will see one data point which is summarizing every state instead of one for each and every state. This will help you to control the desired level of aggregation.

You can make a box and whisker plot if you have at least one measure or 0 Dimension. I am attaching below the screenshot of plot (4th one from last)

To learn more about Plots in a Tableau visualizations check it tableau training.