Hi, I am working on a project that involves applying Western Electric Company (WECO) statistical control rules to a set of data to assess whether or not the data abides by these guidelines. For example, the goal would be to not have to manually assess whether these data points satisfy the statistical control rules, but rather to have PowerBI assess this and then report which rules are broken and under which data sets. Basically, it would be a type of early warning system. I had to manually form a data set and determine +/-1, 2 and 3 sigma lines based off a manual determination of the average or center line of the data to visualize whether WECO rules were broken (I had to look and see if 8 points were above/below the mean line, was 1 point above/below 3 sigma, etc., and then address that) Using the python tool, could PowerBI execute that same process by automatically determining and applying sigma lines for each dataset and then reporting which sets break these rules? Could it dig even deeper by applying filters within the same time interval and dataset to see if that would violate WECO rules as well? I am probably talking over my head with most of this, but I just wanted to see if this is possible. I assume it would involve python to determine which filters to apply/not apply. Thanks for the time and sorry for the wording, I am in a rush.
