View as Markdown

Data Explorer

The Data Explorer plots time-series data from your Devices so you can compare readings across the fleet, spot patterns, and dig into specific moments in time. It shows either raw readings exactly as devices sent them or statistical aggregations over any time range, and it exports what you see to CSV.

Introduction

After your hardware is Connected, readings are Collected through the Edge Server, and the data is Stored in the platform, the Analyze stage is where you make sense of it. Open Data → Explorer in the sidebar; the Explorer takes over the full screen, and the back arrow in the top left returns you to the platform.

Typical uses: troubleshooting recent device behavior with raw readings, plotting minimum, maximum and average of a sensor together to see its daily range, comparing the same measurement across several Devices, and pulling a CSV for a report. Once you know which Variables matter, the Visualize stage puts them on a dashboard with the Graph widget.

Video Tutorial

Quick Links:Open in new tabWatch on YouTube

Part of the Analyze stage in the ControlCom Connect data workflow.

The Explorer Layout

The top bar holds the time controls: quick presets, the date range, the bucket selector and the data mode. Below it, the chart fills most of the screen, with a strip of time jump buttons underneath and a data table at the bottom. The right column lists the Variables on the chart, with a Variable Details panel below it that shows the live value, device, unit and aggregation of whichever Variable you click.

The panels are resizable: drag the dividers to give the chart, the table or the variable list more room.

The Data Explorer plotting minimum, maximum and average of a utility demand Variable over 24 hours, with the data table below and the variable list on the right
A utility demand reading over 24 hours: min, max and average plotted together

Raw and Aggregated Modes

The selector at the right end of the top bar switches between the two data modes.

Aggregated is the default. Each Variable is summarized per time bucket using one or more aggregations, over any time range. You can add the same Variable several times with different aggregations, which is how you plot a sensor's minimum, maximum and average together to see its full range. There is no limit on the number of Variables.

Raw Data shows readings exactly as the Device sent them, with no aggregation. It is the mode for troubleshooting, since nothing is smoothed away. To keep it fast, a raw view covers at most 3 hours and 40 Variables; the time span can sit anywhere in history, not just the last hours.

Switching modes keeps your Variables and tells you what will change: moving to Raw Data drops the aggregations and trims the range to 3 hours if needed, and moving to Aggregated assigns each Variable the average aggregation as a starting point.

The Data Explorer in Raw Data mode showing one hour of unaggregated readings for a utility demand Variable
Raw Data mode: every reading as the Device sent it, nothing smoothed away

Time Range and Buckets

The preset buttons 1h, 6h, 24h, 7d and 30d set the range in one click, each with a bucket size to match. For anything else, the date picker opens with two calendars, Start and End time fields, and presets such as Last 7 days, This Week and Last Month; click Update to apply.

In Aggregated mode the bucket selector sets how much time each data point summarizes, from 5 seconds up to 1 year. Smaller buckets give more detail; larger buckets mean fewer points and faster rendering.

A bucket has to fit the selected range: the range must cover at least two buckets and at most 6000. Incompatible buckets are greyed out in the selector, and opening one shows three one-click fixes, such as extending the end date, extending the start date, or extending the range in both directions equally. Picking a fix applies the new range and the bucket in one step and refreshes the data.

Adding Variables

Click the + button at the top of the variable list. The picker browses your Organization in three columns: Devices, Folders and Variables, each with its own search. Select one or more Variables and confirm.

The Data Explorer variable picker with columns for Devices, Folders and Variables, showing the current value next to each Variable
The variable picker, with the current value shown next to each Variable

In Aggregated mode a second step asks which aggregations to plot. The options are Minimum, Maximum, Average, Sum, Standard Deviation, Sample Count, Kurtosis, First Value and Last Value, and you can pick several at once. Every selected combination of Variable and aggregation becomes its own series on the chart. In Raw Data mode the Variables are added directly, since there is nothing to aggregate.

The aggregation selection step with cards for each aggregation method and Minimum, Maximum and Average selected
Picking aggregations: each selection becomes its own series on the chart

In the list, Aggregated mode groups the series by Variable, and the group menu can add further aggregations later or remove them all. Each row carries the series color, so the list, the chart and the table stay visually matched.

If you know the equipment but not which Device publishes the reading, the Namespace browses the same points as a Location and Asset tree instead of a Device list, and its inspector charts a single point's history in place.

Working with the Chart and Table

The chart zooms with the mouse wheel and pans by dragging, along the time axis only. A slider under the chart scrubs and narrows the visible window, and the toolbox in the corner adds box-select zoom, a reset, an image download and a bar or line view. If a plotted Variable has Alarm configurations, a toggle in the top left overlays the alarm threshold lines on the chart.

The time jump buttons under the chart step the whole range backward or forward by 1 minute, 5 minutes, 10 minutes, 1 hour, 6 hours or 1 day, which makes it quick to walk through an incident. Navigation is limited to the end of the current day.

Each Variable row has an eye button to show or hide its series, and the list header toggles them all. Hovering a row highlights its series on the chart; hovering a column in the data table does the same, in both directions. The table itself lists every timestamp with one column per series, sortable by any column.

The Explorer's state, including the range, bucket, mode and Variables, is encoded in the page URL, so copying the browser URL shares your exact view with a colleague.

Watch Lists and Saved Configurations

A Watch List saves the set of Variables you have assembled so you can reload it next time. The variable panel's header menu saves, renames, opens and closes lists, and while a list is open, changes to it are saved automatically.

A Saved Configuration goes further and captures the whole setup: Variables, time range and mode. Save one from the menu in the top bar, optionally shared with your Organization so colleagues can load the same view.

You can also jump into the Explorer from elsewhere in the platform: Device Variables, Alarms and dashboard widgets offer an Explorer entry that opens the Variable pre-loaded over a chosen period, from the last 15 minutes to the last year.

Exporting Data

The download button in the table header exports the current view with Export CSV. The file contains every timestamp in chronological order with one column per series, using the full-precision values rather than the rounded ones shown on screen. Use it to hand data to a spreadsheet, an external analysis tool, or an archive.

For recurring formatted output, the Report stage generates compliance reports from the same stored data.

Was this page helpful?