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 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.
For a bar or line chart you always need to provide an aggregate function. You can choose from the following types.
You can use multiple aggregate functions, but they must be comma separated. Example
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
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
CAST(my_property AS INTEGER) >= 120
You can also cast to one of the following:
- 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)
GroupBy and Having
When choosing a
pie chart you will get two more query options. You can provide a
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.
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.