3 Replies Latest reply on Mar 5, 2014 11:49 AM by philmodjunk

    Basic Graphing Help - Count Unique Values

    jkostenbader

      Title

      Basic Graphing Help - Count Unique Values

      Post

           This can't be very hard but its actually not working as I expect:

           I have a "projects" table and in each record there is a "responsible" person for that project. I'd like to create a graph that counts the number of Projects that Project Manager has....simple right?

           I have configured the X axis to look at the field "responsible" and the y axis to Count(projects;;Responsible). If I have four records as follows:

           John
           John
           Frank
           Beth

           What actually appears is four vertical bars instead of one for Beth, one for Frank and ONE for John with a records count of two. It does not seem to be graphing John as one bar. Any advice would be appreciated

           John