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

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).
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:

---

Legacy KB System (APS) Data: RESL212162 V1.0, Originally authored by EdFa on 07/25/2013, Last Edited by EdFa on 07/25/2013
Related ranges: ION Enterprise V6.0, ION Enterprise V5.6