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.



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