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?
Bob Jeffcott Author on
I tried using the aggregation calculation to reduce the number of rows by selecting the Zip Code dimension, but it still gives me the > 10k error, even though there are far less than 10,000 unique zip codes.
I have tried a variety of combinations of fields in the aggregation combination, but the final result still shows the same number of records above 10k.