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

    counting each unique value in field

    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