You can create an excel report template and export data to it from Info360 Insight.
Before you configure your report, make sure you have set up the Sensor Data Export you will use.
To create a report
- Create an XLSX or XLSM workbook template for your reporting or analysis requirements.
- In that template, include a sheet called 'Info360'. This is where the data from
Info360 Insight will be included when you export the report. The columns included in that sheet will be:
SENSORID
INTERVAL
SERIES
TIMESTAMP
VALUE
E.g. BCB_Station.DischargePressure.Pressure 1 minute Close 2018-08-16 23:59:00.000 173.100006104 - Go to Data
Reports and select New Report
- Select the Data Export that you want to use in the report.
Note: Make sure that the time range of the data export covers the full time period you will use. For example, if you plan to download the report on a monthly basis for the next year, set the data export time range to the next year. You will then select the report time range (the month) when you download the report.
- Upload your excel report template then click Create Report.
Tip: You can update the template and update it in
Info360 Insight at any time by deleting the existing excel template and uploading the new one. Make sure to always include the 'Info360' tab.
To download a report
- Go to Data Reports and click the download icon
.
- Choose the Time Range to generate the report for or use the Time Offset in Days option to specify a number of days. For example, entering an offset of 7 will generate the report with data from the last 7 days.
Remember that the data export time range must include the dates you are selecting.