
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Creating filter
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!
- Tags:
- chart
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe like this you can create a new column in load script
pick(wildmatch(Type,'*policy*','*discount*'),'Policy','Discount') as New_Type


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe like this you can create a new column in load script
pick(wildmatch(Type,'*policy*','*discount*'),'Policy','Discount') as New_Type

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I created a dimension using this logic and it worked. Thanks a lot!
