Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi,
Currently in the attached workflow, I am creating a KPI1Rank and KPI2Rank columns by using a formula tool which assigns rank value based on a certain threshold:
As you can see, the thresholds 0, 3, 6 are currently hard coded as part of the formula
Is there a way to have it dynamically change (i.e have the users change the thresholds without having the change the values in the formula)
Thank you
Here's an interface asking for the 3 thresholds which default to your 0/3/6. These values (default or user changed) are then passed to the formula.
