I have been tasked with creating an Alteryx workflow that replaces an existing set of Excel calculations across multiple customers / data points. One part of the Excel sheet looks for outliers and uses the Quartile.EXC function to generate the values for the Quartiles (and then uses these to get the InterQuartile Range) for each vehicle. The default Alteryx calculation corresponds to Quartile.INC in Excel, which returns different values and discards data points that need to be kept. I have been through the Alteryx Community site and have tried multiple solutions presented in the past, without being able to duplicate the values Excel generates. Does anyone have a way to place a formula in Alteryx that will group data points by vehicle id and then calculate the 25th and 75th quartile values for each in a way that will match the Excel Quartile.EXC function?
