Operator dashboard

introduction t his document describes how to set up an operator dashboard focused on batch operations we will do so using the docid\ tjw2vwpk12gu3z5awhr4a , particularly the data pertaining to the mixing area audience floor operators, shift leads purpose real time awareness and immediate action dashboard layout current status realtime process trends batch steps history step by step creating variables $line and $mixer using grafana variables is a great way to make a dashboard dynamic using the docid 0ot9aeru3hfa48s2ukb4f you can populate these variables with value from factry historian create variable $line there are 2 production lines in faketory, so to make the dashboard works for both, create a variable that represents which line is currently being visualised $line configure the name and label of the variable general name line label line using lowercase for variable names is widely considered good practice configure the query to populate the variable with values query options query type asset filter by asset path /^line/ this regular expression search pattern matches all assets in the asset tree for which the path starts with "line" parent assets no parent configure the selection options to only allow a single selection selection options deselect 'allow custom values' create variable $mixer the line 1 and line 2 assets do not contain any properties themselves, so create a $mixer variable as well, but hide it from the dashboard it will automatically change to the correct mixer asset based on the $line variable general name mixer label mixer query options query type asset filter by asset path /mixer$/ parent assets $line selection options deselect 'allow custom values' creating a new row "status $line $mixer" rows are a handy tool to organize a dashboard in specific sections that can be minimized or expanded on demand this row will focus on the current value of the mixer properties click > row create a new row to visualize the current status of the selected mixer configure the new row options the new variables can already be tested by creating a dynamic row title "status $line $mixer" click update add a new stat visualisation click > visualisation select data source factry historian datasource configure the data source tab assets assets $mixer properties running aggregation last change visualisation to stat in general you can use stat panels to display the last value of important properties configure the stat panel options panel options title ( for the other properties it might make more sense to use a title leaving this empty makes the actual panel larger, which looks better ) value options fields line 1\\\mixer\\\running by default the stat panel only shows numeric fields which do not include booleans stat styles text mode value color mode background solid graph mode none value mappings true > running , set color green false > stopped , set color red resize the panel go back to the dashboard, move the panel to the first row and resize the panel save your dashboard this process can be repeated for other properties and the end result could look like this screenshot below creating a new row process trends this row will focus on visualising the values of the mixer properties over time click > row configure the new row options row title process trends click update drag the new row to the bottom to drag a row, it must first be collapsed click the collaps button on the left of the row title drag the row with the drag icon on the right uncollapse the row add a new time series visualisation see docid\ nfccwy9aovwf8xpvni13k click > visualisation select data source factry historian datasource configure the data source tab assets assets $mixer properties temperature change visualisation to time series in general you can use time series panels to display how numeric values change over time configure the panel options panel options title temperature transparent background checked ( for most visualisations, this just looks better ) legend mode table values min max mean graph styles line width 2 fill opacity 10 \[optional] change the field name this makes the legend visually cleaner standard options display name ${ field labels\["assetproperty"]} add the transformation labels to fields select labels assetproperty value field name assetproperty resize the panel go back to the dashboard, drag the panel to the second row and resize the panel this process can be repeated for the other properties rpm and level in the end result could look like this screenshot below creating a new row recent events this row will focus on showing the latest batch steps in a table click > row configure the new row options row title recent events click update drag the new row to the bottom add a new table visualisation see docid\ h6ybvqvqpr4v1m xxdnpo click > visualisation select data source factry historian datasource configure the data source tab events query type simple assets $mixer event types filling step mixing step emptying step add transformation merge series/tables the query returns a separate table for each event type by default, this transformation merges those into one add transformation filter fields by name this transformation allows you to select the field you want and deselect the ones you don't want to see in the table by hand select at least eventtype starttime stoptime add transformation sort by after bringing the tables together with the merge transformation, the events are no longer in chronological order field starttime reverse checked change visualisation to table in general you can use table panels to display events with their simple properties configure the panel options panel options title to color the different eventtype values in different colors, there are 2 options click + add field override > fields with name fields with name eventtype click + add override property > cell type cell type pill (this will highlight different field values in standard different colours, which makes the event types more visually distinctive in the table ) value mappings click add value mappings value mixing step display text leave empty color choose color repeat for filling step and emptying step placement of the panel go back to the dashboard, drag the panel to the correct row and resize add a new state timeline visualisation click > visualisation select data source dashboard since the event data was already queried by the previously created table panel, we can re used that dataset and the transformations for this new panel source panel pick the correct panel pick the correct panel transform checked change visualisation to state timeline in general you can use state timeline panels to display how the state of something changes over time this panel type can also interpret a second timestamp to indicate the end of the 'state' configure the panel options panel options title transparent background checked legend visibility unchecked value mappings click add value mappings value mixing step display text leave empty color choose color (best to use the same colors as the previous panel ) repeat for filling step and emptying step resize the panel go back to the dashboard, drag the panel to the second row and resize the panel end result the end result should look like something like this screenshot below