I am building some error checking into my data and one bit of checking that I want to look at is if the data has changed by a certain percentage. For example, I have a client with ten locations and they add two new locations to their data. When the workflow updates, the new locations will be added to the data set for a total of twelve. That's typical. However if the locations jumped by eight, or even an additional ten, that would be unusual. I want Alteryx to alert me to such a large change in the data.
In my example I used locations, but this could also be true for revenue, employee headcount, etc. I want to be alerted to large changes (something like 10%) from the previous day/week/month's data. Is there a way to do this within Alteryx?
