I am currently running into an issue with our data where some of our events don’t have a certain field (called errorCode). My problem is when I am trying to calculate a success rate, I can’t ignore failures from an event that don’t have an errorCode.
I know that if I do something like:
SELECT count(*) FROM login_errors FACET errorCode
Then the events with no error code will be removed. However, how can I do that when I can’t use a FACET on errorCode because I am calculating a different value that I don’t want to break up by errorCode?
I thought I could do something like
SELECT count(*) from login_errors WHERE errorCode!=’’ OR errorCode!=NULL
but neither of those options works. Any help?