Logs Formulas
Logs formulas allow you to combine multiple log metrics across facets or labels to calculate derived values and gain additional insights into your log data. For example, you can use formulas to compare activity metrics between specific services or calculate error percentages by dividing error counts by total counts. Formulas build on the side-by-side metric display, enabling you to perform mathematical operations on the metrics you create.
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.
-
To add a formula, click
(Add Formula).
-
The empty formula option appears in interface as line
(1), under the query lines.
-
Type the formula in the text box next to label
(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
from
.
-
The interface displays graphs for both queries and the new formula.