Time-enabled Aggregation for Overlapping Time Periods

Question

Hi GIS Community,

I'm working with a time-enabled layer in Experience Builder that displays data using the "Counts and Amounts" visualization (proportional symbols/bubbles). My dataset contains data collected every 2 weeks across multiple rounds.

I've encountered an issue where setting the time slider period to anything longer than 2 weeks causes overlapping bubbles to appear on the map, as it simultaneously displays data points from multiple rounds (please see screenshot). For example, if the time slider spans 1 month, I'll see overlapping bubbles for the same location from both rounds within that month.

Is there a way to aggregate the data points within the selected time period? Ideally, I'd like to show a single bubble for each location that represents the sum of all rounds captured within the time slider's current range rather than multiple overlapping bubbles.

Has anyone solved this kind of temporal aggregation challenge before? I would greatly appreciate any suggestions for configuration settings or alternative approaches.

Thanks in advance for your help!

Roman

experience builder.png

wizzgis2 · Answer

Hi! I'm sorry for the late reaction; I missed the notification about your answer. Thanks a lot for your answer. It seems binning can be a temporary solution, and I'm looking forward to the summary statistic field for cluster visualisation.

russell_roberts · Answer

You could use binning in this case because we have support for styling your bins (clusters on the roadmap) So I would create the summary statistic field for sum on the number of ppl and then use that new field under the Bin styling where it can use the counts and amounts size. You can control the size of the bins, set a scale threshold to turn off the bins when zoomed past a certain level if you wanted to.

wizzgis2 · Answer

Hi! Thank you for your answer. I tried clustering, but I could not get what I wanted. The problem is that cluster size is based on the number of features. What I need is the bubble's size to depend on the sum of one of the fields (number of people). I can create a label based on field statistics, but bubble size still depends on the count of points. Maybe I missed something, and it is possible?