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!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
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