This content has been marked as final.
Show 3 replies
-
1. Re: How to plot this data to give a column graph
Tom WMay 18, 2016 6:05 PM (in response to Chitrarekha Saha)
-
2. Re: How to plot this data to give a column graph
Chitrarekha Saha May 19, 2016 9:59 AM (in response to Tom W)Hi Tom,
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.
-
3. Re: How to plot this data to give a column graph
Tom WMay 19, 2016 10:28 AM (in response to Chitrarekha Saha)
1 of 1 people found this helpfulThe 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.