...
Expand | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Use the following query in a table widget to create a dynamic table that allows you to specify the source data table, the grouping period, and the grouping key.
The table is linked to three different Select-type inputs populated with the values shown below.
The following capture shows the table after selecting demo.ecommerce.data as source table, 1s as grouping time and statusCode as key column for the grouping. |
Expand | ||||||
---|---|---|---|---|---|---|
| ||||||
Use the following query to feed a column widget to display the count of status codes greater than a specified value and grouped by a period selected from a list of values.
The Select-type input is populated with the values shown below.
The following capture shows the column widget after entering selecting 5m in the free-text select input as grouping period and selecting entering 400 in the select free-text input as filtering value, so that only status codes greater than 400 are shown in each five-minute period. You must select the count field as the Y-axis value and add the statusCode column as a series in the Visual settings of the column widget. |
...