1. Using Oracle Log Analytics
  2. Use Oracle Log Analytics
  3. Visualize Data Using Charts and Controls
  4. Line Charts Visualization

Line Charts Visualization

Oracle Log Analytics provides a line chart visualization that lets you group by a numeric field, then graph the trend of values over time. Only numeric fields or aggregate output (sum as sum, average if the fields or output can be broken up by time) can be selected for the y-axis.
For example, to view the count of all Apache log entries, which are grouped by log source, over a period in time (say the last 7 days):
  1. In Oracle Log Analytics, set the time control on the top right corner to Last Week.
  2. In the Pinned section of the Fields panel, click Log Source, select all the Apache log sources, and click Apply.
  3. In the Visualize panel, select Line (open line chart) from the visualization options.

    • You can select any time stamp field along x-axis for analysis.

    • You can select multiple fields to display on the y-axis by dragging them to the Group By region. Each field is shown with a different marker shape on the line chart.

    In case of multiple data points at a specific time in a line series, you can select the Hide Lines check box to view the data points by hiding the lines.

The count of Apache log entries grouped by Log Source is displayed.
Description of line1.png follows
Description of the illustration line1.png

Similarly, to view a graph displaying the average content size of the Apache log records over time, grouped by log source, from the Other section of the Fields panel, drag and drop the Content Size field to the Y-axis section in the Visualize panel. Ensure that you’ve selected the Average function from the Y-axis list.
Description of line2.png follows
Description of the illustration line2.png

You can select different statistical operations that you can perform on the selected field.


Description of line3.png follows
Description of the illustration line3.png

Note:

Some fields may not support all operations. For example, numeric operations, such as Average, Min, Max, Median, and so on won’t work on fields that are of data type String.