Dashboard & charts

Add charts to your dashboard to monitor your applications closely!

Initially you have no dashboards. To create a new dashboard click on the Add new dashboard button.

Dashboards are visible to all team members.


Main chart settings

To add a chart to your dashboard click on the plus icon at the top of the Dashboard page. You will be presented with a popup dialog.

Enter a name and select the type of chart you want to display. Once you select a chart type you will then more options will follow.

First make sure to set the desired period and Period interval values. You can also set the Refresh rate. This will auto update your chart every X time.

These are the basic settings you must provide for every chart. Based on yourchart type certain filter options will appear.

Bar & line chart

When you select a Bar chart or Line chart type, then you will have two filter options.

You can specify a select and a where option. There is no group by or having clause because this is automatically done by the system based for these types of charts.

Select filter

For a bar or line chart you always need to provide an aggregate function. You can choose from the following types.

  • AVG()
  • COUNT()
  • MAX()
  • MIN()
  • SUM()

You can use multiple aggregate functions, but they must be comma separated. Example

count(LogLevel), count(RequestId)

You can also provide an alias for each aggregate function. They will be used as labels on you chart.

count(LogLevel) AS Level, count(RequestId) AS ReqId
Where filter

All chart types have a where filter. You filter logs by using SQL-like queries. For example:

(LogLevel = 'Warning' OR LogLevel = 'Critical') AND Environment = 'Production'

Don't add a WHERE in front of your query! This is automatically added.

By default all property values are stored as string. If you have a property that is always a numeric value and you want to filter where the number is equal to, or greater than a specific value then you can CAST the property to an INTEGER value.

CAST(my_property AS INTEGER) >= 120

You can also cast to one of the following:

  • CHAR
  • DATE
  • DATETIME
  • DECIMAL[(M[,D])] Where M is the total number of digits (the precision) and D is the number of digits after the decimal point (the scale)
  • DOUBLE
  • FLOAT

Pie chart

GroupBy and Having

When choosing a pie chart you will get two more query options. You can provide a GroupBy and Having clause to your query.

When you use a GroupBy function then you must have an aggregate function in your select statement.

Please note that when choosing a Pie chart you must provide one, and only one aggregate function in your select statement.

Table chart

Limit

When choosing a Table chart then you will get one more option than you'll get with a Pie chart, and that is the abillity to limit your results.

Simply specify a number and your results will be limited to that amount.

With a Table chart you can use all query filter options.