Usage Points

Datalake is an accelerator specific to power utilities. When enabled, it can be accessed via the menu button ( ) in the top-left corner of the Utilihive Console.

Map

The first thing you’ll see when opening Datalake in the Utilihive Console is a visual map that highlights the physical location of usage points (i.e., meters). The more distant view presents a heatmap of clustered usage points. Zoom in to see the individual usage points appear, as the following image demonstrates:

The console displays a map of Oslo with several pins highlighting meter locations.

Select the layers buttons ( ) on the right side of the map to open the following options:

An overlay displays three toggles for usage points,communication points,and events.

From here, you can toggle the visibility of usage points and events on the map. Events will only appear if they fall within the time range set by the top-right calendar button ( ). The following image displays events over a 30-day period:

The map of Oslo displays several green,yellow,and red dots with a color-coded time chart underneath.

Events are color-coded to signify the following:

Color Description

Red

A meter failed or was tampered with.

Yellow

There was a missed reading (e.g., the meter temporarily disconnected).

Green

A previous negative event returned to normal (e.g., a connection was restored).

Details

Selecting an event or usage point on the map will open that usage point’s details. You can also access these details by selecting "Usage points" from the left-hand navigation menu.

Meter Readings

Usage point details include a "Meter Readings" tab and "Message Log" tab, both of which are affected by the top-right time range. The following image demonstrates a meter readings graph over a seven-day period:

A bar graph displays meter readings by hour,with some hours highlighted in orange instead of green.

Readings that appear orange in the graph signify that the quality of the reading was affected by an event like a power failure. These events will also appear in the "Message Log" tab.

Click and drag on the graph to select a portion of the readings. The selected readings will appear in the list underneath the graph and can be downloaded as a CSV file via the download button ( ). An example CSV output would look like the following, where values in parentheses represent quality issues:

"Time";"Δ Forward - WH"
"1632884400000";"0.76"
"1632888000000";"0.971"
"1632891600000";"0.824"
"1632895200000";"0.8373636363636363 (2.2.32,2.5.259,3.8.1001)"
"1632898800000";"0.8507272727272728 (2.2.32,2.5.259,3.8.1001)"
"1632902400000";"0.8640909090909091 (2.2.32,2.5.259,3.8.1001)"

The meter readings graph can be altered by selecting the tune button ( ) above the graph. Doing so will reveal the following options:

A form displays dropdowns to change the date,channel,source,and several other options for a meter reading.

Here, you can change the channel of the reading or add additional channels for a side-by-side comparison. These changes will also be reflected in the downloaded CSV file.

The "Related Assets" tab specifies if a usage point is (or belongs to) a parent usage point and lists the relevant IDs. If you select the ID of a parent, the map view will change slightly to show all of the connected usage points within that group. The following image demonstrates what this will look like:

The map displays a usage point that connects via curved lines to several other usage points.