
1. Re: Box plot and outlier filter creation
swaroop.gantela Aug 14, 2018 5:48 PM (in response to Manon Grest)Manon,
I came across this knowledge base article that stated that
I think you will need to use WINDOW_PERCENTILE instead of PERCENTILE
Upper and Lower Hinge in Box Plot Different from PERCENTILE() Calculation  Tableau Software
I'm not sure if it is similar to your workbook, but I tried it with the SuperStore sample and it
seemed to work using
IF SUM([Sales]) >
(WINDOW_PERCENTILE(SUM([Sales]),.75)+1.5*(WINDOW_PERCENTILE(SUM([Sales]),.75)WINDOW_PERCENTILE(SUM([Sales]),.25)))
THEN "Outlier"
END
Please see workbook v10.3 attached in the Forum Thread.

278479upperhinge.twbx 1.2 MB


2. Re: Box plot and outlier filter creation
Manon Grest Aug 17, 2018 5:49 AM (in response to Manon Grest)Thank you for your help!
Indeed, WINDOW_PERCENTILE function is useful when you may have to change the data context (the dimensions). However, I also needed to get the same results but in a different view level, that is why after researches, it is necessary to use LOD (Level Of Detail) functions.