TIME LINE#

The Time Line widget displays time intervals on a horizontal timeline. Use it to show how long Jobs, process stages, or user actions in a form take.

For example, Time Line can show when each Job started and finished, how long each stage of a request took, or how actions were distributed over time.

Start configuring the widget#

To configure the widget, click the edit icon .

The "Widget settings" dialog opens:

Fill in the fields needed to configure the widget.

General fields#

Additional fields available only in Builder mode#

Joining tables#

Join tables to retrieve data from several related tables and produce a more complete result.

Use the following operators to compare columns in two tables before joining them:

To join only two tables, fill in these fields:

1. Select the first "Column" from the list;
2. Select the "Operator" from the list;
3. Select "Column 2" from the list.

For example:

To join more than two tables, click , then fill in the required fields.

To remove a table join, click .

Filters#

Filters define conditions for the selected data using comparison and logical operators.

To set one condition, fill in these fields:

1. Select "Column" from the list;
2. Select "Operator" from the list;
3. Enter "Value" using the keyboard.

For example:

To combine several conditions, for example, ((robots.is_deleted = 0) AND (robots.id > 13)), use logical operators. Click to change it to OR or to change it to AND. Then click and fill in the required fields:

To set a complex Filter condition with several sets of parentheses, click , then fill in the required fields.

To remove a condition, click .

Widget series#

Widget series select the database columns returned in the query results.

To configure the Widget series, fill in these fields:

1. Select "Column" from the list;
2. Select "Operator" from the list;
3. Enter "Series name" using the keyboard.

For example:

To display additional data in the legend, click .

Group by#

This field groups rows with the same values in one or more columns so aggregate operations can be applied. Select a column from the list.

Sorting#

These fields determine the order of rows in the result. Enter "ASC" in "Sort order" for ascending order or "DESC" for descending order, then select a "Column" from the list.

Row count#

Enter a value or use the counter . This field limits the number of records returned by the query for the dashboard.

Testing#

To check that the query is configured correctly, click . A table appears with the data used to build the Line Chart dashboard.

Click "OK" to display the dashboard on the panel.

Click "Cancel" to clear all entered data.

Data format for Time Line#

For the widget to render correctly, the query must return three columns:

If FinishTime is empty, the widget displays a short, 60-second interval starting at StartTime.

Builder mode (example)#

This example shows the latest Jobs with a start time. Each Job appears as a separate interval from start to finish.

Fill in these fields:

Tables *

jobs

process_versions

processes

Joining tables

Filters

Widget series

Sort by

Row count

10

Advanced mode (example)#

This example shows the latest Jobs with a start time. Each Job appears as a separate interval from start to finish.

Enter the following query in the SQL field:

SELECT
    COALESCE(processes.name, CONCAT('Работа ', jobs.id)) AS name,
    COALESCE(jobs.started, jobs.created) AS StartTime,
    DATE_ADD(COALESCE(jobs.started, jobs.created), INTERVAL 2 HOUR) AS FinishTime
FROM jobs
LEFT JOIN process_versions ON jobs.process_version_id = process_versions.id
LEFT JOIN processes ON process_versions.process_id = processes.id
WHERE
    jobs.is_deleted = 0
    AND COALESCE(jobs.started, jobs.created) IS NOT NULL
ORDER BY COALESCE(jobs.started, jobs.created) DESC
LIMIT 10

Click "OK" to display the widget on the panel.