I have a situation where we have values in our database that are not clean. I.e.
and instead of having a filter that shows all three values, I’d like to just give the dimension a “suggestion” of “Red”.
Then, when the user selected “Red”, I just want to modify my filter, so instead of filtering on just “Red”, I want to filter on something like “IN (‘RED’, ‘Red’, ‘red’)”.
This seems like it should be so easy, but I can’t wrap my head around how to get this working.
Any suggestions would be greatly appreciated.