Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to create a dynamic/easily changeable threshold?

johny9887
7 - Meteor

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:

johny9887_0-1658176215220.png

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 

1 REPLY 1
Robin_McIntosh
11 - Bolide

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.

Robin_McIntosh_0-1658179921924.png

 

Labels
Top Solution Authors