Logs formulas

You can combine log metrics over facets or labels into formulas, to get additional insights. For example, compare the activity on pinot to the activity on to the overall count, to determine error percentage.

Here, we start with the side-by-side metric display of aws_logs_call_count and aws_logs_error_count demonstrated in Add query and Separate queries sections.

Add formula

You can combine metrics over facets or labels into formulas, to get additional insights.

  1. To add a formula, click Add Formula button (Add Formula).

    log analytics formula add
  2. The empty formula option appears in interface as line 1 (1), under the query lines.

    log analytics formula start
  3. Type the formula in the text box next to label 1 (1).

    Here, use a formula to determine when the count of log events for profile server exceeds the count of pinot profiler events, and by how much. Simply subtract query query a from query b.

  4. The interface displays graphs for both queries and the new formula.

    log analytics query formula result

Remove a formula

  1. To remove a formula, click Delete (Delete) icon that corresponds to the formula you plan to remove.

  2. The formula is no longer in the interface.