Sensitivity Analysis

[AdamPaulauskas]

Hello, 

I'm wondering if there's a way in Alteryx to do a sensitivity analysis on specific columns in my dataset. I need to increase certain columns by various percentages all at once. For example, I have several years of data for Revenue, Assets, and Employee Headcount that are used in a threshold test to see if a project is in or out of scope. I'd like to understand the impact of increasing these categories by 5%, 10%, 15%, and 20%. Is it possible to use a batch macro to make these changes at once and then pass the updated data through the same threshold tests as the original data?

Thank you in advance

[alexnajm · Accepted solution]

@AdamPaulauskas great to see you on the Community! Absolutely - I would look at putting the current workflow into a batch macro, with your regular workflow having a list of those percentages. Then your Control Parameter in your batch macro would go and update a Formula that has a placeholder number and full it with your percentages. Getting Started with Batch Macros (alteryx.com)

If you wanted a quick answer though, you could just use a user constant in your workflow. Update it for one value, run your workflow to get the output, then change the value, run your workflow again, and repeat until you are happy with all runs! All About Constants (alteryx.com)