Skip to content

Create trends insight

UI · interface

Create a new insight from the Trends section.


The following are the step's expected inputs and outputs and their specific types.

create_trends_insight({"param": value})

where the object {"param": value} is optional in most cases and if present may contain any of the parameters described in the corresponding section below.


bucketSizeCount: number

Number of time units that sets the size of the bucket.

bucketsSizeInterval: string

Time unit to specify the bucket size.


categoricalColumn: string | null

Categories are created from this column.

dateColumn: string

Column that contain the date. This column is used to set the buckets of the chart.

quantitativeColumn: string

Column used to build the trends chart values.

range: null | array[number | string]

A selection of values in range can be made. Either null or a valid selection range value.

relative: boolean

Sets the visualization type to absolute or relative.

segments: array[string]

Categories of the categorical column that are used to build the chart.

selectedChart: string

Useful to choose the chart kind to display in the UI.

Must be one of: "Bar Chart", "Segmented Bar Chart", "Line Chart", "Relative Evolution Chart", "Period Overlaping Chart"

selection: string

A filter query. See Advanced query filters for more information.

stat: string

Stat kind.

Must be one of: "sum", "mean", "variance", "standardDeviation", "skewness", "kurtosis", "min", "p25", "p50", "p75", "max", "nNulls", "precision", "count"

annotations: array[object]

Comments that can be added to the trends chart. Any text can be added as annotation at certain abscissa point.

Items in annotations

at: string

String containing a valid date.

label: string

Text of the comment.

filterMode: boolean

Defines if the categories must filter or not. If "true", the categories of the categoricalColumn will act as filters.

title: string

Title of the insight.

replayDisabled: string | boolean = False

Indicates if the insight can replay its original state or not.

Must be one of: "drillDown", "directSelectionInGraph", "nonPersistedColumn", True, False

elements: array[object]

Type and appearance of an insight's elements. A list in which each item is an object configuring the appearance of a particular insight element.

Items in elements

kind: string

Specify the type of element.


text: string

The text shown for this insight element.

layout: object

The element's position and size. The position refers to the top-left corner of the rectangle representing the insight element, while the size is given by its width and height. For reference, the entire insight is 12 units wide and 9 units high, and the origin (0, 0) of the x/y coordinates is in its top-left corner.

Items in layout

x: integer

Horizontal position of the element's top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.

Range: -1 ≤ x ≤ 11

y: integer

Vertical position of the element's top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.

Range: 0 ≤ y ≤ 11

w: integer

The width of the element (in increments of 1).

Range: 1 ≤ w ≤ 12

h: integer

The height of the element (in increments of 1).

Range: 1 ≤ h ≤ 9

column: string

Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.