Auto Recalculate when data become Available

Feedback / Product Ideas and Feature Requests / Calculations & Events

charles
4 yrs ago
4replies
Not planned

Often times data won't be available in the calculations server due to site disconnects to the sender. Can you have canary calc server sense when that data makes its way to the calc server/historian and auto recalculate? This would help in manually having to remove/recalc data.

- charles
- 4 yrs ago
- Reported - view
Any updates on this?
- Helping you release your data rockstar!
- Jeff_Knepper
- 4 yrs ago
- Reported - view
Good morning Charles. The Canary team has reviewed the issue. As you know, the Calculation Server relies on a steady stream of data to accurately run 'periodic' calculations; meaning the calculation will run as scheduled whether one or all of the data points that feed it have successfully made it from the field to the historian. When the calculation runs prior to the data arriving, obviously the KPI calc is not valid. The issue lies in not having a way to efficiently rerun all of the calculations and overwrite or version changes in them.

We would strongly recommend our partner, Flow Software to solve this problem. They specialize as a KPI calc and management tool that is built for these exact situations. I have verified with them that they re-run their period KPI calcs on schedule as version any changes. Additionally, there are a few other benefits that you would pick up from their system as well that Canary does not and will not support in the future.

I know this may not be the answer you hoped for, but I wanted to be as transparent as possible. Our roadmap is currently focused on advancing our product in another exciting direction.
- System Engineer | CSE ICON
  
  davin_ross
  
  5 days ago
  
  Reported - view
  I am interested to see if Canary has reevaluated this request recently. With the new backfilling enhancements in 25.4, it seems more feasible to automatically enable calculations when data is backfilled by the source rather than relying on users to manually queue the backfill operations.
- smason
  
  2 days ago
  
  Reported - view
  We have not reevaluated this request recently. When we first investigated the effort to support this feature, it proved to be more complex than we initially thought, especially when you start considering asset-based jobs that can come from multiple sources. I don't think we've completely ruled it out, but how it could implemented would be different. A simpler solution we've considered is to create a automatic backfill setting which the job would do at a set period of time and go back a certain amount of time in the past as configured by the user. So you could maybe schedule the job to backfill every day at midnight and go back over the last 2 days. The biggest downside is your waiting a day (or whatever time is configured) to correct erroneous data unless you manually intervene sooner.