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?
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.
Hi Bob,
the 10k row limit takes effect not only in the resulting data that a feed produces but already 'inside' the feed. That means it is not allowed to have more that 10k rows anywhere in the feed.
To solve your problem, you could use a SQL call which already delivers filtered results.
So for example you have one feed with all individual ZIP codes (< 10k i guess)
Another feed containing the result from an SQL statement which delivers the results for a particular ZIP code (also <10k)
Kind regards
Jürgen Kirsch
