Filtering out Watch List Names

[ianG77]

Need some help.
I am using Platform Analytics.

I have a dashboard, and have added a score visual to show the number of Incidents which meet the following criteria:

• Active = true
• Tags: excluding 'Dev Escalations'
• Escalation Priority: is one of Low, Medium, High, Critical
• Watch List: does not contain Jan
  • and does not contain Steve
  • and does not contain Mike
  • and does not contain Claire

I know I have incidents which meet this criteria, but they don't add to the Score visual?

What am I doing wrong here?

[Mark Manders]

Tags is always a tricky one, because it's a weird field, relating to the 'label' table. The best way to troubleshoot, is to remove conditions to see where your query is failing. My guess is the 'tags' one. Could you be having more tags with the same name?

[ianG77]

Hi Mark
Thanks for taking the time to offer support.
I have narrowed it down to the Watch List filters.  
If I set Active as True and then the Escalation Priority filter, the record I know should appear is in the results.
As soon as I add a single Watch List person as Does Not Contain, the record does not appear in the results, even though the persons name is not on the records Watch List.

[ianG77]

Thanks for coming back to me on this Mark.
I have narrowed it down to the Watch List filter, by doing the following:

• Active = true
• Escalation Priority: is one of Low, Medium, High, Critical

The record which meets the criteria is returned.

I then add the additional filter:

• Watch List does not Contain Jan

My record is not displayed, even though Jan is not on the records Watch List.

In fact any record with no people on the Watch List, is also not returned now?

[ianG77]

Solution found

i found a solution to this.  In order for it to work you need to:

• Watch List is empty
• or
• Watch list does not contain Jan.

you need to do this for each person you want to exclude from the Watch List.

Then if the Watch List is empty or contains other names, the records display, but records with the ‘does not contain’ name, are not included in the results.