I'm trying to add a filter for 

Entity.type != 'Employee'

, but it seems to ignore my filter. When I put Entity.type as a column, it returns "Employee", but when I apply the LOWER function to Entity.type, it returns "relationship field". This makes me think that when I try to do my filter

Entity.type != 'Employee'

, it's not working because

Entity.type

is actually returning "Relationship Field". How can I filter using

Entity.type

properly?

SuiteQL can get finicky around select/relationship fields, especially when they're multi-select fields. In this case, I don't think type is or should be multi-select, but apparently at least the person responsible for documenting the Analytics browser thinks it is... Anyway, if you can't find a mapping table or a table that contains the values for the type column (I looked and can't), you can always try something like

SELECT
  COUNT(id)
FROM entity
WHERE REGEXP_INSTR(LOWER(BUILTIN.DF(type)), 'employee') = 0

or

SELECT
  COUNT(id)
FROM entity
WHERE id NOT IN (
  SELECT id
  FROM employee
)

Wow so weird. That second one works like a charm. I didn't bother to try the first one because the second one makes the most sense to me.

Great, glad it works!

Thank you for your help!

This works for me

SELECT BUILTIN.DF(entity.type),
FROM message
JOIN entity ON message.author = entity.id
WHERE BUILTIN.DF(entity.type) != 'Employee'

What does BUILTIN.DF do?

It's the equivalent of Result.getText on saved search, basically a helper function to join to the entity type table and get the textual value