Multiple filter options in App where user may use one or many to narrow down their data

Question

Use case is to replace Tableau w/ apps.

Looking to create an app where the user can select/utilize one or more filters to narrow down the data set. Currently there are multiple apps in use that satisfy this based on the paired options available to filter. However, we are looking to consolidate this to one APP. We've scoured the community and found only solutions that danced around this in many ways, but nothing that addressed this question fully.

PROBLEM: There is a dataset that requires updating by the end users. They always select the first field to filter, "Vehicle Type". Sometimes they only need "Vehicle Type" to make the necessary updates to the dataset and return to the dataset. Other times, they need to narrow down the selection further by selecting by [Brand] or [Brand] & [Color] or [Brand] & [Color] & [Year] or [Color] & [Year] etc...How can the workflow & APP be configured to allow for the options of a single filter and multiple filters and still pass along all the data from the dataset to be uploaded after the end user updates their filtered set.

The dataset in question is stored in a .yxdb file is 6m rows w/ 50 columns of data.

Thoughts are welcome!

No-Sass · Answer

@Qiu wrote:@No-Sass 
It seems that only Chained Apps can solve this kind of issue, refer similar question below.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multiple-levels-of-filters-first-select-columns-to-filter-then/td-p/835500

And there is also an Idea has been raised for improvement, Kindly vote here.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/multiple-filter-dropdowns/idi-p/638475

We'll take a look at both of these. Thank you!

No-Sass · Answer

@apathetichell wrote:Check out the Tree Tool. this would allow a user to drill down levels (ie apply multiple filters).

your next question -> if you would like to see an example post some data - not a screengrab. - and alteryx isn't designed for 50 column filters. you can try transposing this but you'll loose some othe inner record linkage.

Exactly. It's finding that limit of use and answering the question of "Can AYX substitute for Tableau when its used as a filter tool to use/view data from a dataset?" The transposing idea we played with but were concerned with the pivot and the significant amount of data it would produce to slow down the process. Still tinkering with that one.

We'll look at the tree tool, thank you

Gaurav_Dhama_ · Answer

You can try updating the xml of the summarize tool. This is best approach when you want to dynamically change the summarization levels and type.