We are attempting to create a Dashboard that will be using demographic information including Zip Code, Sex, Race, etc.
The idea is to group by one primary category (Zip Code) in a pie chart, then show related charts for the other demographic information. So I can click on one Zip Code in the Pie Chart, then the other charts would show associated demographic information for that Zip Code.
It seems though, that since there are more than 10,000 records the data feed will not read all of them.
We could put it into a SQL database and access it that way, if there is a reasonable SQL call that we can use.
Ideas?