The following shows how the step can be used in a recipe.
Examples
Signature
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.
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").
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).
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.
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:
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
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" } }
Stat kind.Values must be one of the following:summeanvariancestandardDeviationskewnesskurtosisminp25p50p75maxnNullsprecisioncountcumSumnodeCountrForegroundrForegroundColorrForegroundXuniqueValuesvalueCountcountWherepercentOfRowsWhere
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
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:
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
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" } }
Stat kind.Values must be one of the following:summeanvariancestandardDeviationskewnesskurtosisminp25p50p75maxnNullsprecisioncountcumSumnodeCountrForegroundrForegroundColorrForegroundXuniqueValuesvalueCountcountWherepercentOfRowsWhere
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
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:
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_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:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_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:XAXISYAXISYAXIS_SEGMENTSELECTIONORDINALALPHANUM
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.Values must be one of the following:
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
Sorting applied to categories of the color variable (segmentsColumn).Values must be one of the following:XAXISYAXISYAXIS_SEGMENTSELECTIONORDINALALPHANUM
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.Values must be one of the following:
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" } }
Stat kind.Values must be one of the following:summeanvariancestandardDeviationskewnesskurtosisminp25p50p75maxnNullsprecisioncountcumSumnodeCountrForegroundrForegroundColorrForegroundXuniqueValuesvalueCountcountWherepercentOfRowsWhere
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
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" } }
Stat kind.Values must be one of the following:summeanvariancestandardDeviationskewnesskurtosisminp25p50p75maxnNullsprecisioncountcumSumnodeCountrForegroundrForegroundColorrForegroundXuniqueValuesvalueCountcountWherepercentOfRowsWhere
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
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" } }
Stat kind.Values must be one of the following:summeanvariancestandardDeviationskewnesskurtosisminp25p50p75maxnNullsprecisioncountcumSumnodeCountrForegroundrForegroundColorrForegroundXuniqueValuesvalueCountcountWherepercentOfRowsWhere
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
Sorting applied to categories of the color variable (segmentsColumn).Values must be one of the following:XAXISYAXISYAXIS_SEGMENTSELECTIONORDINALALPHANUM
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.Values must be one of the following:
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" } }
Stat kind.Values must be one of the following:summeanvariancestandardDeviationskewnesskurtosisminp25p50p75maxnNullsprecisioncountcumSumnodeCountrForegroundrForegroundColorrForegroundXuniqueValuesvalueCountcountWherepercentOfRowsWhere
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
Sorting applied to categories of the color variable (segmentsColumn).Values must be one of the following:XAXISYAXISYAXIS_SEGMENTSELECTIONORDINALALPHANUM
Sorting mode applied to categories of the color variable (segmentsColumn). CUSTOM does not apply any sorting criteria.Values must be one of the following:
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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.
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:
Time unit to specify the discretization period.Values must be one of the following:MILLISECONDSECONDMINUTEHOURDAYYEAR_DAYMONTH_DAYWEEK_DAYWEEKWEEK_OF_YEARMONTHQUARTERYEAR
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" } }
Stat kind.Values must be one of the following:summeanvariancestandardDeviationskewnesskurtosisminp25p50p75maxnNullsprecisioncountcumSumnodeCountrForegroundrForegroundColorrForegroundXuniqueValuesvalueCountcountWherepercentOfRowsWhere
Theme applied to the chart.Values must be one of the following:graphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Theme color palette applied to the chart.Values must be one of the following:HorusOsirisReBluesGreensOrangesPurplesRedsViridisMagmaPlasmaRed-BlueBlue-OrangeRed-GreyRed-Yellow-BlueRed-Yellow-Greengraphextdarkexcelfivethirtyeightggplot2googlechartslatimespowerbiquartzurbaninstitutevox
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV
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:
Aggregation method to apply to the column. Only for values with AGGREGATED_COLUMN kind.Values must be one of the following:SUMAVGVARIANCESTDEVMINP25P50P75MAXMODEUNIQUE_VALUESLISTLIST_UNIQUECONCATENATECOUNTELEMENT_COUNTELEMENT_MINELEMENT_MAXELEMENT_SUMELEMENT_AVGELEMENT_VARIANCEELEMENT_STDEV