"View for empty selection" does not return correct values in charts

[tcyd]

Hi there,

Data attached.

I was trying to make a simple chart that presents the sum of an attribute when selected (using "by field") (say, total population of an area when user select that area - the t_pop attribute).  I have "view for empty selection" enabled in my data layer.  Theoretically, when nothing is selected on the map, the chart should show the total population of all the records (in my case; about 7M).  Yet, upon testing, when nothing is selected, the chart only shows 4M of population.

Such error does not happen in my other previous dashboards.  Not sure what went wrong.  Your help is appreciated!

[tcyd · Accepted solution]

Found the issue.  Page size has to be set for data with >100 records (otherwise, the statistics will be for the first 100 records only - tested and verified).