{}

Impact-Company-Logo-English Black-01-177x54
Share Price 
Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric corporate Website

Search FAQs

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:
Query Wizard

The result is:
Result 1

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

And the result:
Result 2

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

And the result:
Result 3

Schneider Electric Global

Explore more
Range:
Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: