How can I use Set Analysis AGGR function to discount duplicate vendor names (highlighted in yellow) based on Document Upload Date or Invited Status?
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.