Set Analysis not equal to scenario

[jaswanthchitra9]

Hi Everyone,

Below syntax which I'm using in my application.

In this case, I don't want to show up [Assignee Group]-={`Hmt*`}  I want to show only Hmt related assignee group.

But other assignee groups are coming into my result how can I fix this issue?

please help me out on this issue

num(count({<Source={'Incident'},SLAStage={'Completed'},Status={'Closed'},Closed_13Month={1},[Service Target]={'Priority 3 Resolution (Service Management)'},[Assignee Group]={`Hmt*`},[SLA Status]={'0'}>
+<Source={'Incident'},SLAStage={'Completed'},Status={'Closed'},Closed_13Month={1},[Service Target]={'Priority 3 Resolution (Service Management)'},[Assignee Group]-={`Hmt-Apps*`},[SLA Status]={'0'}>}[Ticket Id])

Thanks in Advance!

[Or]

Your bottom set only excludes HMT-Apps* without any other limitations, so it will presumably return all groups except the ones matching that specific string. Perhaps you're looking for something like:

[Assignee Group]={`Hmt*`} - {`Hmt-Apps*`}

[jaswanthchitra9]

I have tried this method too but data not getting.