Help Filtering: Select Text Values in a Column => One Selection in Filter
I would like to combine text values so that they appear under one filter selection. I guess it would be like grouping filters.
Referencing the example below, I would like the option to combine Nordstrom and Nordstrom Rack. At default, I would still like them to be separate.
Note: This is an example, My real issue unfortunately can't be solved by adding a column titled, parent company
Has anyone else tried to do this?
Please and Thank you
Hi Katrina Miyamoto I agree with you that we need to make it easier to choose "similar" values like this. In our planned enhancements to filtering we will likely give you a way to select all items that "startwith" Nordstrom. I can't yet give you a timeframe but it is on the roadmap, along with a number of other improvements to filtering. Thanks for reaching out!
You can add a formula to your answer that is like: if( contains(Department Store,'nordstrom') ) then 'Nordstrom' else if (contains (Department Store, 'macy') )then 'Macy' else Department Store. Then your chart will group by this new dimension that you added. Otherwise for filtering, you can use Department Store contains 'nordstrom' in your search bar.
Hope this is helpful.