Perhaps I am using the term normalize wrong, but the following is essentially the gist of what I'm trying to do:
I've got wireless bandwidth usage data calculated for each building on campus, and I've created my own .kmz/.kml file with these building's boundaries defined. I've managed to plot the data to this map, so that alone I've got fully functioning. Now, I want to setup a 5 Point shading scale, where in the middle is good (green), and either end could be cause for concern (perhaps blue on the left side, red on the right). Is it possible to weigh each run's data against historical data, such as from the same day/time in the previous week(s), and for each building determine whether it is above the average or below the average before finally plotting this to my map?
Thanks for any insight in advance!
... View more