The data I have is on hourly basis but I would like to (a) average the data in a daily basis, (b) and normalize the daily-averaged data so that when the data is shown by months, it is ranged from 0 - 1. (
Whenever I have a data > 10 at any time in a day, how can it be displayed that particular date of data? In other words, I would like to filter the dates (24hours) having data greater than 10 (even though it only occurs in one hour). Right now I use 'Exclude' function but it is not efficient especially when the amount of data is getting large.