This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The highly anticipated Alteryx Community tradition is back! We hope you'll join us!
Go to Solution.
Go to Solution.
It looks like this post was missed originally. I've asked the Solutions Engineering team if anyone has used Alteryx in this way before.
I am interested in Alteryx and Control Charts.... a reply would be good.
Also Interested in this topic as it is a must-have capability for any worthwhile organization's optimization processes.
Another vote for this
But also, for run chart rules, see attached doc
Basically something that could check for
I need to do SPC on large datasets is this possible using an Alteryx workflow
Why yes it is but youll have to build it yourself.
i did one for run charts, to detect shifts (6 or more above or below median) and trends (5 or more all on one direction), min/max number of runs
Its the same logic to be able to do control chart rules.
just using formula to compare previous datapoint with current and testing the run chart rules in a column that adds one for every time theres a consecutive direction in the run.
Bit hacky but it works.
Can you share the Run Chart Alteryx file?
Also, how do you perform a WINDOW_AVG in Alteryx?
is it possible to share your workflow as i also need to do a more advanced version of SPC to detect shifts and trends
i've created a manual one myself that calculates Sigma, median and outliers above or below the Upper and Lower Control limits.
I am happy to share my version to the community if anyone is interested or could QA my SPC workflow.
I would love to see your version.
Thanks in advance.