Energy Monitoring with Factry Historian

In this document, we describe how to set up an example dashboard for energy monitoring. We will do so using the Faketory demo datasetFaketory demo dataset.

In the energy monitoring use case, we will build a basic dashboard showing the following metrics:

To make the dashboard a bit dynamic, we will also add a variable to select a specific line or all lines.

You can see the end result of this dashboard on the Factry demo environment .

Consult the prerequisites of Energy Monitoring & Attribution.

Start by creating a new dashboard in Grafana.

In the newly created dashboard, navigate to Settings > Variables. Click + New variable. Then, configure the new variable as follows:

Then, click Save dashboard and give your dashboard a fitting name e.g. 01. Basic Energy Monitoring.

In our KPI row, we want to display the total energy usage across the whole plant yesterday, today, and per line. The stat panel  is ideal for displaying single values like KPIs.

For each panel, click Add > Visualization. Then, select the Factry Historian datasource.

Total Power Usage (Yesterday)

In the Queries tab, open the Query options dropdown and enter the following:

In the same Queries tab, select the Measurements tab from the Factry Historian datasource. Then, configure the following:

All other query settings can remain at their defaults.

Finally, in the Transformations tab, click + Add transformation and select the Merge seres/tables transformation. This will merge the datasets from all energyUsage measurements together.

Now, slide open the Visualization selection on the right. Select the Stat panel type and configure the following:

Then, click <- Back to dashboard and resize your Stat panel to sit neatly on top.

Total Power Usage (Today so far)

As this panel is very similar to the "Total Power Usage (Yesterday)" we just created, we will duplicate this panel. On the dashboard view, hover over the previously created panel, click the ⋮button, and click More > Duplicate.

A duplicate Stat panel is created. Click the ⋮button and select Edit. Now change the following settings:

In the Queries tab, open the Query options dropdown and enter the following:

Slide open the Visualization selection on the right. Configure the following:

Line 1 Power Usage (Today)

Duplicate the "Total Power Usage (Today)" panel we created earlier by hovering over it, clicking the ⋮button, and clicking More > Duplicate. Then edit the panel and change the following:

In the same Queries tab, select the Measurements tab from the Factry Historian datasource. Then, configure the following:

Slide open the Visualization selection on the right. Configure the following:

Line 2 Power Usage (Today)

This follows the same logic as Line 1 above. Substitute Line_1 with Line_2.

We should now have our KPI row that looks like this.

Now would be a good time to save your dashboard.

On the dashboard view, click Add > Row. Click its gear icon and give it a Title Bulk Transport Pumps.

Then, click Add > Visualization. Select the Factry Historian datasource.

In the same Queries tab, select the Measurements tab from the Factry Historian datasource. Then, configure the following:

Slide open the Visualization selection on the right and select the Bar chart  type. Configure the following:

Then, click <- Back to dashboard and place your Bar Chart panel under the "Bulk Transport Pumps" row. Try toggling the row to see if it's neatly nested underneath.

Select Line 1, Line 2, or All from the dropdown meny. The Bar chart panels should repeat automatically, and the title should show e.g. Bulk Transport Pumps for Line 1.

For the mixer row, we follow the same logic as the "Bulk Transport Pumps" row, with the exception of the following query in the Query tab:

Measurements: ${line}.*/M1/P.*energyUsage

Your basic energy dashboard show now look like this.