Exploring Data

The Explorers and Worksheets in Observe share a number of useful and intuitive concepts. Details about these concepts are covered here.

Understanding time window selection

Dashboards, Worksheets, and Explorers operate on a time window set by the time picker in the top right. Many of the options in that picker are relative to the present, such as “Past 15 minutes”, “Last week”, or “Since $DATE”. After your initial selection, the start and end times will transition to static points so that the data in the window does not change. For example, a dashboard with a time filter of “Past 15 minutes” on load will set start and end times, and after a few minutes will adjust the time display to show that the observed time is a fifteen minute window in the past.

Understanding Auto-run

In Worksheets and Explorers, normal usage involves changing the query. The newly produced query can be run automatically by checking the Auto-run button. When Auto-run is on, changes made with filtering tools cause the query to be reloaded immediately. When Auto-run is off, filter changes do not take effect until the user clicks Run.

Observe Administrators can control the default behavior of Auto-run.

Understanding Live Mode

Log Explorer and Metrics Explorer offer Live Mode. When incident debugging requires the fastest possible access to data, Live Mode users can typically expect between 30 and 90 seconds of latency from source to screen, depending on data rate and agent configuration.

Change the number of results displayed

By default, an events table shows the first 1000 rows of results. You can change the number displayed in the Limit tab of the Table Controls menu.

Hide, show, or reorder columns

Also use Table Controls to hide, show, or change the order of columns displayed. In the Columns tab, click to show or hide, and drag to reorder.

Video instructions

Data Table Settings

For each table in a Worksheet, Log Events, Metrics, and Datasets, you can adjust the table to suit your viewing needs. The following settings can be changed when you click the Table settings icon:

  • Columns: hide or unhide the columns in this data

  • View: change how many lines are displayed per row of data

  • Limit: change the maximum number of rows displayed

Note

Hiding columns with the Table settings does not affect the data. Hidden columns are still queried and processed, and will still be delivered by an export. To remove unwanted columns, use the drop_col or pick_col OPAL commands.