Count when not Primary

[cbaqir]

I need to show a count of DEFECT_ID where a resource is the PRIMARY_ASSIGNEE and then also when they are not the PRIMARY_ASSIGNEE but they are listed as one of the BUILD_RESOURCES_SUB (subfield that contains only user name). How can I calculate the secondary?

Dimension: PRIMARY_ASSIGNEE

Exp Count Primary:  count(DISTINCT DEFECT_ID)

Exp Count Secondary: Count(DISTINCT{$<BUILD_RESOURCES_SUB-={'PRIMARY_ASSIGNEE'}>}DEFECT_ID)

[Anil_Babu_Samineni]

Perhaps this?

Count(DISTINCT{$<BUILD_RESOURCES_SUB={"BUILD_RESOURCES_SUB<>PRIMARY_ASSIGNEE"}>}DEFECT_ID)

Or

Count(If(BUILD_RESOURCES_SUB<>PRIMARY_ASSIGNEE, DEFECT_ID))

[cbaqir]

This still isn't quite right.

A DEFECT_ID can have multiple people listed on BUILD_RESOURCES_SUB. I want to aggregate on the field of PRIMARY_ASSIGNEE field. If jdoe is one of the BUILD_RESOURCES_SUB on 4 tickets that he is NOT the PRIMARY_ASSIGNEE on, it should show as 4. 

It's close but not quite...

I think the issue is that my chart is aggregating on the Primary Assignee dimension but I need to count the tickets where the user is a build resource but NOT the primary assignee.

Is this where I could use total?

[cbaqir]

@Anil_Babu_Samineni Perhaps set analysis with an intersection?