Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
If(is null(Special campaign ID), 'not special campaign', 'special campian')
If(is null(Special campaign ID), 'not special campaign', 'special campian')
This worked - thank you!