Alteryx Gallery - Large Data Source to be completely customizable

[Henry_Ricketts]

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.

[DataNath]

Hey @Henry_Ricketts, this is a perfect use for an Analytical App, whereby you can host it on gallery and let users interrogate the data however they like, within the interaction that you allow. They won't need to enter the workflow themselves (and they won't even see it), but can simply use the dropdowns - and any other interface options you include - to return their desired output. There's a load of resources on how to get started with building these:

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Apps-and-Macros/ta-p/35375

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Convert-a-Workflow-into-an-App/ta-p/33274

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Interface-Designer-Part-2-Analtyic-Apps/ta-p/...

https://www.youtube.com/watch?v=2aI3odJeo6c

One tip I'd certainly give is to always build out a working flow yourself (i.e. the filters work as expected and give you the desired output when you start changing things. After that, start adding the app functionality.

[Henry_Ricketts]

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

[BrianR]

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.

[SouliereS]

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