Set Analysis Logic

[niharika1234]

Hello,

I am trying to pull Incident( [MOR_IncidentId])that are open more than 21 days  and where MOR_CATEGORY_Final ( Category )is not Populated or null. In my cases all category is declared as '-'. My syntax is :

[21day_Flag] = declared in script . 

count({< MOR_CATEGORY_Final = {"*-*"}, [21day_Flag] = {1}>} DISTINCT [MOR_IncidentId]). Here is what I got.

I am getting some value in  MOR_category_Final where I should be not be. it should all show '-'.If I am removing * from logic I am not getting any value.Please suggest.

Niha 

[sunny_talwar · Accepted solution]

May be try this

Count({<MOR_CATEGORY_Final = {"=Len(Trim(MOR_CATEGORY_Final)) = 1"}, [21day_Flag] = {1}>} DISTINCT [MOR_IncidentId])

[niharika1234 · Accepted solution]

You are awesome ! It worked.