0

Aggregate Interval Picker

I have 2 x DateTime pickers that return the start and end values of motor run hours correctly in 2 x Value Boxes. I need to either:-

Subtract ValueBox1 From ValueBox2 and put results into ValueBox3

 

Or

 

Apply a user selectable Aggregate Interval preferrably using the Interval Picker used for trend graphs

2 replies

null
    • smason
    • 1 yr ago
    • Reported - view

    Hi Derwyn Oxley ,

    What version of Canary do you have running? Starting in v22.2, you can link a control to a SourceTag or build a Calculation using other controls as its input. This would fit perfectly with your first option.

    If you need to upgrade to get this functionality, go to https://helpcenter.canarylabs.com/t/p8ha73w/v22-3-1 and select REQUEST UPGRADE. We'll send you the latest version provided the serial number has active customer support.

      • System Integrator
      • derwyn
      • 1 yr ago
      • Reported - view

      Steve Mason Thanks Steve, I managed to load a temp license on my laptop and use the new calc function. I can now display the result of the 2 x run hour readings - success!. I will need to update the client installation but running that down a different channel.

      I would now like to enhance the information and need to have a new calculation - Time Value Between the 2 x controls - How many hours has the user selected using the 2 x pickers. I can then display the device run hours as a percentage of the selected period.

      I tried creating variables in script to read the datetime but not successful so far. I also tried adding a value box to then read or contain the date time picker value but also unsuccessful. Perhaps it's syntax in the script? Is there a way to take the datetime selected by the user as a number and subtract the end - start times?

Content aside

print this pagePrint this page
  • 1 yr agoLast active
  • 2Replies
  • 234Views
  • 2 Following