Selected Filter pane is showing if conditions

[Anonymous]

Hi all

i written calculated dimension based on my requirement

i have 10 types of modes(types) in database

my require is to show only 3 types in filter for that i wrote

if(Mode= 'Misc', 'All Other',

if(Mode= 'Parcel', 'All Other',

if(Mode= 'ProMexdome', 'All Other',

if(Mode= 'Waretest3', 'All Other',

if(Mode= 'Airtest', Mode,

if(Mode= 'Intmodalte', Mode,

if(Mode= 'Truckload', Mode,

) ))))))

result is

Airtest

Intmodalte

Truckload

All Other

Issue is

how to rectify this one i am expecting to see mode only as text

[#2]

Hi,

Try this way,

If (Mode = value1 or Mode = Value2 or Mode = Value3, 'All Other', Mode) as Newfield

[Anonymous]

i tried its shows error in expression

i think as not a suitable keyword

suggest any another

[rupamjyotidas]

Go to Filter pane properties --> Dimension ->Enter the Title

Also, You can change the Filter pane Title by going to General -->Show Titles : ON -->Enter the Title

[ift_isabelle]

Have you tried making it a master dimension?

You can give it an different name.

Or do the recode in the script and give your variable a normal name.

[simongoodman]

Hi try this variation in the script, to create a new dimension. I have assumed no null or empty fields with Mode.

if(Mode= 'Misc', 'All Other',

if(Mode= 'Parcel', 'All Other',

if(Mode= 'ProMexdome', 'All Other',

if(Mode= 'Waretest3', 'All Other', Mode)))) as Newfield