Mixer status dashboard

introduction this document describes how to set up a mixer status dashboard it gives a real time overview of every mixer across all selected lines, showing running state, current batch step, availability, quality pass rate and finished batch count — all on a single screen audience floor operators, shift leads purpose real time awareness of mixer state across multiple lines dashboard layout each row on this dashboard represents one mixer and repeats automatically as lines or mixers are added within each row running status, current recipe and cleaning flag current batch step quality pass rate availability finished batches today key design decisions rows repeat per mixer the row is configured to repeat by the $mixer variable, so one row appears per mixer value this means the dashboard scales to any number of lines without any panel duplication — adding a third line automatically adds a third row the $mixer variable uses asset path as value this is what makes the row title $mixer display a readable name like line 1\mixer rather than a uuid step by step creating variables $line and $mixer create variable $line this variable is visible in the dashboard header so the operator can filter to one or more lines general name line label line query options query type asset parent assets no parent selection options multi value checked deselect 'allow custom values' create variable $mixer general name mixer hide variable query options query type asset filter by asset path /mixer/ parent assets $line use asset path as value checked selection options include all option checked multi value checked deselect 'allow custom values' creating a repeating row click > row and configure the row options title $mixer (because $mixer uses asset path as its value, the row title will render as the full path, e g line 1\mixer ) enable row repeat in the row options repeat for variable mixer grafana will render one row per value of $mixer , stacked vertically all panels placed inside the row are automatically repeated alongside it add a stat visualisation — running status, recipe and cleaning flag this full width panel shows three properties side by side as stat cells whether the mixer is running, which recipe is currently active, and whether it needs cleaning click > visualisation and select data source factry historian datasource configure the data source tab assets asset $mixer properties running , current recipe , needs cleaning aggregation last , period $ interval include last known point checked (ensures a value is always shown even if no new data has arrived in the current interval ) add transformations by default the historian returns one time series per property these three transformations pivot them into separate columns so the stat panel can display them as individual cells join by field — joins all series on their time field into a single wide table labels to fields — keep labels assetproperty , value label assetproperty this promotes the assetproperty label into a column name, giving you running , current recipe and needs cleaning as separate fields organize fields — hide time reorder fields running first, current recipe second, needs cleaning third change visualisation to stat and configure panel options panel options title (leave empty — the row title already identifies the mixer) transparent background checked value options fields all fields reduce last (not null) stat styles orientation vertical color mode background text mode value title size 30 , value size 30 field overrides running add value mappings — true → text running , color dark green ; false → text stopped , color dark red needs cleaning add value mappings — true → text needs cleaning , color orange ; false → text , color transparent current recipe color → fixed color #8080804d (muted grey); value mapping — empty → text no recipe , color transparent add a stat visualisation — current batch step this panel shows the name of the most recently started batch step (filling, mixing or emptying), giving the operator an at a glance view of where in the batch cycle the mixer currently is click > visualisation and 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 limit 1 (only the most recent event is needed ) change visualisation to stat and configure panel options value options fields /^eventtype$/ reduce last (not null) stat styles color mode none graph mode area text mode value panel options title (leave empty) transparent background checked add a stat visualisation — quality pass rate this panel shows the fraction of emptying step events in the selected time range where the visual inspection result was pass click > visualisation and select data source factry historian datasource configure the data source tab events query type simple assets $mixer event types emptying step properties visual inspection result add transformations the same pattern used in the weekly report dashboard to compute a pass rate filter by value — exclude rows where visual inspection result is null group by — group by visual inspection result , aggregate as count transpose — pivots outcome values into columns ( pass , fail , needs review ) with their counts as values calculate field — leave options empty adds a total column by summing all value columns calculate field — mode binary operation left pass operator / right total replace all fields checked change visualisation to stat and configure panel options panel options title quality transparent background checked standard options unit percent (0–1) stat styles color mode value graph mode area add a stat visualisation — availability this panel shows what percentage of the selected time range the mixer was running it uses a mean aggregation with forward fill on 1 minute buckets, then averages across all buckets because running is a boolean (1/0), forward filling ensures that gaps between state changes don't create zero weight buckets, making the mean a reliable approximation of true time weighted availability click > visualisation and select data source factry historian datasource configure the data source tab assets asset $mixer property running aggregation mean , period 1m fill previous (forward fills the last known value into any gap, so a 1 minute bucket with no new data inherits the prior running state rather than being treated as zero ) change visualisation to stat and configure panel options panel options title availability transparent background checked value options reduce mean (averages across all 1 minute buckets in the time range to produce a single availability figure ) standard options unit percent (0–1) stat styles color mode value graph mode none add a stat visualisation — finished batches today this panel counts the number of completed mixing batch events since midnight, regardless of the dashboard time range it uses a panel level time override so it always reflects today's count even if the operator has zoomed into a shorter window elsewhere click > visualisation and select data source factry historian datasource configure the data source tab events query type simple assets $mixer event types mixing batch statuses processed , pending (including pending captures batches that have started but whose records have not yet been fully closed ) limit 1000 set a panel level time override in the panel options under time range override relative time now/d (this pins the panel's query start to midnight today, independent of the dashboard time picker the operator can zoom in or out on other panels without affecting this count ) change visualisation to stat and configure panel options panel options title finished batches transparent background checked value options fields /^eventtype$/ reduce count stat styles color mode value graph mode area end result the finished dashboard shows one row per mixer, populated automatically from the $line variable each row gives a complete snapshot whether the mixer is running, what step it is on, how reliable it has been, what quality looks like, and how many batches have been completed today — all without navigating away from a single screen