Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

To use the TOLTALISE Function 

TOTALISE(Tag,Window_Size,TimeStamp,Rate_Unit)

Adds up the data over a specific time window, resets at end of time window

Adds up the data starting at 00:00 GMT for 24h ending at 00:00 GMT

Window size  = size of the time window eg 1d, 365d, 30m

Timestamp = Can either pick a date you want to start it from or a time (remember to take into account your timezone and your GMT offset)

Rate of Unit =   data per/ 1h, 20m, 1d

EG

TOTALISE(Tag,Window_size,Offset,Rate_Unit) -  TOTALISE(Tag,1d,0,1h)  

TOTALISE(Tag, Window_size, Start_Date, Rate_Unit) e.g. TOTALISE(Tag,365d,2016-01-01,1d)


TOTALISE(Demo-influxdb/DEMO_01TI031.PV,Demo-influxdb/DEMO_01TI032.PV,Demo-influxdb/DEMO_01TI021.PV)



  • No labels