Find the time that corresponds with the highest or lowest value found in the specified period. Be sure to set the Retrieval Mode to be equal to or greater than the timestep that you are working in or displaying.
Defines the time series data fed into the function. This can be a sensor ID or another function.
Number of data intervals considered in the function. For example, if using hourly data, then applying 24 will search the previous 24 hours.
Specifies the time interval to be selected.
Available choices are:
Year ('Y'), Month ('M'), Day ('D'), Day of Week ('d'), Hour ('H'), or Minute ('m')
*Input data is optional in most cases. If Info360 detects that the first input is time series data, it will be applied to the function. Otherwise, the current active sensor's data will be used, which is often the case in Reference Charts.
Example Usage as an Expression:
HighestTime(24,'H') - On hourly data this will output the highest Close() from the previous 24 hours. On 15 minute data this would output the hour that contains the highest point in the previous 6 hours (24 15 minute periods).
HighestTime(High(),24,'H') - Outputs the highest High() sampled value from the previous 24 periods.
HighestTime(High(),30,'H')+HighestTime(High(),30,'D')*24 - LowestTime(Low(),30,'H')-LowestTime(Low(),30,'D')*24 - This will calculate the total hours that it takes to fill or drain the tank, assuming we're using Hourly data and it doesn't take more than 30 hours. Positive peaks are the time to fill and negative peaks are the time to drain.
Example Reference Chart:
The following simple example shows daily reservoir levels with the highest value from the previous 30 days as well as the day of the month on which the high occurred.
The following example shows a long expression being used to calculate the total hours between tank filling and draining. The orange line shows the number hours to fill the reservoir, while the green line shows the number of hours that the reservoir drains for.
Here we used HighestTime(24,'H')+HighestTime(24,'D')*24 so that the hour total doesn't reset every midnight.
For information on setting up custom equations and syntax, please refer to Analytical Functions.