2 Replies Latest reply on Oct 30, 2018 12:57 PM by Dian Jiao

    How to plot attribute value change by time based on the hour

    Dian Jiao

      I have a set of data which records a count "Ctrlr_Cycle_Cnt" every 10-20 minutes. The count is always incremental. I want to get the average change rate [(cnt2-cnt1) / (timestamp2 - timestamp1)] on the hour. Essentially x-axis will be hours of a day (1-24, 24 bins) and y-axis is the average change rate for every hour. Assuming I take all data into account.

       

      Attached is the workbook