I have a custom object "Case Status History" which is a kind of audit log of the Case Status Change. Whenever a Status of a Case is updated , a record is created in this object. Status Values has picklist values as(CSO Working, DA Working, OF Working, New) . When the status changes then the name of the person working on Case is captured as "Record Owner" in the "Case Status History" record. Now I have to create report and Dashboard to display "Number of Cases being worked by each CSO and DA".
For this I have created a new report type "Cases with Case Status History". Now I want to display "User Name" on the X-axis and "Number of Cases Worked" on Y axis. Usernames should be the ones which had worked as CSO or DA only. So in my report i have put a filter for that.
I am getting the record count of "Case Status History" on Y-axis instead of "Record count of Cases" . How can I change that on Y-axis ?