0 Replies Latest reply on Sep 11, 2019 4:21 AM by Choi Lai Man

    How to 1) normalize data in daily basis, 2) display data for specific date?

    Choi Lai Man

      Hi,

       

      I have two questions.

      (1)

      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. (

      (2)

      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.

       

      Many thanks!