Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84649members
353989posts

[Imported] Filtering time with timegaps.

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
sbeadle
Janeway Janeway
Janeway
0 Likes
1
355

[Imported] Filtering time with timegaps.

>>Message imported from previous forum - Category:Scripts and Tips<<
User: ROVSCADAENGINEER, originally posted: 2019-02-01 01:06:10 Id:358
Is there a way on clear SCADA to set the filter to display only a set amount of readings within an hour from a series of recorded data over the last year. I am extracting all the current readings on a pump for the last year and am wanting to extract the data however there are over half a million rows. I cannot seem to find a way to grab just hourly readings as the timestamps are never exactly on the hour. this would save so much processing time if i could apply some filter to reduce the amount of readings called back into the historic list.


Accepted Solutions
sbeadle
Janeway Janeway
Janeway
0 Likes
0
354

Re: [Imported] Filtering time with timegaps.

>>Responses imported from previous forum


Reply From User: ROVSCADAENGINEER, posted: 2019-02-01 02:17:38
I am also looking into SQL techniques of editing the SQL directly. Basically i want to apply a filter that takes readings and selects minutes in an hour based on a ffrequency of every 2nd minute with 1 minute timesteps.


Reply From User: adamwoodland, posted: 2019-02-01 04:05:51
Have you looked into historic views? You can set how you want those hourly values to appear (average of all values in the hour, interpolated, max, min, etc) and access them via SQL


Reply From User: ROVSCADAENGINEER, posted: 2019-02-03 21:17:34
I will try and do that using that method Adam, Good suggestion!

See Answer In Context

1 Reply 1
sbeadle
Janeway Janeway
Janeway
0 Likes
0
355

Re: [Imported] Filtering time with timegaps.

>>Responses imported from previous forum


Reply From User: ROVSCADAENGINEER, posted: 2019-02-01 02:17:38
I am also looking into SQL techniques of editing the SQL directly. Basically i want to apply a filter that takes readings and selects minutes in an hour based on a ffrequency of every 2nd minute with 1 minute timesteps.


Reply From User: adamwoodland, posted: 2019-02-01 04:05:51
Have you looked into historic views? You can set how you want those hourly values to appear (average of all values in the hour, interpolated, max, min, etc) and access them via SQL


Reply From User: ROVSCADAENGINEER, posted: 2019-02-03 21:17:34
I will try and do that using that method Adam, Good suggestion!