topic Re: Set Analysis Logic in Water Cooler

Set Analysis Logic

niharika1234 — Thu, 27 Dec 2018 16:11:20 GMT

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

Re: Set Analysis Logic

sunny_talwar — Thu, 27 Dec 2018 16:41:39 GMT

May be try this

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

Re: Set Analysis Logic

niharika1234 — Thu, 27 Dec 2018 18:28:39 GMT

You are awesome ! It worked.