Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.

Create reports from MetricBase time-series data

Log in to subscribe to topics and get notified when content changes.

Create reports from MetricBase time-series data

Use the MetricBase application to create time-series reports from MetricBase data.

Before you begin

You must have the MetricBase product. To get it, see Request the MetricBase product. For more information about MetricBase, see MetricBase.

Procedure

  1. Navigate to Reports > Create New.
  2. On the Data tab, enter a report name that reflects the information in the report.
  3. In the Source type list, select MetricBase.
    Note:
    • The MetricBase menu option is available only if you have MetricBase installed on your instance.
    • The default maximum number of series per data set is 20. You can increase the maximum value up to 100 by configuring the glide.report.metric_max_series system property. However, due to the 10,000 data points limit, increasing the number of series in a data set results in a smaller number of data points per series.
    • The total number of data points that can be displayed per series is 10,000 / (actual number of series in dataset * number of data sets). For example:
      • 1 dataset used with 20 series: 10K / (20*1) = 500
      • 2 datasets used with 20 series: 10K / (20*2) = 250
      • 1 dataset used with 100 series: 10K / (100*1) = 100
    • If the actual number of data points in a series exceeds the limit, the data is resampled.
    Create a report with MetricBase source type selected
  4. Choose an existing MetricBase table.
  5. Click Next.
  6. On the Type tab, select the type of report to create and click Next.
    Only time series reports are available. For information on specific reports types, see Creating reports. To view the updated report, click Run.
  7. On the Configure tab, fill in the following fields and click Next.
    Table 1. Configure tab form
    Field Description
    Group by Report data that you group by any of the applicable fields in the Metrics table.
    Metric Metrics 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 Data is altered.
    • 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 Period of time that the report covers. 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 Option that you select 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 that is used for text searches across all fields. Its 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.
    See the Style options section of the report that you are creating for more information.
  10. Click Save.

Result

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

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.
  • 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.
Feedback