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.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Goal Seek in Excel, Iterative Macro

YLYONG
9 - Comet

Hi Alteryx Community,

 

I have simple workflow which I need help with on how to achieve the same outcome same as "Goal Seek" in Excel:

 

Change utilisation rate to match targeted utilisation rate of 85

By changing days cover

 

YLYONG_0-1632829953622.png

 

Thank you for your help!

2 REPLIES 2
YLYONG
9 - Comet

Hi Alteryx Community,

Plase can I get your help on this? 

Thank you

apathetichell
20 - Arcturus

check out the optimization tool. honestly the reason why you aren't getting any bites is that this isn't simple and getting syntax down for the optimization tool can be difficult.

Labels
Top Solution Authors