How to Filter Vista Query to Return Daily Data Instead of Interval

Issue
In some cases it is only required to present daily (or hourly) data instead of every 15 minutes; in other words, the query should return one record per day instead of 96 records (24 x 4 records/hr).

Product Line
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment
Vista

Cause
The Data Log Viewer Query Wizard shows the query that the Data Log Viewer runs against the SQL database to create the table that is seen in Vista. This query can be configured to put further specifications on what data is shown.

Resolution
Please note that the following procedure will provide the interval data at the specified time (not the aggregated value on that period)

The following filter can be implemented in Vista > Data Log Viewer to only poll data on a daily basis at 2:00 AM:


The result is:


Similarly, for 2:00 PM, the following query can be used:


And the result:


The following illustrates a filter for hourly data at the top of the hour:


And the result: