Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to create a calculated dimension to show only few values in straight table.
In the Name field, I want to filter any value starting with *classic. Eg- *Classic Edu, *Classic Tours, *Classic Agen etc..
But the below expression is still showing them. It filters out the above values only when i put full name like *Classic Edu. But i want to filter out all when Name start with *Classic in my straight table.
Below is the calculated dimension i am using-
=if(Name<>'*Classic*',Name)
if(wildmatch(Name, '*classic*'), null(), Name)
if(wildmatch(Name, '*classic*'), null(), Name)
Use if(not WildMatch( Name,'*Classic*'),Name) and check "Suppress When Value Is Null"
You can try with
if(wildmatch(Name, '*classic*'), 0, Name)
Or
if(wildmatch(Name, '*classic*'), null(), Name)
And Check the "Suppress when value is null" option in the chart
Hi Suraj,
Try this:
I'm taking example of year, suppose you want to display only 10,11 and 12 than use this
=if(match(Year,'2010','2011','2012' ),Year)
Thanks,
AS
Thanks everyone !!