This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Convert a null value into a Text String using Custom Dimension

Posted on 11-23-2023 11:06 AM
toddmh
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

How can I create a custom dimension that will convert a dimension that is null into a specific text string? For example, if a dimension named "Location" is displaying a null value, I want to replace it with a text String named "Home".

0 1 239
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
Shru
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Check the 'If' condition option in your custom dimension.

It requires these parameters > if(yesno_expression, value_if_yes, value_if_no)

sample > if(${Location} = null, "Home", "Another value")

 

0 Likes
Top Labels in this Space