Creating filter

[sanp96]

Hello all,

I have a question with respect to creating filters for a table chart. I had asked a question for the same table chart visualization previously. I am attaching the chart again. It has many other columns along with this one.

Type
dhdg discount
arf policy
abc discount
xyz policy
pqr discount
xyz policy
efg policy

Is it possible to create a filter that will have only 2 values as 'Policy' and 'Discount' based on the 'Type' column, but it should display all the rows containing the respective text?

To elaborate, say the filter is set to 'Policy', then I want the result to be like:

Type
arf policy
xyz policy
xyz policy
efg policy

Any help with this is highly appreciated.

Thanks!

[arulsettu · Accepted solution]

Maybe like this you can create a new column in load script

pick(wildmatch(Type,'*policy*','*discount*'),'Policy','Discount') as New_Type

[sanp96]

I created a dimension using this logic and it worked. Thanks a lot!