EDNA,
Good day. I’m attempting to create outlier detection logic similar to what is outlined within the Detecting and Showcasing outliers lecture, however, I’m having trouble applying the concepts within the lecture to my use-case.
In this situation, I’m trying to group high, low, and non-outliers based at the product/store/date level based on (1) the percentage difference between a forecast for a single product/store/date and the average of sales for the that product/store across multiple dates and (2) the forecast value itself. I’d then like to plot the data points in a scatterplot using the 3 outlier groupings.
I’ve attached sample data and .pbix. The sample data file contains an “Objective” tab which describes provides an example and the expected results.
OutlierEx.pbix (127.8 KB) SampleData.xlsx (13.8 KB)
Any assistance or guidance would be much appreciated. Thanks!