To GoodData homepage

Topics started by Mr Holmes

1 Topic

M
Mr HolmesNew Participant
asked in Metrics and MAQL

How do I create a metric that identifies records that have a NULL value

Hi, I have a similar type question. I have a metric that counts the events whereby a conversation has been labeled with the attribute “NON-MVP” but I need a metric that counts the conversations that have not been labeled with the attribute “NON-MVP”. This is the code that identifies the label being used:select Inbound Handled Conversations where Conversation Label 8 [Conversation Attribute 8] like "%NON-MVP%"I tried using this code to identify conversations that have not been labeled “NON-MVP” which does not work:Select Inbound Handled Conversations where Conversation Label 8 [Conversation Attribute 8] not like "%NON-MVP%"Any help will be greatly appreciated.

3
Joseph Heun
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings