Double Set Analysis

[Anonymous]

Hi All

Trying to do the following but cannot get to work.....Please help!

=count(DISTINCT{$<Assignee = {'Adil Hussain'}>}IssueID) and count(DISTINCT{<%StatusID = ('10116,10117,10118')

Thanks Alot

[sunny_talwar · Accepted solution]

Try this may be:

For meeting both the conditions

=Count(DISTINCT{$<Assignee = {'Adil Hussain'}, %StatusID = {'10116', '10117', '10118'}>} IssueID)

For meeting one of the condition (either or), try this:

=Count(DISTINCT{$<Assignee = {'Adil Hussain'}>+<%StatusID = {'10116', '10117', '10118'}>} IssueID)

UPDATE: Keep an eye for the red things in the expression

[Anonymous]

You;re on a role Sunny!!!

thanks again

Correct 2 out of 2

Thanks for Advice as well, always appreciated

[sunny_talwar]

Not a problem. I am glad I am able to help