For example, query whole year's data, but just for day time (8:00 - 18:00). Thanks.
Datalink --> Compressed Data
Start Time : *-1y
End Time = *
Filter Expression : hour(*)>=8 and hour(*)<=18
This filter expression needs a slight tweak to work. In order to get the Hour expression to work you need to put single quotes around the variables inside the function, the result should lookas follows:
Filer Expression: hour('*')>=8 AND hour('*')<=18
Retrieving data ...