I'm looking at analysing numbers of gas service pipe failures to find emerging hotspots. Because there could be different numbers of properties with gas meters in whichever polygon aggregation I use (postcodes, hexagons etc.) I think that ideally the data should be normalised, i.e. failure rate = number of failures / number of gas meters.
Is there a way to create a space time cube that will calculate this failure rate rather than just use the non-normalised count of failures? Or is there some workaround to get the same result to use with the emerging hot spot analysis tool?