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
-
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.-
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?
-
Print this page