I'm trying to use a Status Chart to display the history of a machine. The dataset contains a timestamp_of_transaction, duration_since_last_change, color_for_status, and status_code. I've looked through the documentation but I'm struggling to see how to wire the chart up.
Can anyone offer a link or any insight on how to wire the chart? My goal is to show over the course of the shift what the machine status has been (Production, Setup, Problem, Break, Off) and in an ideal world the future time of the shift would show to the right as gray.
The data property of the chart should have at least two columns. The first column will be for the timestamp, and each additional column will be for the status code of a particular machine.
Whatever header name is given to the machine column will be the name displayed for the machine's corresponding status bar.
The easiest way to set up the status colors is to right click on the chart and select "Status Chart Customizer"
From there, simply assign each possible status code a color:
Each machine can be set up independently, or a color scheme can be applied to all:
It is also possible to assign a color scheme directly using the chart's properties property:
These datasets could be "wired" just like anything else with query bindings, initialization scripts, etc
