Metrics Explorer Report

You can use the Metrics Explorer report to gather and report on an aggregation of metrics across multiple DataSources. The enhanced flexibility enables you to more effectively report on the data most relevant to identifying root causes, prioritizing alerts, and reducing time to resolution.

The Metrics Explorer report supports LogicMonitor Query Language (LMQL) and OTLP metric queries. When configuring the report, select the query type based on the metrics you want to report on.

For LogicMonitor metrics, you can use LMQL to build structured queries that combine multiple datapoints in a single query, filter data using properties, and perform advanced aggregations directly in your queries.

When using LMQL, you can build your query with the Query Builder or enter a raw query. The Query Builder provides a structured method for creating queries by selecting base properties, such as a resource or instance, applicable values, additional property filters, and query functions. You can also add additional property filters and values, and the query functions to perform the operations on your data.

Alternatively, you can create your query as a raw query directly in the report configuration settings.

For OTLP metrics, you can use PromQL to query metrics ingested through OpenTelemetry. OTLP queries use the Raw Query option, enabling you to enter a PromQL query directly in the report configuration. This enables you to use PromQL expressions, functions, filtering, and aggregation to select and analyze the OTLP metric data you want included in the report.

Requirements for Configuring a Metrics Explorer Report

To use an OTLP metric query, you need to configure an OpenTelemetry Collector to send metrics to LogicMonitor.

Configuring a Metrics Explorer Report

1. In LogicMonitor, navigate to Reports.
2. Select > Add Report > select Add for Metrics Explorer report.
   
3. In the Name field, enter a name for the report.
   Report names cannot include the operators and comparison functions used in LogicMonitor’s datapoint expression syntax.
4. (Optional) In the Description field, enter a description for the report.
   For example, you can enter a description of the specific purpose of the report.
5. From Report Group, select the report group where your report is stored.
   Matching groups display as you type, and you can select the group from the list.
6. From Format, select the type of format (for example, HTML, PDF, or CSV) for the output of the report.
   
7. In the Metric Source section, select the type of query you want to create from the following:
   • To build a query for LogicMonitor metrics, select Standard.
     You can choose whether to override the query time range by toggling the Override query builder time range switch. This option enables you to configure a separate time range from the query builder time range using the settings provided.
     
   • To build a query for OTLP metrics, select OTLP Metrics/PromQL.
8. Create the query for the data you want to display in the report by doing one of the following
   • To create the query using the built-in query builder, select Query Builder and do the following depending on the metric source you want to use:
     • If you are building a query for LogicMonitor metrics, do the following:
       1. In the Filter by field, use the base properties available to build your query.
          LogicMonitor provides Resource, DataSource, Instance, and Datapoint as base properties to build your query.
          
       2. Enter additional properties for the query by selecting to add a property filter.
          A list of properties is displayed.
       3. Type a property in the Search records field, or select a property from the list of properties displayed.
          LogicMonitor displays applicable properties as you type.
          
       4. Type a value for the property in the Search records field, or select a value for the property from the list of values displayed for the property.
          LogicMonitor displays applicable values as you type.
          
       5. In the Functions field, select the functions you want to use to perform specific operations or calculations on data.
          For example, selecting “Average” from Aggregate returns the average value of all the matching resources for the selected datapoint.
       6. To return multiple data samples over a period of time for each matching metric, do any of the following:
          • To define how far back in time to query for data, add a time for Time range.

• To define how frequently datapoints are samples in that range, add a time for Step.

• To shift the evaluation time backwards by a specified duration, add a time for Offset.

7. Select Run.

• If you are building a query for OTLP metrics, do the following:
  1. In the Search metric field, enter a metric to base your query on.

     

  2. In the Filter by settings, configure the values based on your metric. For example, if you are building a query around the system_cpu_time metric, LogicMonitor populates the applicable values, such as “cpu”.
  3. Configure and add functions as needed.
  4. Select Run.

• To create the query manually, select Raw Query and enter the string of queries you want to use in the Metrics Explorer Query field.

  

If you are building a query for OTLP metrics, enter a query in the PromQL/OTel Query field.

8. Select Run.
   The Advance Metrics query results display as a table.
   
9. To configure the order the columns display in and whether or not to hide certain columns, do the following:
   1. Select Show Table settings.
   2. Configure the order as needed, including hiding or showing certain columns.
      
   3. To add custom columns for the resource and instance properties, enter a value in the search field.
      LogicMonitor attempts to match values as you type.
      Any value you add in the Column Settings display as a column header in your report.
10. In Report Schedule settings, do the following to configure the report to generate on a schedule:
    1. Toggle Generate this report on a schedule.
    2. From Frequency, select how frequent you want the report to generate, and then configure when you want the report to generate.
       For example, if you configure the report to generate daily, you can choose the time to generate the report each day. If you configure the report to generate weekly, you can choose the day of the week and time to generate the report for the selected date. If you configure the report to generate monthly, you can configure the day of the month and time to generate the report.
       Each frequency option provides you a setting for selecting the time zone.
    3. In Recipients Email, enter the name of the user you want to receive the generated report. You can also add recipient groups.
       You can enter as many users as needed.
       LogicMonitor attempts to match values as you type.
       The recipients you add to the report are emailed a generated report based on the format you configured and the email associated with the username.
       
11. To save the report, do one of the following:
    • Select Save.
      The report saves to the Report Group you selected.
      If you configured the report to generate on a schedule, the report generates and sends to recipients based on the frequency you configured.
    • Select Save and Run.
      A dialog displays confirming the report you want to run. Select Run Report to run the report.
      The report saves to the Report Group you selected and generates a report based on the format you configured.
      If you configured the report to generate on a schedule, the report generates and sends to recipients based on the frequency you configured.