5 Replies Latest reply on Mar 4, 2014 6:18 AM by m.mcdonell

    counting each unique value in field


      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