Join Slack
Powered by
I’m always getting ‘Unknown’ even when there is a ...
# suiteanalytics
j
jen
12/04/2018, 5:54 PM
I’m always getting ‘Unknown’ even when there is a first name
g
Gregory Jones
12/04/2018, 6:04 PM
Try CASE WHEN {firstname} ='' THEN 'Unknown' ELSE {firstname} END
j
jen
12/04/2018, 6:06 PM
apparently I need to compare vs NULL rather than ‘’
jen
12/04/2018, 6:06 PM
working now
👍 1
3
Views
Open in Slack
Previous
Next