Total count of specific value in a field

Follow

Jeremiah Cather

October 09, 2020 17:22

Hello,

 

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.

0

• 

  Ido Darnell October 11, 2020 13:44

  Hi Jeremiah Cather

  For this you can use either a widget filter, which will filter out the entire widget, and all calculations/formulas in it, or use a measured value which basically enables one to apply a filter on an independent formula.

  LMK if that answers your question,

  Feel free to reach out,

  Ido

  ido.darnell@qbeeq.pl

  0

  Comment actions Permalink

Please sign in to leave a comment.