Data aggregation and propagation across multi-level system device hierarchy

Thanks Dylan for your quick reply.
We thought about Experience Groups, but there is a limitation about the number of child groups that a given parent group can have. For instance. in the example above if the number of cities down State 1 is greater than 100 and I try to get all the aggregated data for State 1 using either the Gauge Query or the Time Series nodes, this error occurs:

That’s why we were looking to use System Devices, which we think there is no limitation about the number of nodes within the tree structure.