Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this to show only sales data
if(Wildmatch(Category,'Sales*'),Category) as field
Hi Maciej,
you can add a new field (in Script) like below:
If(Wildmatch(Category),'*Sales*',Category,'Others') as AnotherCategory
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.?
May be this to show only sales data
if(Wildmatch(Category,'Sales*'),Category) as field
You're right Anil, thanks. 🙂
Hi,
maybe one solution could be:
hope this helps
regards
Marco
I've checked it and it also works fine and it's very nice. Thank you Marco :-).