We are monitoring several CNC machines for their status (idle/in process/in alarm). Using the Ignition historian, we have a database containing timestamp, and several columns for machine status (integer). In Vision, we have a status chart to show the status of each machine over the last 24 hours. This works well. Our historian is currently set to log data on change with a maximum time of 1 minute.
I am now replicating the system in Perspective. With the help of the following posts, I have a basic “ribbon” chart working in Perspective.
I am now stuck on how to translate the data from our historian to the array type format required by the XY chart. Our historian query returns data as a dataset (2D array). The required format for the perspective component appears to be as follows:
“fromDate”: “2018-01-01 08:00”,
“toDate”: “2018-01-01 10:00”,
“fromDate”: “2018-01-01 12:00”,
“toDate”: “2018-01-01 15:00”,
Can anyone explain the basic process for feeding the perspective XY chart with data from the ignition historian? Any pointers?