Limited filter box values

[Anonymous]

Hi,

I have a column "Category" and there are many values. I would like to have them limited to be viewed in my filter box to those that starts with "Sales". What is the way to get it?

Maciej

[jpenuliar]

Hi Maciej,

you can add a new field (in Script) like below:

If(Wildmatch(Category),'*Sales*',Category,'Others') as AnotherCategory

[Anonymous]

Hi Jonathan,

I apologise for a long time to give you feedback. It works, thanks for your help. I only had to made some impovementst because ther was little mistake in the code. It should look like this:

if(Wildmatch(Category,'Sales*'),Category,'Others') as AnotherCategory.

Can I get on the filter list only those 'Sales*' without Others? The data in my visualization only refers to the Sales and there won't be no others.?

[Anil_Babu_Samineni · Accepted solution]

May be this to show only sales  data

if(Wildmatch(Category,'Sales*'),Category) as  field

[Anonymous]

You're right Anil, thanks. 🙂

[MarcoWedel]

Hi,

maybe one solution could be:

hope this helps

regards

Marco

[Anonymous]

I've checked it and it also works fine and it's very nice. Thank you Marco :-).