Create dashboard elements
This section explains how to create dashboard elements.
To create new dashboard elements:
- Create a dashboard or open an existing dashboard.
- Click Add chart in the top right corner.
- Choose the dashboard element from the list.
- For charts, select one of the following:
- Click Simple Query Builder to create your chart using a visual query builder.
- Click Advanced Query Language to create your chart using the Axiom Processing Language (APL). Create a chart in the same way you create a chart in the APL query builder of the Query tab.
- Optional: Configure chart options.
- Click Save.
The new element appears in your dashboard. At the bottom, click Save to save your changes to the dashboard.
Change element’s position
To change element’s position on the dashboard, drag the title bar of the chart.
Change element size
To change the size of the element, drag the bottom-right corner.
Create chart using visual query builder
Use the query builder to create or edit queries for the selected dataset:
Query builder
This component is a visual query builder that eases the process of building visualizations and segments of your data.
This guide walks you through the individual sections of the query builder.
Time range
Every query has a start and end time and the time range component allows quick selection of common time ranges as well as the ability to input specific start and end timestamps:
Time range
- Use the Quick Range items to quickly select popular ranges
- Use the Custom Start/End Date inputs to select specific times
- Use the Resolution items to choose between various time bucket resolutions
Against
When a time series visualization is selected, such as count
, the Against menu is enabled and it’s possible to select a historical time to compare the results of your time range too.
For example, to compare the last hour’s average response time to the same time yesterday, select 1 hr
in the time range menu, and then select -1D
from the Against menu:
Time range against menu
The results look like this:
Time range against chart
The dotted line represents results from the base date, and the totals table includes the comparative totals.
When you add field
to the group by
clause, the time range against values are attached to each events
.
Time range against chart
Visualizations
Axiom provides powerful visualizations that display the output of running aggregate functions across your dataset. The Visualization menu allows you to add these visualizations and, where required, input their arguments:
Visualizations menu
You can select a visualization to add it to the query. If a visualization requires an argument (such as the field and/or other parameters), the menu allows you to select eligible fields and input those arguments. Press Enter
to complete the addition:
Visualizations demo
Click Visualization in the query builder to edit it at any time.
Learn about supported visualizations
Filters
Use the filter menu to attach filter clauses to your search.
Axiom supports AND/OR operators at the top-level as well as one level deep. This means you can create filters that would read as status == 200 AND (method == get OR method == head) AND (user-agent contains Mozilla or user-agent contains Webkit)
.
Filters are divided up by the field type they operate on, but some may apply to more than one field type.
Filters demo
List of filters
String Fields
==
!=
exists
not-exists
starts-with
not-starts-with
ends-with
not-ends-with
contains
not-contains
regexp
not-regexp
Number Fields
==
!=
exists
not-exists
>
>=
<
<=
Boolean Fields
==
!=
exists
not-exists
Array Fields
contains
not-contains
exists
not-exists
Special fields
Axiom creates the following two fields automatically for a new dataset:
_time
is the timestamp of the event. If the data you ingest doesn’t have a_time
field, Axiom assigns the time of the data ingest to the events._sysTime
is the time when you ingested the data.
In most cases, you can use _time
and _sysTime
interchangeably. The difference between them can be useful if you experience clock skews on your event-producing systems.
Group by (segmentation)
When visualizing data, it can be useful to segment data into specific groups to more clearly understand how the data behaves.
The Group By component enables you to add one or more fields to group events by:
Group by
Other options
Order
By default, Axiom automatically chooses the best ordering for results. However, you can manually set the desired order through this menu.
Limit
By default, Axiom chooses a reasonable limit for the query that has been passed in. However, you can control that limit manually through this component.