Basic Graphing Help - Count Unique Values
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:
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