Hello, This might be a simple question but have not been ale to find help anywhere (Being a beginner).
I would like to know how to calculate hourly avg trend of a signal which is one sec interval.
What I am thinking is:
Suppose signal is = $a
a) Create value search for hourly capsules?
b) Taking avg of during those capsules using formula search?
However I would like the time range for this hourly avg to be dependent on time slider. Which means that sliding time should update the trend.
Any help (Formula snippets) would be appreciated.