HI All,
I have the following rows of data in viz "A":
AAA;BBB;CCC
AAA;AAA
DDD:AAA;AAA
FFF;
Viz "B" has the distinct sub-set of data from viz "A" :
AAA
BBB
CCC
DDD
FFF
I'm wanting to do a LIKE type filter from "B" to "A" so that selecting AAA would return the following rows in viz "A":
AAA;BBB;CCC
AAA;AAA
DDD:AAA;AAA
Likewise, selecting BBB would return:
AAA;BBB;CCC
Does anyone know of an approach that will accomplish this? Using a Parameter is out as this is live data subject to changing from day to day.
Thanks
Chad,
This link looks like it might be similar,
but it involves a self-join, which may not be feasible for your setup:
Become a Viz Whiz on the Forums! Support the Community and master Tableau.