Hey @vdix, unless I'm misunderstanding the request, it sounds like you want to create an App here instead of a macro, as you require User Input. Whilst learning Alteryx, I built a simple app that does what you seem to be asking - creating a list of unique values in a field that is then presented to the end user to filter on, with the option to select multiple from a List Box. In my example, I just want to be able to filter the list of coffee shops by market:
To create the list, group by the target field twice - I tend to just call them Name/Value for ease:
Next step is to Cross-Tab the data so that you just end up with a single row of data, with each cell matching it's header:
Now, as you want to be able to select multiple, this method relies on you using a filter with the 'IN' function, rather than Contains() or =.
When it comes to configuring the List Box tool, you'll want to select Generate Custom List and leave the 3 boxes as is. All this is doing is adding the relevant punctuation before/after/between each selection, as when you run the app with multiple markets selected, you'll end up with an expression like [Market] IN ('North', 'South', 'West') under the hood, where Alteryx has automatically placed ',' between selections, and ' at the start and end.
In your Action tool configuration, you're going to want to replace the expression value and you need to tick to Replace a specific string, as you only want your selection to effect the part of the expression within the brackets (which in this case is 'South').
When you come to Run as Analytical App (the magic wand icon next to 'Run'), your end user will then be presented with the list of all possible markets (or whichever field you want them to filter on).
And in the resulting document, you'll see that there are only records relating to the selected values (South & East in this case).
If we open the app in Debug mode, using the same selections, we can see what I was talking about earlier, where Alteryx has automatically populated the 'IN' expression with the selected values, with the correct punctuation around these to build the filter expression correctly.
I've attached my demonstration app for you to play with/reverse engineer. Hope this helps but do let us know if not!
