How can I use Set Analysis AGGR function to discount duplicate vendor names (highlighted in yellow) based on Document Upload Date or Invited Status?

[#1]

Dear Community Users,

I have tried using this Set Analysis AGGR function in the Expression tab of a chart object but it only displays the minimum DocUploadDate to display the unique vendor count (InviteesStatName). How do I go about displaying the vendors with a blank DocUploadDate as well? Or how do I go about displaying the vendors with Invitees_Status as "invited". For your information, ALL vendors with a blank DocUploadDate is EQUAL to Invitees_Status="Invited". So either component will do.

There are thousands of other vendors (not shown here because I only singled out the duplicates) that have no DocUploadDate and/or Invitees_Status="Invited". They have no other statuses. Duplicate vendors are defined as a vendor having more than one status such as "Invited", "Approved", "Draft", "Purged" and so on.

Your prompt assistance would be greatly appreciated.

Count(AGGR(min([DocUploadDate]), InviteesStatName, [Invitees_Status]))

[Gysbert_Wassenaar]

Count({<[Invitees_Status]={'Invited'}>}InviteesStatName)