Business event analysis in Dynatrace

powered by Grail

Once stored in Grail, you can query your business event data interactively and analyze it using DQL. DQL is the starting point, whether you are in the Event explorer or in the API. Query results can be used interactively or pinned to a dashboard as charts, tiles, or tables.

Query and analyze your data

1. In the Dynatrace menu, go to Business Analytics > Explore business events.
2. Build and run your query.
   Your queries can be used to create metrics and charts for dashboards. You can also run queries from an API to use the data externally.

For the examples on this page, the event type com.easytrade.sell-assets includes the data fields accountid, amount, instrumentid, and price.

Metrics

You can create metrics on an ongoing basis from any measure or numeric data collected as business events, using DQL. Results can be a table or a single value.

Average trading dollar volume - single value

The below metric is a single numerical value.

dqlcopydownload
fetch bizevents, from:now()-24h, to:now()
| filter event.type == "com.easytrade.sell-assets"
| summarize dollar_volume = avg(amount*price)

Search results

Average trading dollar volume in time intervals - table

You can create tabular metrics based on an average trading dollar volume in the last 30 days in 24-hour intervals:

dqlcopydownload
fetch bizevents, from:now()-30d, to:now()
| filter event.type == "com.easytrade.sell-assets"
| summarize average_dollar_volume = avg(amount*price), by:{selltime = bin(timestamp, 24h)}
| sort average_dollar_volume, direction:"ascending"

Results table

Charts

There are two types of charts that can be used to visualize your results: a bar chart and a line chart. Only tabular data can be displayed as charts.

Bar

Bar charts are available on the condition that the query contains two mandatory components: a function (for example, summarize count()) and a parameter.

The following is a bar chart of the results from the above query.

Lineinto

The following is a line chart of the results from the above query.

Dashboards

You can pin your table and single-value results to a dashboard:

1. In the Search results tab, select Actions on the right side of the screen.
2. Select Pin to dashboard.
3. Choose the dashboard where you would like to pin your tile or create a new dashboard.
4. Add a title to your tile and select Pin.

Single-value dashboard tile

The following is a single-value dashboard tile for average trading dollar volume.

Table dashboard tile

The following is a table dashboard tile for trading dollar volume in intervals.