Dashboards

Once you've started collecting structured log data, you'll be amazed how much interesting and useful information you can find in it. Dashboards are great for keeping track of important indicators of application and business behavior.

The Add to Dashboard Button

The quickest way to add a chart to a dashboard is directly from the events screen.

Count Events Matching a Filter

When viewing a subset of events, say, those matching a set of signals or a filter expression, a simple count of event occurrences can be created using the Add to Dashboard button:

After selecting one of the existing dashboards, or New Dashboard to create a new one, enter a name for the chart and press Ok.

Notice that the dashboard itself needs to be saved: pressing the Save button in the top left of the grey dashboard area will do this.

Add a SQL Query to the Dashboard

The Add to Dashboard button can also be used when viewing an SQL query to add that query onto the dashboard:

If the query is not already grouped by time(), Seq will transform the query so that the dashboard slices results into individual time intervals.

Creating and Editing Charts

Charts can present data in a variety of styles. This section explains each of the tabs shown when a chart is added via the events screen, with the + button on a dashboard, or by clicking the down-arrow in the top right-hand corner of the chart title:

Charts will initially show a simple count query, over all events in the stream.

The Signal Tab

To narrow down the events that will contribute to the chart, select one or more signals from the Signal tab:

When multiple signals are selected, only events that match all of the signals will contribute to the chart.

To remove a signal, click the x beside the signal name.

The Query Tab

The Query tab is used to choose one or more measurements to present on the chart.

• select - Use this section to specify the measurements that are shown on the chart. The first input box accepts an aggregation expression like count, sum, mean and percentile, while the second box sets the label that will identify the series when more than one line is shown. Press + to add multiple measurements; delete the text in the first input box to remove a measurement.
• where - This input accepts an SQL predicate to further restrict which data contributes to the chart. Strict SQL syntax is required (single-quoted strings, SQL-style operators).
• group by - Multiple series can be displayed for a single measurement by grouping the data, e.g. using a property name like Environment or MachineName. Use + to add more than one grouping, and clear the text from a grouping in order to remove it.

The SQL Tab

Because Seq charts are driven by Seq's underlying SQL engine, the query being used to generate a chart can be inspected and, if desired, copied for use as the basis of an interactive diagnostic session. The query is shown in the SQL tab:

The Style Tab

Charts can be shown in a variety of color palettes and styles.

Line

The default Line chart style is for continuous data, i.e. where there are no gaps in the measurement from one time slice to another.

Fill to zero (Y axis) shades the area under the line. Show point markers can be used to show or hide the "dots" marking each data point.

Point

Point charts can be useful for displaying sparse data sets, for example, latencies from an infrequently-called API, where there are gaps in the measurement across time slices:

Bar

The Bar chart type is ideal for histograms showing a count or sum value.

The total of all bars can be shown as an overlay; this is great for error or transaction counts.

Alerts

Alerts are used to send notifications based on the values from a chart. See the alerts documentation for a description of this feature.

Actions

Finally, the Actions tab permits a chart to be moved around the dashboard, cloned, or removed.

Dashboard Features

Dashboards are so useful (and beautiful!) that you'll create quite a few, and want to share them with the rest of your team in different ways.

Creating and Switching Between Dashboards

On the left-hand side of the dashboards screen, a list of available dashboards is shown. New dashboards can be created using the + button beside the "Dashboards" heading.

Dashboard Tools

The top left-hand corner of a dashboard displays the title, some toolbar buttons, and a drop-down menu for managing the dashboard.

• To rename the dashboard, click in the title area: the title can be edited in-place.
• Use the full-screen button to display the dashboard alone without the title bar or dashboards list. This is great for dashboards on overhead displays.
• The filter button configures a whole-dashboard filter; this can be used in conjunction with Switch to Clone from the drop-down menu to create several variations of the same dashboard layout.
• All changes made to the charts and alerts on a dashboard need to be saved using the save button; changes can be discarded with the revert button.
• Shared dashboards are visible to the whole team; only admin users can edit shared dashboards, while everyone can create their own per-user dashboards.
• Delete removes the dashboard.