Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this way,
If (Mode = value1 or Mode = Value2 or Mode = Value3, 'All Other', Mode) as Newfield
i tried its shows error in expression
i think as not a suitable keyword
suggest any another
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
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.
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