Create time series reports from MetricBase data

In addition to creating time series reports from tables and data sources maintained on your instance, and imported data, you can also create time series reports from MetricBase data in your instance.

Before you begin

You must have the MetricBase product. For more information, see Request the MetricBase product.

Procedure

  1. Navigate to Reports > Create New.
  2. On the Data tab, give the report a name that reflects the information being grouped.
  3. In the Source type list, select MetricBase.
    Note: The MetricBase menu option is only available if you have MetricBase in your instance.
    Create a report with MetricBase source type selected
  4. Choose an existing MetricBase report source.
  5. Click Next.
  6. On the Type tab, select the type of report you want to create and click Next.
    Only Time Series reports are available. Choose from Area, Spline, Line, and Step Line reports. For information on specific reports types, see Report Designer – Report types and creation details.

    A preliminary version of the report is displayed. To view the updated report at any time, click Run.

  7. On the Configure tab, fill in the following fields and click Next.
    Table 1. Configure tab
    Field Description
    Group by Group report data by any of the applicable fields in the Metrics table.
    Metric Metrics are determined in your MetricBase database. Click the plus icon (+) to add multiple metrics. For each metric you can set one or more transforms. Click the minus icon (-) to remove a metric.
    Transform
    • Select no transforms to show the raw data in your report.
    • Select one transform.
    • Select multiple transforms to create a transform chain. A transform chain applies a new transform to the results of the previous transform.
    For more information, see MetricBase transforms.
    Time range Set a period of time for the report to cover. Relative values are a number of minutes, hours, days, months, or years from the current time. Absolute ranges enable you to specify the start time and end time of the report.
    Display data table Check this box to show report data in a grid beneath the report. The table appears on dashboards where the report is added.

    All reports that use charts, including reports that are used on dashboards, show the table of report data when the glide.ui.section508 system property is set to true. The glide.ui.section508 property overrides the Display data table field.

  8. (Optional) To limit the information displayed in the report, click the filter icon (filter icon) and select conditions to filter the report data.
    For more details on how conditions are constructed, see Condition builder.
    Note: Keywords is a special field used for text searches across all fields. It’s use in a filter or condition, in combination with other conditions, may return inconsistent results.
  9. On the Style tab, fill in the fields as appropriate to configure the appearance of the report.
  10. Click Save.
    The report is generated.

Result

The report is created from the MetricBase source. If the report visualization is truncated, a message displays

What to do next

  • Click the Report info icon (Report info icon) and add a description of the report.
  • Click the sharing icon (Sharing icon) to open the Sharing menu. On this menu, you can add the report to a dashboard, export the report to PDF, publish the report to the web, and set visibility and schedules. For more information, see Share a report – Report Designer.
  • Click the sharing icon (Sharing icon) to open the Sharing menu. On this menu, you can share the report with users and groups, add the report to a dashboard, and publish the report to the web. See Share a report – Report Designer for more information.
  • Click the sharing icon (Sharing icon) to open the Sharing menu. On this menu, you can add the report to a dashboard, export the report to PDF, publish the report to the web, and set visibility and schedules. For more information, see Share a report – Report Builder.
  • Click the sharing icon (Sharing icon) to open the Sharing menu. On this menu, you can share the report with users and groups, add the report to a dashboard, and publish the report to the web. See Share a report – Report Builder for more information.