To GoodData homepage

Replies posted by Mr Holmes

2 Replies

M
Mr HolmesNew Participant
asked in Metrics and MAQL

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

Hi Iva, thanks for responding. So when i use the 2 metrics as quoted above, the results are as shown in the below 3 points:Inbound Handled Conversations = 500Inbound Handled Conversations that have only been labelled as Non MVP = 175Inbound Handled Conversations that not been labelled as Non MVP = 500I would want the result of point 3 to be 325 (point 1 minus point 2) so clearly the Metric i quoted above to identify conversations that have not been labelled as Non MVP is not working. I am aware of the case sensitive requirement and therefore this is not the cause. Any suggestions?

3
Joseph Heun
GoodData Employee
1 year ago
D
dudoffNew Participant
asked in Metrics and MAQL

How do I create a metric with I am trying to count 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.

2
M
1 year ago
Welcome to the GoodData Community!Cookie settings