-
1. Re: How to plot this data to give a column graph
Tom W
May 18, 2016 6:05 PM
Like this?
If so, you just need to drag 'Category' from the list of Dimensions on the left onto the rows shelf and remove the filter you have on Category.
-
2. Re: How to plot this data to give a column graph
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 W
May 19, 2016 10:28 AM
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.
