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 determine +/-1, 2 and 3 sigma lines based off a manual determination of the average or center line for a date set to visualize whether WECO rules were broken (I had to manually visualize 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 since there would be a determinatoin of which filters to apply/not apply, based on if they would violate the applied statistical control rules. Thanks for the time and sorry for the wording, I am in a rush.
