Alteryx Gallery - Large Data Source to be completely customizable

Question

Hi,

I've got a very large data set which none of my internal customers can currently use as it crashes their laptops. I want to make a gallery view that is similar to what you'd see on a retail website, where you can choose to filter on anything you want and it will give you a drop-down of all the possible options (possible filter for every column). Similar to a retail website some people may want to filter on lots of options (size - 32, colour - blue,red,green, brand - polo,topman, fit - regular, length - short) others may want a very basic filter (Sale - yes). Any help would be greatly appreciated.

Thank you.

SouliereS · Answer

Thanks for the information, I will try to figure it out for more. Keep sharing such informative post keep suggesting such post.

Chipotle Feedback Survey

BrianR · Answer

Hi @Henry_Ricketts - take a look at the attached. This should allow multiple selections. The primary change is in the filter...changing it from an "equals" to a "in" allows multiple entities to be filtered...then with that in mind, the Action tool can be modified to build a string for the filter that accounts for this change...such as a custom list of values separated by commas. This then gets inserted into the filter tools.

Alteryx Analytics App - Multi Filter Issue - Multiple Selections.yxwz

Henry_Ricketts · Answer

Hi @DataNath - thanks very much for those useful links - I've managed to set up a work flow which i'm mostly happy with but struggling with a formula. unfortunately I can't share the workflow but have set up an example. The attached works if the user selects 1 box for each filter, however, I need them to be able to select as many as they'd like (i assume i need a formula for this). Any help would be much appreciated.

thanks,

Henry

Alteryx Analytics App - Multi Filter Issue.yxwz