start with the last week and/or the last month look at averaging over the entire data set. although thingspeak has some limit over how many records can be sent for averaging i think ...