Thanks for your suggestions, this looks great, but when I use the following query in sqlserver:
select * from dbo.tbRPT_CountsByGenderRace
where Category = 'Accepted Applicants'
and Year = '1990'
and Race_ISBE = 'Asian'
it outputs two rows of data spreadsheet attached
Category Year Gender Race_ISBE Total Accepted Applicants 1990 Male Asian 41 Accepted Applicants 1990 Female Asian 29
How can I show the count in this graph ? The tool tips shows the category, Gender, Asian, but Number of Records is 1.
1 of 1 people found this helpful
The graph above works exactly correct with Number of Records. If you need to use the 'Total' column, drag that metric out to replace Number of records.