TrendHub has different options to export data, which can be grouped into 2 categories:
- Exports of TrendHub Views
- Exports of search results
Exports of TrendHub Views
All export options related to TrendHub Views can be found in the actions list of your view bar.
Clicking the export button reveals a side panel where you can choose one of the following possibilities:
- Chart visual: Export the focus chart graph including all visible tags and/or attributes.
- Chart data: Export interpolated index data from the focus chart for all visible tags and or attributes.
- Statistics data: Export the statistics data of the base layer for all active tags and or attributes (hidden ones included).
- Compare layer data: Export the compare layers data of all active tags and/or attributes (hidden ones included).
Chart Visual (PNG) Export
The focus chart image export contains any visible detail of the focus chart, going from any visualization mode to even a context item or a data scooter. Settings are also included in the visual chart export.
The screenshot below shows an example of a visual chart export. Details of the tags and attributes are shown below the chart itself. They include:
- Color of tags or attributes
- Name of the tag or attribute
- The parent's name of an attribute (not applicable for tags)
- Description of tag or attribute (if available)
- The shift of the tag or attribute (if applied)
- Units of measurement (if available)
Also included in the export is information about the layers.
- Line style of the layers
- Name of the layer (default value 'Layer')
- Start and end date and time of the layers
Note: Chart visual export will download automatically once ready.
Chart Data (XLSX) Export
The focus chart data export contains the interpolated indexed data of the visible tags and attributes for the current period of the focus chart and all the active layers (one layer per Excel sheet).
The chart data export has some extra settings that can be adjusted / applied before exporting your data.
Timezone, this setting lets you choose the desired time zone. This setting is also saved for your user which means that in the next session, it is automatically set to the last used timezone. This is useful when sharing exported files with colleagues in different areas. This setting is also saved for your user which means that in the next session, it is automatically set to the last used timezone.
Chart data resolution, this setting lets you adjust the resolution of points to be included in the Excel file. The minimum resolution however is set to the indexing resolution which depends on your setup (1 minute by default).
Note: The resolution is limited to the limit of Excel where up to one million rows are allowed.
Filter, when having periods filtered out, you can exclude these periods in the export file. Learn more about filters in this document. (Link to filters document).
Tip: Retrigger the chart data resolution option after checking the exclude filter option. Since less data points will be exported, the chart data resolution can potentially be increased.
In the image of the export file below, you can see one column shows the date and time followed by all visible tags and/or attributes. The last column "Included" in the file indicates if the period was filtered (0) or not (1).
Each sheet of the export file shows additional layers (if present).
Note: Chart data export can be downloaded in the notification center once created. The download stays available for 7 days before it 'expires'.
Statistics data (XLSX) Export
The statistics table data export exports all descriptive statistics of the base layer. This export only has one setting that can be adjusted.
Timezone, this setting lets you choose the desired time zone. This setting is also saved for your user which means that in the next session, it is automatically set to the last used time zone.
In the export file below, the following information is shown:
- Start and end date and time of the focus chart in the selected time zone.
- Start and end date and time of the focus chart in UTC format.
- All information about the tags and attributes is shown, including:
- Parent name (only applicable for attributes)
- Attribute name (only applicable for attributes)
- Tag name
- Description (if available)
- Units of measurement (if available)
- The time shift of the tag or attribute (if applied)
- All descriptive statistics.
Note: Statistics table export will download automatically once ready.
Compare layer Data (XLSX) Export
The compare layer table data export looks similar to the statistics table export. Again, all key parameters are present in the export but now one per sheet in the Excel file. In this export only the timezone setting can be adjusted.
Timezone, this setting lets you choose the desired time zone. This setting is also saved for your user which means that in the next session, it is automatically set to the last used time zone.
In the export file below, the following information is shown:
- The tag and/or attribute details on the left, including:
- Parent name (only applicable for attributes)
- Attribute name (only applicable for attributes)
- Tag name
- Description (if available)
- Units of measurement (if available)
- The time shift of the tag or attribute (if applied)
- Layers details on the right which contain the following:
- Layer name (and mentioning of base layer)
- Start and end date and time of the layer in the selected time zone
- Start and end date and time of the layer in UTC format
- Value of the current statistics
Note: Compare layer table export will download automatically once ready.
Search results
You can also export search results into an Excel file. Please read the this document to learn more about performing searches in TrendHub.
As soon as a search is executed, the search results, with all available calculations, can be exported. To export search results, simply click the three-dot options button in the results header, followed by the "Export" option.
You can now select the results you wish to export and select the desired timezone before the export is started.
The exported Excel file consists of 2 tabs:
- A first, summary tab containing the details of the search conditions
- A second tab containing the details of the search results
On the first tab you will see the following details about the search:
- Name of the search (if available; this only applies for saved searches)
- Description of the search (if available; this only applies for saved searches)
- Search type
- Settings of the search including
- Queried tags
- Queried time period (similarity search)
- Minimum score (similarity search)
- Weights and period of weights (similarity search)
- Searched period (Context period)
- Export details like timezone and export date
On the second tab of the export file, you can find the following information of the search results:
- Start and end dates in the first two columns.
- The duration of the search result.
- Search specific parameter (E.g., score for similarity search results).
- 1 additional column per available calculations.
Note: Search export can be downloaded in the notification center once created. The download also stays available for 7 days before it 'expires'.