New dimension based on if value is null or not

[jokar]

Hi All,

I am trying to create a new dimension which creates two groups: the first is campaigns that are a special campaign ID associated - it would be called 'Special campaign'; the second would be all campaigns without a special campaign ID associated - it would be called 'Not special campaign'.

This is an example of what the data looks like:

Campaign	Special campaign ID
campaign 1	1234
campaign 2
campaign 3
campaign 4	1233
campaign 5	1111

Can someone help me what the best expression would be to do this?

Thank you in advance!

[anat · Accepted solution]

If(is null(Special campaign ID), 'not special campaign', 'special campian') 

[jokar]

This worked - thank you!