Perspective - Status/ribbon chart

Ignition
22

@drojas Also looking for some input on using this view with a Named Query. I have multiple machine IDs but have all the states tied to each machine as a column with a timestamp start. Do you have an input example pulling the data directly from the named query? Or does it still need the transform scripting from the query. Looking to drop a page-configurable range, which will update the query table. 6 states per machine and a total of 26 machines. Will likely break up into sub-pages, but data for this would still come from the same named query and filter out based on selection.

Thanks in advance.

23

Unless you are crafty enough to generate the SQL named query to output the JSON as the ribbon chart expects, I would just stick with doing a transform script.

24

I’ve got my named query setup to deliver the outputs as Start, End, machineid, state with a common t_stamp output but I can adjust my query without a problem. I’m just looking for some input on how to properly set it up. The majority of my experience is in Vision, so looking to see how this gets setup pointing to the query. Thanks in advance.