how to filter different drop downs

[swapsingh2712]

Hello all,

I'm trying to create a workflow where user can select the manager name in the drop down menu and based on the selection it shows the all the analyst name that reports only to him in the next drop down. but it's not working.

basically this workflow will select the manager, analyst and then update the asset count.

once you select the manager name in the first dropdown, it should only show the analyst name that reports to him. after that it will update the asset count based on the selection.

I've attached my data set and alteryx workflow. please advise

Note:  The data set contains more then thousand values. I just provided few data vales in excel

regards,

swapsingh2712

[atcodedog05]

Hi @swapsingh2712 

This definitely seems like a job of chain apps.

Here are resources.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120 

A weekly challenge which had similar usecase : https://community.alteryx.com/t5/Weekly-Challenge/Challenge-218-Car-Sales-Reporting/td-p/580155

https://community.alteryx.com/t5/Videos/Chained-Applications/td-p/186301

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @swapsingh2712 

Here is how you can do it. Packaged workflow attached. 

Please use this guide to downgrade the packaged workflow https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

Hope this helps : )