Frequently Asked Questions – Recipe
Go to Configure-Options-System Logging. Enable the Recipe Transaction Log and the details of each recipe execution will be logged within the file.
Set the field names to use your desired aggregate functions. Example: AVG(myField), MIN(myField), MAX(myField), and SUM(myField).
In the Query String property enter the following:
WHERE DateAndTime <= CURRENT_TIMESTAMP AND DateAndTime > DATEADD(hh,-24,CURRENT_TIMESTAMP)