Hello All,
I am trying to create Box plot in tableau using calculated fields.
Upper Whisker(Q3 + 1.5×IQR)
Upper Quartile-Q3
Median
Lower Quartile-Q1
Lower Whisker(Q1 – 1.5×IQR )
Can anyone help me to create box plot using these calculated fields.
When I create Box plot using tableau 'Show Me' tool,It is giving incorrect Upper and lower whisker values,
However I want values based on Upper Whisker(Q3 + 1.5×IQR) and Lower Whisker(Q1 – 1.5×IQR )
I have attached sample workbook.
Please help me to correct Upper and lower whisker values in tableau default box plot or let me know how to update in Box plot using field I created, so the values are correct.
Hello Abhaivir,
I believe the box plot is correct.
The result of the calculation might not exist in the data.
For example, the result of upper whisker of Furniture is 1,134. How ever there is no 1,134 existing. The values are ..., 992, 1,124, 1,228 ... The value nearest to 1,134 is taken for the upper whisker.
Regards
Lei