EcoStruxure Geo SCADA Expert Forum
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-01-21 10:28 AM
We are attempting to get per minute historic results using a SQL query. The queried point uses historic compression during storage. Since compression is abled for "significant change", there are minutes that do not have a value in the result set. How do we get a result set with a value per minute, regardless of whether the there is a stored historic value (i.e. data changed significantly or not)?
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-01-23 01:37 AM
You may find it convenient to configure a Historic View - a new virtual SQL table. This can be set to a 1 minute interval, and you can pick the type of summarisation, e.g. End Last. The View will give you a column with a quality number, telling you if that 1 minute sample was derived from adjacent values or one/more vales in each 1 minute window. Search for 'Create a Historic View' in F1 help.
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-01-22 01:32 AM
Which algorithm are you using to process the historic data?
An interpolated algorithm will give you values for periods where there is no data.
For example: Average Interpolated
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-01-23 01:37 AM
You may find it convenient to configure a Historic View - a new virtual SQL table. This can be set to a 1 minute interval, and you can pick the type of summarisation, e.g. End Last. The View will give you a column with a quality number, telling you if that 1 minute sample was derived from adjacent values or one/more vales in each 1 minute window. Search for 'Create a Historic View' in F1 help.
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.
With achievable small steps, users progress and continually feel satisfaction in task accomplishment.
Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.
of