I have a field in a table from our ticketing system that has a status for all our tickets. The field is called "Status" and I want to create an indicator widget that can count all the "Closed" statuses, or "Open" or "Pending" etc.
I tried using DUPCOUNT, but that just counts all the statuses no matter what they are while a regular count will only return a unique count of the statuses. Is there a way to do like a DUPCOUNT on only "Open" statuses.
Please sign in to leave a comment.