Sign In Help
Schneider Electric
HelpSign In
Schneider Electric Exchange
  • Home
  • Collaborate
  • Develop
  • Shop
Home Collaborate Develop Shop Log in or Register Help

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.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel

Invitation Sent

Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
  • Home
  • Collaborate
  • Exchange Community
  • :
  • SCADA & Telemetry Solutions
  • :
  • Geo SCADA Expert Forum
  • :
  • Historic Aggregate equivalent to 'Start Last'
Community Menu
  • Forums
    • By Topic
        • EcoStruxure IT
          • EcoStruxure IT forum
        • Industrial Automation
          • Industry Automation and Control Forum
          • Alliance System Integrators Forum
          • Machine Solutions in the Digital Transformation
          • EcoStruxure Automation Expert / IEC 61499 Forum
          • Industrial Edge Computing Forum
          • Level and Pressure Instrumentation Forum
          • Modicon User Group
          • PLC Club Indonesia
          • SEE Automation Club Forum
          • Fabrika ve Makina Otomasyonu Çözümleri
          • Форум по промышленной автоматизации СНГ
        • SCADA & Telemetry Solutions
          • Geo SCADA Expert Forum
          • SCADA and Telemetry Devices Forum
        • Power Distribution IEC
          • Power Distribution and Digital
          • Power Standards & Regulations
          • Paneelbouw & Energie Distributie
          • Eldistribution & Fastighetsautomation
        • Power Distribution Softwares
          • EcoStruxure Power Design Forum
          • SEE Electrical Building+ Forum
          • LayoutFAST User Group Forum
        • Wireless Information Network Solutions
          • Instrument Area Network
          • Remote Monitoring
          • Tank Level Monitoring
          • Remote Data Collection
        • Solutions for your Business
          • Solutions for Food & Beverage Forum
          • Solutions for Healthcare Forum
    • By Segment
        • Food & Beverage
          • Solutions for Food & Beverage Forum
        • Healthcare
          • Solutions for Healthcare Forum
      • EcoStruxure IT
        • EcoStruxure IT forum
      • Industrial Automation
        • Industry Automation and Control Forum
        • Alliance System Integrators Forum
        • Machine Solutions in the Digital Transformation
        • EcoStruxure Automation Expert / IEC 61499 Forum
        • Industrial Edge Computing Forum
        • Level and Pressure Instrumentation Forum
        • Modicon User Group
        • PLC Club Indonesia
        • SEE Automation Club Forum
        • Fabrika ve Makina Otomasyonu Çözümleri
        • Форум по промышленной автоматизации СНГ
      • SCADA & Telemetry Solutions
        • Geo SCADA Expert Forum
        • SCADA and Telemetry Devices Forum
      • Power Distribution IEC
        • Power Distribution and Digital
        • Power Standards & Regulations
        • Paneelbouw & Energie Distributie
        • Eldistribution & Fastighetsautomation
      • Power Distribution Softwares
        • EcoStruxure Power Design Forum
        • SEE Electrical Building+ Forum
        • LayoutFAST User Group Forum
      • Wireless Information Network Solutions
        • Instrument Area Network
        • Remote Monitoring
        • Tank Level Monitoring
        • Remote Data Collection
      • Solutions for your Business
        • Solutions for Food & Beverage Forum
        • Solutions for Healthcare Forum
      • Food & Beverage
        • Solutions for Food & Beverage Forum
      • Healthcare
        • Solutions for Healthcare Forum
  • Blogs
    • By Topic
        • Industrial Automation
          • Industrial Edge Computing Blog
          • Industry 4.0 Blog
          • Industrie du Futur France
        • SCADA & Telemetry Solutions
          • SCADA and Telemetry Blog
        • Power Distribution IEC
          • Power Events & Webinars
          • Power Foundations Blog
        • Power Distribution NEMA
          • NEMA Power Foundations Blog
        • Power Distribution Softwares
          • EcoStruxure Power Design Blog
          • SEE Electrical Building+ Blog
        • Solutions for your Business
          • Solutions for Food & Beverage Blog
          • Solutions for Healthcare Blog
          • Solutions for Retail Blog
        • Community experts & publishers
          • Publishers Community
    • By Segment
        • Food & Beverage
          • Solutions for Food & Beverage Blog
        • Healthcare
          • Solutions for Healthcare Blog
        • Retail
          • Solutions for Retail Blog
      • Industrial Automation
        • Industrial Edge Computing Blog
        • Industry 4.0 Blog
        • Industrie du Futur France
      • SCADA & Telemetry Solutions
        • SCADA and Telemetry Blog
      • Power Distribution IEC
        • Power Events & Webinars
        • Power Foundations Blog
      • Power Distribution NEMA
        • NEMA Power Foundations Blog
      • Power Distribution Softwares
        • EcoStruxure Power Design Blog
        • SEE Electrical Building+ Blog
      • Solutions for your Business
        • Solutions for Food & Beverage Blog
        • Solutions for Healthcare Blog
        • Solutions for Retail Blog
      • Community experts & publishers
        • Publishers Community
      • Food & Beverage
        • Solutions for Food & Beverage Blog
      • Healthcare
        • Solutions for Healthcare Blog
      • Retail
        • Solutions for Retail Blog
  • Ideas
        • Industrial Automation
          • Modicon Ideas & new features
        • SCADA & Telemetry Solutions
          • Geo SCADA Expert Ideas
          • SCADA and Telemetry Devices Ideas
  • Knowledge Center
    • Building Automation Knowledge Base
    • Industrial Automation Knowledge Base
    • Industrial Automation How-to videos
    • SCADA & Telemetry Solutions Knowledge Base
    • Digital E-books
    • Success Stories Corner
    • Power Talks
  • Events & Webinars
    • Innovation Talks
    • Innovation Summit
    • Let's Exchange Series
    • Technology Partners
  • Support
    • Ask Exchange
    • Leaderboard
    • Our Community Guidelines
    • Community User Guide
    • How-To & Best Practices
    • More
Join Now
How can we help?
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
51304members
Join Now
245511posts
Join Now

Historic Aggregate equivalent to 'Start Last'

Options
  • Subscribe to RSS Feed
  • Mark Topic as New
  • Mark Topic as Read
  • Float this Topic for Current User
  • Bookmark
  • Subscribe
  • Mute
  • Printer Friendly Page
Solved Go to Solution
Back to Geo SCADA Expert Forum
Solved
rlao
Ensign rlao
Ensign
‎2020-01-29 04:29 PM
0 Likes
9
1628
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-01-29 04:29 PM

Historic Aggregate equivalent to 'Start Last'

So the 'Max' and 'Min' historic aggregates have a 'Max Last' and 'Min Last' version where if the sample period only contains a single value, the aggregate will also grab the last preceding value before the sample period.

 

Is there an equivalent way to do a 'Start Last' for the 'Start' historic aggregate, i.e. if the sample period only contains one single value, don't grab that single value as your 'Start' but look at the immediate preceding value before the sample period?

 

I'm trying to implement a Delta calculation and this is tripping me up because the aggregate will return a 0 if the sample period only has a single value but there is no option to tell it to look for the last preceding value. The latter option would be very useful for doing delta calculations on points that have infrequent sampling.

Solved! Go to Solution.

Labels
  • SCADA
Share
Reply

Accepted Solutions
JChamberlain
Lieutenant JChamberlain Lieutenant
Lieutenant
‎2020-02-10 07:43 PM
0 Likes
2
1507
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-02-10 07:43 PM

Re: Historic Aggregate equivalent to 'Start Last'

PDEV-2046, votes from both of you.

See Answer In Context

Share
Reply
  • All forum topics
  • Previous Topic
  • Next Topic
9 Replies 9
BevanWeiss
Sisko BevanWeiss
Sisko
‎2020-01-29 08:21 PM
0 Likes
8
1622
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-01-29 08:21 PM

Re: Historic Aggregate equivalent to 'Start Last'

'Start' is not a historic aggregate, neither is 'Runtime' if you have that also.  These are 'Historic Algorithms' 😉

 

And both 'Start' and 'Runtime' are custom Historic Algorithms, meaning that they do NOT ship by default with ClearSCADA (or Geo SCADA Expert).

You (or someone else) has had to go into the Server Configuration utility, and go to Database Configuration -> Historic Algorithms and create these.  This means there are some limitations to their configuration which don't exist with the built-in algorithms (since obviously Aveva have access to all the magic in the backend when they are coding up the built-in algorithms).

 

I think that you're potentially out of luck on this.  But it's probably worth raising a feature request to get the 'at end' and 'at start' additions to custom Historic Algorithms.  Although I suspect that even if they are implemented, it wouldn't be within the timeframe that you need.

 

If your interval time isn't dynamic then you could map your starts into Calculation Points, and then use 'Value at end of the interval' and 'Value at start of the interval' to get results... but it's definitely not perfect.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
Share
Reply
AdamWoodland
Lt. Commander AdamWoodland Lt. Commander
Lt. Commander
‎2020-01-29 08:59 PM
0 Likes
7
1616
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-01-29 08:59 PM

Re: Historic Aggregate equivalent to 'Start Last'

The OPC-HDA quality flags may be of help here, combined with some COUNT(). Its a little messy but might help

Share
Reply
AndrewScott
Lieutenant AndrewScott
Lieutenant
‎2020-01-30 03:12 AM
0 Likes
6
1606
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-01-30 03:12 AM

Re: Historic Aggregate equivalent to 'Start Last'

@rlao wrote:

So the 'Max' and 'Min' historic aggregates have a 'Max Last' and 'Min Last' version where if the sample period only contains a single value, the aggregate will also grab the last preceding value before the sample period.

This isn't correct, the number of values of in the sample period (zero, one or more) doesn't make any difference with the "Min Last" and "Max Last" algorithms. The last value before the sample period is always included in the calculation.

 

@BevanWeiss wrote:

'Start' is not a historic aggregate, neither is 'Runtime' if you have that also.  These are 'Historic Algorithms' 😉

 

And both 'Start' and 'Runtime' are custom Historic Algorithms, meaning that they do NOT ship by default with ClearSCADA (or Geo SCADA Expert).

This isn't correct. "Start" is a standard historic algorithm, its from the OPC HDA standard and is included in ClearSCADA / Geo SCADA Expert. "Runtime" however is a custom algorithm.

 

 

Whilst there isn't a "Start Last" algorithm, there is the "End Last" algorithm could this be of use? This gives the last value in the sample period or the preceding value if there are no values in the sample period.


Andrew Scott, Lead Engineer, AVEVA
Share
Reply
BevanWeiss
Sisko BevanWeiss
Sisko
‎2020-01-30 11:53 PM
0 Likes
0
1587
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-01-30 11:53 PM

Re: Historic Aggregate equivalent to 'Start Last'

My bad, I ran off on a tangent.  Replace all of my 'Start' mentions with 'Starts' (i.e. count of 0->1 transitions).

I was definitely thinking that we were trying to get a delta on 'Starts'...  which is a Custom Algorithm (like Runtime.. hence why I mentioned that).

 

I see the issue now.  I think this is definitely deserving of a feature request.  If there is an End Last, then there should be a Start Last.  I can imagine quite a few situations where you'd want to obtain the 'oldest' value from the interval (and if there is no value within the interval, then the newest value prior to the start of the interval).

 

You'd need to do some conditional stuff to use EndLast.. since if Start returns a valid value that would be prefered to EndLast of all time before the interval you selected.

 

I think Adam might be right... a historic query might be the only way currently.

 

I feel I did some Delta stuff mid last year which would have used something similar... I think I ended up just doing a calculation point and using Delta.  Perhaps a DeltaInclusive might be more useful... that would always return a delta that is 'valid' across a time interval, even if it has to extend outside of the time interval to retrieve either/or Start / End point.


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
Share
Reply
rlao
Ensign rlao
Ensign
‎2020-02-02 09:11 PM
0 Likes
4
1575
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-02-02 09:11 PM

Re: Historic Aggregate equivalent to 'Start Last'

Hi Andrew,

 

Yes apologies I was mistaken on the my understanding of Min/Max Last algorithms. I should have used 'End Last' as the example of what I was after.

 

Unfortunately, 'End Last' is similar but not exactly what I am after. I was looking for a way to return the first value in the sample period and to look to the preceding value only if there is no values in the sample period, hence 'Start Last'.

 

My ultimate aim was a Delta algorithm that wouldn't simply return a zero value if there were only one sample in the sample period, but instead look to the preceding sample before the sample period to calculate difference between first and last value. If there existed a 'Start Last' algorithm, I can simply do a subtraction between 'Start Last' and 'End' to accomplish this.

 

Although now that I think about it, 'Start Last' minus 'End' probably won't work as I would need 'Start Last' to look at the preceding value if there is only one value in the sample period, not no values in the sample period.

 

In the end I wrote up a bit of scripting to achieve what I wanted, but it would be very handy to have a variant of the Delta algorithm that looks at preceding values if there are insufficient samples in the sampling period. @BevanWeiss more or less hit the nail on the head with his description of a 'DeltaInclusive' algorithm.

 

Time to bug my Schneider support contact with another feature request.

 

 

Share
Reply
BevanWeiss
Sisko BevanWeiss
Sisko
‎2020-02-03 01:55 AM
0 Likes
3
1566
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-02-03 01:55 AM

Re: Historic Aggregate equivalent to 'Start Last'

@rlao If you let me know the PDEV I'll upvote it

I expect that it should be relatively easy for an intern or such to be given it as an introductory Geo SCADA Expert development task...

 

I think even if there was a 'Start Last' and an 'End Last' it wouldn't give you what you wanted... since if you only have one point in your interval, then it is both the Start and the End (the alpha and the omega...) and you'd be back to a delta of 0/0 (but without any magic calculus limits as x->inf) 😉


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
Share
Reply
JChamberlain
Lieutenant JChamberlain Lieutenant
Lieutenant
‎2020-02-10 07:43 PM
0 Likes
2
1508
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-02-10 07:43 PM

Re: Historic Aggregate equivalent to 'Start Last'

PDEV-2046, votes from both of you.

See Answer In Context

Share
Reply
rlao
Ensign rlao
Ensign
‎2020-02-10 08:11 PM
0 Likes
0
1504
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-02-10 08:11 PM

Re: Historic Aggregate equivalent to 'Start Last'

Thanks Jesse, I'll mark this as solved.

Share
Reply
tfranklin
Lieutenant tfranklin
Lieutenant
‎2020-06-20 08:10 AM
1 Like
0
836
  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎2020-06-20 08:10 AM

Re: Historic Aggregate equivalent to 'Start Last'

Sounds like something I'm needing right now too.  Throw my upvote at it!

 

I've been trying to use delta this week to calculate the difference in start/end value of an hourly interval with a historic algorithm, but ran into issues since delta doesn't carry over the value from the previous interval.  In my head I was expecting it to work like End Last would, so I'll dub it Delta Last.

Tags (1)
  • Tags:
  • english
Share
Reply
Top Experts
User Count
sbeadle
Sisko sbeadle Sisko
188
BevanWeiss
Sisko BevanWeiss
53
AdamWoodland
Lt. Commander AdamWoodland Lt. Commander
16
JChamberlain
Lieutenant JChamberlain Lieutenant
16
AndrewScott
Lieutenant AndrewScott
15
See More Top Experts
Find a Service Provider
Find a certified partner to help you address your integration, installation, maintenance and project needs.
View all Providers
Support

Have a question? Please contact us with details, and we will respond.

Contact Us
FAQ

Look through existing questions to find popular answers.

Learn More
About

Want to know more about Exchange and its possibilities?

Learn More

Full access is just steps away!

Join Exchange for FREE and get unlimited access to our global community of experts.

Connect with Peers & Experts

Discuss challenges in energy and automation with 30,000+ experts and peers.

Get Support in Our Knowledge Base

Find answers in 10,000+ support articles to help solve your product and business challenges.

Ask Questions. Give Solutions

Find peer based solutions to your questions. Provide answers for fellow community members!

Register today for FREE

Register Now

Already have an account?Log in

About Us FAQ Terms & Conditions Privacy Notice Change your cookie settings
©2020, Schneider Electric