Outlier Detection Logic at Product/Store/Date level

[BrianJ]

@_mk7,

Wow, impeccable timing on this question. I have a YouTube video coming out on Enterprise DNA TV this Friday at 9am ET on almost this exact scenario. Here’s the initial post and solution that prompted me to make the video:

Dynamic grouping into quadrants

@Harvey, This question sparked my interest, so I built out a full sample application based on External Tools Practice Dataset. By adjusting the two sliders associated with the what-if parameters, you can define dynamically what constitutes an “outlier”. Those products that meet the outlier criteria will be colored red in the scatter chart. Below is a publish to web link, where you can play with the application. I’ve also attached the solution file so you can explore how I put this together. Ju…

This is a simpler case than yours, but the video deals with more complex, multidimensional scenarios that mirror your question. Please take a look at the above post, and if that doesn’t provide a sufficient solution for you and you need an answer before Friday am, let me know. Thanks!

• Brian