create_plot_insight
Create a new insight from the Plot section.
Usage
The following shows how the step can be used in a recipe.
Examples
Examples
General syntax for using the step in a recipe. Shows the inputs and outputs the step is expected to receive and will produce respectively. For futher details see sections below.
General syntax for using the step in a recipe. Shows the inputs and outputs the step is expected to receive and will produce respectively. For futher details see sections below.
Inputs & Outputs
The following are the inputs expected by the step and the outputs it produces. These are generally
columns (ds.first_name
), datasets (ds
or ds[["first_name", "last_name"]]
) or models (referenced
by name e.g. "churn-clf"
).
Inputs
Inputs
Outputs
Outputs
Configuration
The following parameters can be used to configure the behaviour of the step by including them in
a json object as the last “input” to the step, i.e. step(..., {"param": "value", ...}) -> (output)
.
Parameters
Parameters
Area Chart. Area Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Chart markers foregroundColor.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Area Chart. Area Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Chart markers foregroundColor.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Bar Chart. Bar Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Defines the direction in which the chart is drawn. Defines if Bar or BoxPlot charts will be drawn horizontally or vertically.
Values must be one of the following:
horizontal
vertical
Chart footer text.
Chart subtitle.
Chart title.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Chart markers foregroundColor.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart sorting applied to chart in the x axis.
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Chart sorting direction applied to chart in the x axis.
Values must be one of the following:
ASC
DESC
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Box Plot Chart. Box Plot Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Defines the metrics to be drawn in BoxPlot charts.
Values must be one of the following:
quartiles
quartiles+IQR
quartiles+min/max
mean+standardDeviation
Chart description.
Defines the direction in which the chart is drawn. Defines if Bar or BoxPlot charts will be drawn horizontally or vertically.
Values must be one of the following:
horizontal
vertical
Chart footer text.
Chart subtitle.
Chart title.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Chart markers foregroundColor.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart sorting applied to chart in the x axis.
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Chart sorting direction applied to chart in the x axis.
Values must be one of the following:
ASC
DESC
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Bubble Chart. Bubble Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Chart markers foregroundColor.
Hides chart size legend title.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart size legend title.
Nodes opacity in scatterplot charts.
Metrics shown in scatterplot charts. Defines if regression line, RSquared or Pearson coefficient metrics are displayed.
Slot value that maps bubble size in scatterplot charts. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Selection applied to the column that maps bubble size in scatterplot charts. It can be an array with the categories selected in categorical columns, or an array with the range of the selection for quantitative or date columns.
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Fields in tooltip. A list of fields to show in tooltip for Scatterplot charts.
Array items
Array items
Each item in array.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Bubble Colored Chart. Bubble Colored Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Hides chart color legend title.
Hides chart size legend title.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart color legend title.
Chart size legend title.
Nodes opacity in scatterplot charts.
Metrics shown in scatterplot charts. Defines if regression line, RSquared or Pearson coefficient metrics are displayed.
Slot value that maps bubble size in scatterplot charts. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Selection applied to the column that maps bubble size in scatterplot charts. It can be an array with the categories selected in categorical columns, or an array with the range of the selection for quantitative or date columns.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Fields in tooltip. A list of fields to show in tooltip for Scatterplot charts.
Array items
Array items
Each item in array.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Grouped Bar Chart. Grouped Bar Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Defines the direction in which the chart is drawn. Defines if Bar or BoxPlot charts will be drawn horizontally or vertically.
Values must be one of the following:
horizontal
vertical
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart color legend title.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Chart sorting applied to chart in the x axis.
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Chart sorting direction applied to chart in the x axis.
Values must be one of the following:
ASC
DESC
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Heat Map Chart. Heat Map Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Slot value used to apply color to each cell in Heatmap charts. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Color legend title in Heatmap charts.
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the Y axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Defines if the discretization in the Y axis uses quantiles.
Hides chart color legend title in Heatmap charts.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart sorting applied to chart in the x axis.
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Chart sorting direction applied to chart in the x axis.
Values must be one of the following:
ASC
DESC
Chart sorting applied to chart in the y axis.
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Chart sorting direction applied to chart in the y axis.
Values must be one of the following:
ASC
DESC
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Line Chart. Line Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Chart markers foregroundColor.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Line dash pattern. Configures the dash pattern for lines in line charts.
Properties
Properties
Custom dash pattern. Allows setting a specific dash pattern for the selected categories.
Line markers. Configures the markers for lines in line charts.
Properties
Properties
Custom line markers. Allows setting a specific line marker for the selected categories.
Defines how to represent null values in line charts.
Values must be one of the following:
interpolated
gap
zero
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Defines if zero values should be represented as null in line charts.
Multiple Line Chart. Multiple Line Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart color legend title.
Line dash pattern. Configures the dash pattern for lines in line charts.
Properties
Properties
Custom dash pattern. Allows setting a specific dash pattern for the selected categories.
Line markers. Configures the markers for lines in line charts.
Properties
Properties
Custom line markers. Allows setting a specific line marker for the selected categories.
Defines how to represent null values in line charts.
Values must be one of the following:
interpolated
gap
zero
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Defines if zero values should be represented as null in line charts.
Scatterplot Chart. Scatterplot Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Chart markers foregroundColor.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Nodes opacity in scatterplot charts.
Metrics shown in scatterplot charts. Defines if regression line, RSquared or Pearson coefficient metrics are displayed.
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Fields in tooltip. A list of fields to show in tooltip for Scatterplot charts.
Array items
Array items
Each item in array.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Scatterplot Colored Chart. Scatterplot Colored Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart color legend title.
Nodes opacity in scatterplot charts.
Metrics shown in scatterplot charts. Defines if regression line, RSquared or Pearson coefficient metrics are displayed.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Fields in tooltip. A list of fields to show in tooltip for Scatterplot charts.
Array items
Array items
Each item in array.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type number or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Seasonal Decomposition Chart. Seasonal Decomposition Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Seasonality interval for Seasonal Decomposition plot.
expanded segment in Seasonal Decomposition plot.
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Defines if zero values should be represented as null in line charts.
Segmented Area Chart. Segmented Area Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Chart color legend title.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Segmented Bar Chart. Segmented Bar Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart color legend title.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Chart sorting applied to chart in the x axis.
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Chart sorting direction applied to chart in the x axis.
Values must be one of the following:
ASC
DESC
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Segmented Line Chart. Segmented Line Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart color legend title.
Line dash pattern. Configures the dash pattern for lines in line charts.
Properties
Properties
Custom dash pattern. Allows setting a specific dash pattern for the selected categories.
Line markers. Configures the markers for lines in line charts.
Properties
Properties
Custom line markers. Allows setting a specific line marker for the selected categories.
Defines how to represent null values in line charts.
Values must be one of the following:
interpolated
gap
zero
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Defines if zero values should be represented as null in line charts.
Stacked Area Chart. Stacked Area Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Chart color legend title.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Stacked Bar Chart. Stacked Bar Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Defines the direction in which the chart is drawn. Defines if Bar or BoxPlot charts will be drawn horizontally or vertically.
Values must be one of the following:
horizontal
vertical
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart color legend title.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Chart sorting applied to chart in the x axis.
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Chart sorting direction applied to chart in the x axis.
Values must be one of the following:
ASC
DESC
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Stacked 100% Area Chart. Stacked 100% Area Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Interpolation method used for line or area chart.
Values must be one of the following:
linear
monotone
cardinal
natural
step
step-before
step-after
Chart color legend title.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Stacked 100% Bar Chart. Stacked 100% Bar Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Comments that can be added to the chart. Any text can be added as annotation at certain abscissa point.
Array items
Array items
Alignment of the annotation.
Values must be one of the following:
start
center
end
Text of the comment.
Annotations shape. Annotations shape configuration.
Properties
Properties
Annotation shape type.
Values must be one of the following:
arrow
Annotation endpoint type for arrow shape.
Values must be one of the following:
line
solid
none
Annotation shape line style.
Values must be one of the following:
solid
dashed
Annotation shape line color.
Annotation shape line width.
Annotation shape endpoint position x for arrow shape.
Annotation shape endpoint position y for arrow shape.
X axis value. X axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in X axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in X axis.
Annotation value in X axis.
Y axis value. Y axis value where the annotation is placed.
Options
Options
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
VALUE
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT_VALUE
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Annotation value in Y axis.
Annotation kind.
Values must be one of the following:
STAT
Whether to hide the annotation value in the label.
Annotation stat in Y axis.
Values must be one of the following:
max
mean
median
min
q1
q3
Chart description.
Defines the direction in which the chart is drawn. Defines if Bar or BoxPlot charts will be drawn horizontally or vertically.
Values must be one of the following:
horizontal
vertical
Chart footer text.
Chart subtitle.
Chart title.
Slot value used to map color in the chart. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or date.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Categories of the color variable.
Array items
Array items
Each item in array.
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Discretization configuration for a slot (x, y or color). There is different kind of discretization configurations depending on column type:
- For quantitative ones a single count defining the number of bins is enough
- For categorical ones we need the count of categories & its top (DESC) or bottom (ASC) direction
- For dates we need a date period & a count of periods.
Options
Options
Number of bins in the axis.
Number of bins in the axis.
Number of bins in the axis.
Get top (DESC) or bottom (ASC) categories for categorical variables in the axis.
Values must be one of the following:
ASC
DESC
Number of time units that sets the size of the discretization.
Time unit to specify the discretization period.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
DAY
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is a recurrent one (i.e. WEEK_DAY).
Defines if the discretization in the X axis uses a exact or pretty number of bins.
Defines if the discretization in the X axis uses quantiles.
Hides chart color legend title.
Hides chart X axis title.
Hides chart Y axis title.
Chart value labels. Show & configure value labels in some charts.
Properties
Properties
Column for node labels in scatterplot charts.
Style configurations for value labels in bar charts. Set position & alignment configuration for value labels in bar charts.
Format for value labels.
Format for absolute value labels.
Format for value count labels.
Format for percentage change labels.
Margin between node labels in scatterplot charts.
Whether to show value labels.
Whether to show absolute value labels.
Whether to show value count labels.
Whether to show percentage change labels.
Whether to show total value labels in stacked bar charts.
Chart color legend title.
Sorting applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Sorting direction applied to categories of the color variable (segmentsColumn).
Values must be one of the following:
ASC
DESC
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.
Values must be one of the following:
SORT
CUSTOM
Chart sorting applied to chart in the x axis.
Values must be one of the following:
XAXIS
YAXIS
YAXIS_SEGMENT
SELECTION
ORDINAL
ALPHANUM
Chart sorting direction applied to chart in the x axis.
Values must be one of the following:
ASC
DESC
Stat configuration.
For example, for a max stat it would be:
{ "stat": "max" }
For stats that require a param like “countWhere” or “percentOfRowsWhere” it would be:
{ "stat": "countWhere", "params": { "value": "categoryName" } }
Properties
Properties
Stat kind.
Values must be one of the following:
sum
mean
variance
standardDeviation
skewness
kurtosis
min
p25
p50
p75
max
nNulls
precision
count
cumSum
nodeCount
rForeground
rForegroundColor
rForegroundX
uniqueValues
valueCount
countWhere
percentOfRowsWhere
Theme applied to the chart.
Values must be one of the following:
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme color palette applied to the chart.
Values must be one of the following:
Horus
Osiris
Re
Blues
Greens
Oranges
Purples
Reds
Viridis
Magma
Plasma
Red-Blue
Blue-Orange
Red-Grey
Red-Yellow-Blue
Red-Yellow-Green
graphext
dark
excel
fivethirtyeight
ggplot2
googlecharts
latimes
powerbi
quartz
urbaninstitute
vox
Theme mode applied to the chart.
Values must be one of the following:
dark
light
Defines if tooltip is enabled.
Slot value represented in the x axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean, number or date, as well as listIndex.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
X Axis config options. Configuration options specific to X axis, including base axis properties and label display controls.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis labels orientation mode. Controls how axis labels are oriented. auto (rotates only when needed), rotate (always rotated), or none (never rotated).
Values must be one of the following:
auto
rotate
none
Labels rotation in degrees.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart X axis title.
Slot value represented in the y axis. SlotValues could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts variables of type category, boolean or number, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
Y Axis config options. Configuration options specific to Y axis, including base axis properties.
Properties
Properties
Whether to hide grid lines in the axe or not.
Whether to include zero in the axe or not.
Whether to use a logarithmic scale.
Axis labels numeric format.
Maximum width in pixels for axis labels before truncating with ellipsis.
Axis ticks configuration. An object for axis tick configuration.
Properties
Properties
Ticks count. Equivalent to Vega axes tickCount prop.
Chart Y axis title.
Table Chart. Table Chart.
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.
Array items
Array items
Specify the type of element.
Values must be one of the following:
TITLE
DESCRIPTION
CHART
GRAPH
STATS
LEGEND
LEGEND_COLOR_SCALE
TABLE_CHART
The text shown for this insight element.
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.
Properties
Properties
Horizontal position of the element’s top-left corner. In increments of 1; 0 being the left-most and 8 the right-most position.
Values must be in the following range:
Vertical position of the element’s top-left corner. In increments of 1; 0 being the top-most and 11 the bottom-most position.
Values must be in the following range:
The width of the element (in increments of 1).
Values must be in the following range:
The height of the element (in increments of 1).
Values must be in the following range:
Name of the column containing the data to be used in this insight element. Required if the element is of type CHART or STATS.
Theme mode applied to the whole insight.
Values must be one of the following:
dark
light
Defines if the cross-filters mode is set to auto.
Defines if the cross-filters and significant variables should ignore null values.
Insight default layout.
Values must be one of the following:
plot
all
Insight default layout elements.
Array items
Array items
Each item in array.
Values must be one of the following:
title
description
filters
Defines if the cross-filters mode is set to relative.
Indicates if the insight can replay its original state or not.
Values must be one of the following:
drillDown
directSelectionInGraph
nonPersistedColumn
True
False
A filter query. See Advanced query filters for more information.
Title of the insight.
Defines the direction in which the chart is drawn. Defines if Bar or BoxPlot charts will be drawn horizontally or vertically.
Values must be one of the following:
horizontal
vertical
Total number of selected rows in the dataset.
Values must be in the following range:
Width of the columns in the table.
Each object represents a column in the table and its corresponding width settings.
For example:
{ "COLUMN-column1": 300 }
Will set the width of the ‘column1’ to 300 pixels.
Item properties
Item properties
One or more additional parameters.
Discretizations for columns used in group by in the summary table. Each object represents a dataset column and its corresponding discretization settings. For example:
Will try to discretize the ‘column1’ in 10 bins.
Item properties
Item properties
One or more additional parameters. Configuration for the selected column.
Properties
Properties
Number of bins to discretize the column.
Values must be in the following range:
Period to discretize the column.
Values must be one of the following:
MILLISECOND
SECOND
MINUTE
HOUR
YEAR_DAY
MONTH_DAY
WEEK_DAY
WEEK
WEEK_OF_YEAR
MONTH
QUARTER
YEAR
Defines if the period is recurrent.
Defines if the discretization for columns used in group by in the summary table uses exact or pretty number of bins. Each object represents a dataset column and its corresponding configuration to use exact or pretty number of bins. For example:
Will try to discretize the ‘column1’ using an exact number of bins.
Item properties
Item properties
One or more additional parameters.
Defines if the discretization for columns used in group by in the summary table uses quantiles. Each object represents a dataset column and its corresponding configuration to use quantiles. For example:
Will try to discretize the ‘column1’ using quantiles.
Item properties
Item properties
One or more additional parameters.
The index of the first row shown in the table.
Values must be in the following range:
Format for the numeric values in the table. Each object represents a column in the dataset and its corresponding format settings. We use the Python format specification mini-language to specify the format. For example:
Will format the ‘column1’ with two decimal places (e.g., 1,234.56).
Whether to hide the index row in the table.
Variables to group by to generate a summary table. If provided, tableValues should also be defined to specify the desired aggregation for each value.
Array items
Array items
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts any variables from dataset.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
COUNT_WHERE
PERCENT_OF_ROWS_WHERE
Parameters for the aggregation method. Only for values with AGGREGATED_COLUMN kind.
For example, for the aggregation ‘COUNT_WHERE’, the parameter should include the category to count.
{ "value": "category1" }
Properties
Properties
Value for the aggregation method.
Whether the column is ordinal.
Custom name for the column.
Whether the label is custom. If true, the label will be show without any transformation. If false, the label may be transformed.
Whether to hide the column subtitle (e.g., Value Count
).
Semantic type of the column.
Values must be one of the following:
list
boolean
category
currency
date
number
sex
text
url
list[boolean]
list[date]
list[number]
list[url]
list[category]
Type of the column.
Values must be one of the following:
categorical
quantitative
date
text
id
url
How many rows per page are shown in the table.
Values must be in the following range:
Custom styles for the table. Each item represents a column in the dataset and its corresponding style settings. For example:
Will apply a custom pill style with red color to the cells that match the query.
Array items
Array items
Slot value id.
Custom graphext query to apply the style. Each cell will be evaluated with the query, and if it returns true, the style will be applied.
Categories for cell coloring. Each item in the array represents a category in the column that will be used to color the cells in the table.
Array items
Array items
Each item in array.
Style configuration. Each style is an object with property and value fields.
Properties
Properties
Style property to customize each cell:
- backgroundColor: will change the background color
- color: will change the text color
- graphextPill: will apply a custom pill style.
Values must be one of the following:
backgroundColor
color
graphextPill
Color in hexadecimal format (e.g., #FF0000
).
Totals to show as a footer in the table. Each object represents a column in the dataset and the totals to show for the selected column For example:
Will show the sum, mean and variance of the column1 (if column1 is shown in the table).
Item properties
Item properties
Aggregations if tableRows is provided, basic columns if not. If tableRows is defined, tableValues will be the definition of desired aggregations. Each object represents a column in the dataset and its aggregation. Those aggregations will reduce all the values of the column to a single value, applying the selected aggregation method If tableRows is not defined, tableValues will represent the columns to show in the table.
Array items
Array items
The value for a slot, defined by its kind & its name with some extra column props. SlotValueData could be of kind column, aggregated column, listIndex, nodeCount or metric.
Properties
Properties
The kind of then slot value.
Values must be one of the following:
AGGREGATED_COLUMN
COLUMN
LIST_INDEX
NODE_COUNT
METRIC
The name of the slot value. Accepts any variables from dataset, as well as nodeCount or a metric.
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.
Values must be one of the following:
SUM
AVG
VARIANCE
STDEV
MIN
P25
P50
P75
MAX
MODE
UNIQUE_VALUES
LIST
LIST_UNIQUE
CONCATENATE
COUNT
ELEMENT_COUNT
ELEMENT_MIN
ELEMENT_MAX
ELEMENT_SUM
ELEMENT_AVG
ELEMENT_VARIANCE
ELEMENT_STDEV
COUNT_WHERE
PERCENT_OF_ROWS_WHERE
Parameters for the aggregation method. Only for values with AGGREGATED_COLUMN kind.
For example, for the aggregation ‘COUNT_WHERE’, the parameter should include the category to count.
{ "value": "category1" }
Properties
Properties
Value for the aggregation method.
Whether the column is ordinal.
Custom name for the column.
Whether the label is custom. If true, the label will be show without any transformation. If false, the label may be transformed.
Whether to hide the column subtitle (e.g., Value Count
).
Semantic type of the column.
Values must be one of the following:
list
boolean
category
currency
date
number
sex
text
url
list[boolean]
list[date]
list[number]
list[url]
list[category]
Type of the column.
Values must be one of the following:
categorical
quantitative
date
text
id
url