Versions Compared

Old Version 11

changes.mady.by.user Borja Moro Moreno

Saved on

compared with

New Version 12

changes.mady.by.user Borja Moro Moreno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

About IDs

All widget and input ID values are assigned automatically when created and can be read in the Data settings of the widget or input element.

Expressions and operators

Depending on the data to be entered in the input and their function inside the widget query, you can use the following types of expressions and operators:

...

Expand
titleExample 1

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.

Code Block
query(
 from $*Select0.value
 group every $*Select1.value 
 by $*Select2.value select count() as count)

The table is linked to three different Select-type inputs populated with the values shown below.

Select0

Select1

Select2

["demo.ecommerce.data", "web.all.access"]

["2m", "5m", "10m", "1s"]

["statusCode", "method"]

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.

Image Modified
Expand
titleExample 2

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.

Code Block
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.

Select0

Input0

["5m", "10m", "15m"]

Free text

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.

Image Modified

Related articles:

...