Possible filter values

[Sergio_V]

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?

[JordanB · Accepted solution]

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]

OK. Unique will do the trick. Thank you.