Ubidots allows system integrators, OEM's, and industrial IoT providers to offer their own IoT portal to end-customers. Without the need for an internal software team, administrators are able to offer customized access portals to their end-customers or employees. Along the way when you need your data the most, Ubidots reports are available and able to be scheduled for regular reception. In some cases, preventing product losses with a simple but regular update via your email inbox.

Requirements

  • An Ubidots account with a Professional license or greater

Table of Content

  1. Creating reports

  2. Adding content to reports

  3. Managing and Editing a Report

  4. Notification Center

1. Creating Ubidots Reports

Follow the below steps to create a scheduled report.

  1. Go to the Reports module from the DataAnalytics tab.

  2. Click on the top-left ‘+’ add button to create a new report.

  3. Give it a name and description.

  4. Click on the “Scheduling” tab to adjust the scheduling settings.

  5. Toggle the “send scheduled report” to enable the scheduling settings.

  6. Customize the settings as needed:
    Data Range: Time frame of the data you wish to display. If ‘Set by report’, the date range will take the one set from the preview.
    Timezone: In which timezone you desire your report to be generated.
    Send report every: How regular you wish the report to be sent.
    Format: In which format between PDF and XLSX the report should be generated.
    Message body: It is important to include the key {{url}} in the message to receive the link to download the report.
    Recipients: A comma-separated list of the email addresses to which the report will be sent.

2. Adding content to reports

Once the report is created, a preview should be displayed. At this point is empty, so it’s time to add sections and data to your report. Click on the ‘+’ button just below the Global time and aggregation options to add new sections. Available options are:

a. Header: Assign headers to your reports to differentiate the tables and charts below them. You can set the font family, size, alignment, and color of the header to your desired preference. Also, if you want it to be rendered on a new page.

b. Body: Add a single text that describes different sections of the report or even complete paragraphs. You can set the font family, size, alignment, and color of the text to your desired preference.

**TIP**: You may recreate date headers within the body by using the keys {{now}} , {{start}} and {{end}}, as shown below:

The result would look something like this:

c. Line chart: Generate a graph with devices and variables data. Follow the below steps to add line charts to your report.

  1. Click on ‘+’ to add variables.

  2. Search for the device and variable(s) you want to add. Click on “Select” to confirm.

  3. The variables will be displayed in row format. Click on each to customize its chart type, aggregation method and sample period.
    Chart type: How the data will be represented. The available options are line (default), bars, scatter or step.
    Aggregation method: Set how the data should be computed based on the variable's data over a selectable sample period. Available options are set by report (default), raw, maximum, minimum, count, average or sum. If 'set by report', the aggregation method from the preview will be used to build the report.
    ─ Sample period: Choose the time span to compute the data aggregation. If ‘set by report’, the sample period from the preview will be used to build the report. This option is not available if you selected ‘raw’ as the aggregation method.

  4. (Optional) you can delete, copy or hide a variable by clicking on the options in front of the variable name.

  5. Click on “Save” to add the line chart to the report. You should be able to see it from the preview.

d. Widget snapshot: Add existing widgets from your dashboards. Follow the below steps to add widgets to your report.

  1. Click on the ‘+’ to add a widget.

  2. Search for the dashboard and click on the widget you want to add. Click on “Select” to confirm.

  3. Click on “Save” to add the widget to the report. You should be able to see it from the preview.

**IMPORTANT NOTE**: Both the preview and report take a snapshot of the widget using its default device (if it comes from a dynamic dashboard) and default time range. This means that widgets do not respond to the report’s settings.

e. Table: Generates a sheet with variables data. Follow the below steps to add tables to your report.

  1. Click on ‘+’ to add variables.

  2. Search for the device and variable(s) you want to add. Click on “Select” to confirm.

  3. The variables will be displayed in row format. Click on each to customize its aggregation method and sample period.
    Aggregation method: Set how the data should be computed based on the variable's data over a selectable sample period. Available options are set by report (default), raw, maximum, minimum, count, average or sum. If 'set by report', the aggregation method from the preview will be used to build the report.
    Sample period: Choose the time span to compute the data aggregation. If ‘set by report’, the sample period from the preview will be used to build the report. This option is not available if you selected ‘raw’ as the aggregation method.

  4. (Optional) you can delete, copy or hide a variable by clicking on the options in front of the variable name.

  5. Click on “Save” to add the line chart to the report. You should be able to see it from the preview.

3. Managing and editing reports

PREVIEW AND REPORT OPTIONS

1. The list of existing reports allows you to move to other report's preview. To deploy the list, click on the name of the current report. Then, select which one you want to display.

2. Global time and aggregation options allow you to select a global sample period and aggregation method that governs all sections with the “Set by report” option configured.

3. Report actions: From here, you can edit, save or select advanced options of the report.

**IMPORTANT NOTE**: It’s recommended to save the report after every change. If not, unsaved changes will not be stored or taken into account when generating the report.

a. Advanced options

- Save as new: In short, it allows you to duplicate the report.

- Show logs of the report already sent and their status.

- Delete the report.

- Build and send manually the report.

- Name: Desired name for a report.

- Timezone: In which timezone do you desire your report to be generated.

- Data Time: Time frame of the data you wish to display.

SECTIONS OPTIONS

Hover the mouse over a section to display its options.

  1. Move the section 1 position down.

  2. Add a new section above.

  3. Move the section 1 position up.

  4. Edit the section.

  5. Delete the section.

4. Notification Center


NOTE #1: You can keep track of the reports manually generated or in-progress by clicking on the inbox icon next to the left of My Profile icon in the Ubidots Navbar.

image.png
image.png

Starting with Ubidots

This feature is available under the Professional license and above. Please contact our Sales Team if you have any questions about Ubidots licenses and prices for your IoT or cloud solution.

Did this answer your question?