Analytics: raw_geo.q doesn't handle null/empty fields correctly.

18154
Reporter: mblissett
Assignee: fmendez
Type: Bug
Summary: Analytics: raw_geo.q doesn't handle null/empty fields correctly.
Priority: Major
Status: Open
Created: 2016-01-14 14:05:24.685
Updated: 2016-01-14 14:05:24.685
        
Description: {{COALESCE(v_decimallatitude,v_verbatimlatitude,")}} would work if v_decimallatitude were NULL, but it isn't, it's just empty.

I'm using {{IF(v_decimallatitude = '', v_verbatimlatitude, v_decimallatitude) AS v_latitude}} instead.]]>