m.mcdonell

counting each unique value in field

Discussion created by m.mcdonell on Jan 28, 2014
Latest reply on Mar 4, 2014 by m.mcdonell

I use an activity field in my database (service table) to move the progress of a service report from pending, scheduled, receiving and billing. How can I show a count of each of these on my dashboard (dashboard table which is a matching layout)?

Any help will be great.

Example:

 

10 invoices > activity ID is as such

3 records blank

2 records are pending

2 records are scheduled

1 record is receiving

2 record is billing

 

Displayed as:

 

Pending ( 2 )

Scheduled ( 2 )

Receiving ( 1 )

Billing ( 2 )

 

Thank you

Michael

Outcomes