We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Possible filter values

Sergio_V
5 - Atom

Is there a way to get a list of possible values before applying a filter ? E.g. in Excel after applying a filter when clicking on the drop down menu we get a list of all possible values if the data set is smaller.

In other words - How do I know what to filter for?

2 REPLIES 2
JordanB
Alteryx Alumni (Retired)

Hi @Sergio_V

 

You can use a unique tool on the field you wish to filter on or use the summarize tool and do a group by function on that field.

 

You can add this tool off your main workflow so you can see the values.

 

Best,

 

Jordan Barker

Solutions Consultant

Sergio_V
5 - Atom

OK. Unique will do the trick. Thank you.

Labels
Top Solution Authors