Unable to open your packaged workbook. Can you please update a new one.
I didn't quite get there, but had some comments.
I think there is an issue with having different lat longs with each [County Sub]
making it harder to aggregate the county to one dot. So I made a maxLat and maxLong
I also added a "Show History" on the pages.
Unfortunately, not yet able to get all the running totals to show for all the counties.
Not sure, maybe because some counties don't have data for the last day?Will keep looking at it. Maybe a particular Table Calc will do it.
Please see workbook v10.5 attached in the Forum Thread:
289112aggmap_v10.5.twbx 335.2 KB
Thank you for answer.
About the map: Each 'Caunty Sub' have a unique latitude and longitude. Why do you think that is something wrong with that?
I don't want to aggregate the county, I want to aggregate the timeline map by County Sub.
About the date: I notice that you join de dates from September and October, the aggregation should be sequentially. First should be September then October day by day.
Date | Number Population = Aggregation
Sep 1 | 1 = 1
Sep 2 | 4 = 5
Sep 3 | 6 = 10
Sep 4 | 3 = 13
Sep 5 | 2 = 15
Do you follow?
About the population: I have population for every single day, starting Sep first until Oct 31.
I attached the document again. Let me know if you have problems. But other person access and download document.
My apologies, I misunderstood.
Please see if the attached v18.1 is closer to the goal.
Basically, I used a calculated field instead of the quick calculation.
I think that way allowed for restarting every [County Sub].
I think it will be difficult to get all the labels to show.
289112aggmap2_v18.1.twbx 300.6 KB
This is exactly what I'm looking for thank you. Now I'm going yo duplicate it to practice.....