Page Comparison

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.

query(
from demo.ecommerce.data
group every $*Select0.value 
by statusCode where statusCode > $Input0.value 
select count() as count)

The Select-type input is populated with the values shown below.

The following capture shows the column widget after entering 5m in the free-text input as grouping period and selecting 400 in the select 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.