Frequently Asked Questions by customers, end-users, and integrators. Let us know if you have an unanswered question.
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)