hello guys,
I have a big question, is it possible to put 2 fields that have some values that are the same, into 1 field where you appears unique values AND if you use the new field for a filter for example then it is connected with the other 2 fields? So i can create a filter will all values available in those 2 fields in order to make it easier for the user? Or make a new dimension but with this new field with all unique values inside?
for example:
seller_kam , buyer_kame
john,mike
elizabeth,sam
michel,igor
New field:
john
mike
elizabeth
sam
michel
igor
what you guys think?
