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.
Best answer by Joseph Heun
View original