column

alignment

Alignment of text inside the column

left

left | center | right

label

value

width

Width of the column

activeColumns

Use this property to reorder or hide columns by specifying desired list of column names

categoriesForRank

Filter for categories used in ranking

format

Accepts an identifier of a formatter which transforms value to a custom format

hide

Use this property to remove header from widget response.

false

true | false

label

The label, accepts template values, for example: "{code} - {label}"

width

Column width in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem)

cell

Data Grid value cell.

cell rowPercentage

Row percentage cell

cell columnPercentage

Column percentage cell

cell trend

Data Grid trend cell.

cell meanTtest

Mean T test cell

cell meanZtest

Mean Z test cell

cell proportionalTtest

Proportional T test cell

cell proportionalZtest

Proportional Z test cell

cell microchart

Data Grid chart cell

cell diff

Cell diff

cell custom

Data Grid custom cell.

filter expression

Expression filter

scope reportingHierarchy

Changes the reporting hierarchy nodes to be used from default/selected in filter to different one

scope reportingPeriod

Changes the reporting period from default / selected in the filter to different one

scope filter

Changes applied filter to to different one

column

Data Grid column

column cut

Data Grid cut column

column cutByMulti

Data Grid cut by multi column

column cutByDate

Data Grid cut by date column

column cutByOverlappingDate

Data Grid cut by overlapping date column

column variable

Variable column

column variableList

Variable list column, supports variableSet

column pathHierarchy

Path hierarchy column

column cutByTable [Beta]

Data Grid cut by table header

column cutByScope [Beta]

Data Grid cut by scope column

backgroundColorFormatter

Background color formatter

gridDefaultBackgroundColorFormatter

format

Accepts an identifier of a formatter which transforms value to a custom format

label

Column label

target

Column target

value

Value to calculate

valueColorFormatter

Value color formatter

gridDefaultValueColorFormatter

view

This is the identifier of a View, where the View is a special case of a formatter which is responsible for the UI (a formatter is normally used for data transformation). A View must be specified if non-default behavior is needed

accountName

Account name

accountNameFormat

Accepts an identifier of a formatter which transforms value to a custom format

valueDefaultFormatter

revenue

Revenue

revenueFormat

Accepts an identifier of a formatter which transforms value to a custom format

currencyDefaultFormatter

show

Add this property to control column visibility (true | false).

true

true | false

sortBy

revenue

view

This is the identifier of a View, where the View is a special case of a formatter which is responsible for the UI (a formatter is normally used for data transformation). A View must be specified if non-default behavior is needed

accountsDefaultView

suppressRule

Suppression criteria for a column

show

Add this property to control column visibility (true | false).

true

true | false

action navigate

This object will be required if you want the user to be able to navigate to different pages. The name of the page to which the user is to be sent must be added into the column_action_navigate_to property, and you can also add a label.

aggregateOnDimensions

Switching it on enables value aggregation in dimension rows.

Off

On | Off

benchmarkType

Determines with which column (scores or breakdown) benchmarks will be compared

score

score | breakdown

compareToPercent

Switching it off enables comparison of benchmark number against raw numbers

On

On | Off

format

accepts a formatter that would format value

label

Title of column

mode

Difference is shown as plain number with conditional formatting in mode "number", and as a chart in mode "variance"

variance

number | variance

option

Name of scale option to compare benchmark value against.

palette

The colors of the benchmark. Just two color needed. One color will be used if one color specified

#FA5263,#82D854

question

The reference to question field in custom data. Must be have the same dataset and table as value property

sorting

Switching it on enables sorting for benchmark column by benchmark value.

Off

On | Off

value

The reference to value field in custom data. Must be have the same dataset and table as question property

grid

Override grid

aggregateOnDimensions

Switching it on enables value aggregation in dimension rows

Off

On | Off

format

accepts a formatter that would format value

label

Title of column

legend

Switching it on enables legend

Off

On | Off

palette

The color of the score bar

#4399d6,#ebedf0,#bfc5cc

percent

Switching it off enables raw numbers as bar values

On

On | Off

sorting

Switching it on enables sorting for scores column

Off

On | Off

unit

The unit postfix that will be used right after value label

grid

Override grid

align

This object aligns the column cell content. Note that it may be overridden by a view internal implementation if the view spans the entire column cell.

left | center | right

enableColumnFilter

This option enables filtering by column value in the column header. Not all value expressions are supported at the moment. Known limitations: derived variables, aggregation functions without aggregation target and some others

false

true | false

filterable

Add this property to make the column filterable (true | false).

true

true | false

filterBy

This option defines field name for which filter should be applied

value

format

Accepts an identifier of a formatter which transforms value to a custom format

currencyDefaultFormatter

label

This object defines the text that is to be displayed in the column header.

rowHeader

This object emphasizes the text in the column intended to be the row header such that it stands out compared to the other columns.

false

true | false

show

Add this property to control column visibility (true | false).

true

true | false

sortable

Add this property to make the column sortable (true | false).

true

true | false

totalExpression

Add a custom expression to calculate the total value of the column.

value

Formula or question ID / alias

view

This is the identifier of a View, where the View is a special case of a formatter which is responsible for the UI (a formatter is normally used for data transformation). A View must be specified if non-default behavior is needed

valueDefaultView

width

This property specifies column width

suppressRule

Suppression criteria for a column

activeColumns

Use this property to reorder or hide columns by specifying desired list of column names

categories

Filter for categories used

categoriesForRank

Filter for categories used in ranking

categoryLabel

Category label, accepts template values, for example: "{code} - {label}"

collapseMulti

When set to true, this header acts like 'cutByMulti' for multi-choice variables, while it has no effect on other types of valriables.

true | false

emptyFirst

For some header cells desired values can be empty. This setting specifies if such cells should go before or after others. Default value is false.

true | false

exclude

An array of codes that should be excluded from sorting.

format

Accepts an identifier of a formatter which transforms value to a custom format

hide

Use this property to remove header from widget response.

false

true | false

label

The label, accepts template values, for example: "{code} - {label}"

notAnswered

Not answered position

none

none | first | last

notAnsweredLabel

Not answered label

showLabel

Show label

false

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

takeBottom

Specifies how many cells are to be taken, starting at the bottom of the column.

takeTop

Specifies how many cells are to be taken, starting at the top of the column.

total

Total position

first

none | first | last

totalLabel

Total label

value

Formula or question ID / alias

width

Column width in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem)

column

Data Grid column

column cutByMulti

Data Grid cut by multi column

column cutByDate

Data Grid cut by date column

column cutByOverlappingDate

Data Grid cut by overlapping date column

column variable

Variable column

column variableList

Variable list column, supports variableSet

column pathHierarchy

Path hierarchy column

column cutByTable [Beta]

Data Grid cut by table header

column cutByScope [Beta]

Data Grid cut by scope column

activeColumns

Use this property to reorder or hide columns by specifying desired list of column names

align

Set this property to true if date range should be aligned

true | false

breakdownBy

Here you input the time set that is to be used to divide up the Expression (year | calendarQuarter | calendarMonth | calendarWeek | calendarDate | quarter | month | week | day | weekday | hour).

year

year | calendarQuarter | calendarMonth | calendarWeek | calendarDate | quarter | month | week | day | weekday | hour

categories

Filter for categories used

categoriesForRank

Filter for categories used in ranking

categoryLabel

Category label, accepts template values, for example: "{code} - {label}"

emptyFirst

For some header cells desired values can be empty. This setting specifies if such cells should go before or after others. Default value is false.

true | false

end

Contains description of range end and applies filter to the date expression.

exclude

An array of codes that should be excluded from sorting.

format

Accepts an identifier of a formatter which transforms value to a custom format

hide

Use this property to remove header from widget response.

false

true | false

label

The label, accepts template values, for example: "{code} - {label}"

movingAverageEnd

This defines a number of date parts after current to include in average window

movingAverageStart

This defines a number of date parts before current to include in average window

notAnswered

Not answered position

none

none | first | last

notAnsweredLabel

Not answered label

showLabel

Show label

false

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

start

Contains description of range start and applies filter to the date expression.

takeBottom

Specifies how many cells are to be taken, starting at the bottom of the column.

takeTop

Specifies how many cells are to be taken, starting at the top of the column.

total

Total position

first

none | first | last

totalLabel

Total label

value

Formula or question ID / alias

width

Column width in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem)

column cutByMulti

Data Grid cut by multi column

column cutByOverlappingDate

Data Grid cut by overlapping date column

column variable

Variable column

column variableList

Variable list column, supports variableSet

column pathHierarchy

Path hierarchy column

column cutByTable [Beta]

Data Grid cut by table header

column cutByScope [Beta]

Data Grid cut by scope column

activeColumns

Use this property to reorder or hide columns by specifying desired list of column names

categories

Filter for categories used

categoriesForRank

Filter for categories used in ranking

categoryLabel

Category label, accepts template values, for example: "{code} - {label}"

emptyFirst

For some header cells desired values can be empty. This setting specifies if such cells should go before or after others. Default value is false.

true | false

exclude

An array of codes that should be excluded from sorting.

format

Accepts an identifier of a formatter which transforms value to a custom format

hide

Use this property to remove header from widget response.

false

true | false

label

The label, accepts template values, for example: "{code} - {label}"

notAnswered

Not answered position

none

none | first | last

notAnsweredLabel

Not answered label

showLabel

Show label

false

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

takeBottom

Specifies how many cells are to be taken, starting at the bottom of the column.

takeTop

Specifies how many cells are to be taken, starting at the top of the column.

total

Total position

first

none | first | last

totalLabel

Total label

value

Formula or question ID / alias

width

Column width in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem)

column cut

Data Grid cut column

column cutByDate

Data Grid cut by date column

column cutByOverlappingDate

Data Grid cut by overlapping date column

column variable

Variable column

column variableList

Variable list column, supports variableSet

column pathHierarchy

Path hierarchy column

column cutByTable [Beta]

Data Grid cut by table header

column cutByScope [Beta]

Data Grid cut by scope column

activeColumns

Use this property to reorder or hide columns by specifying desired list of column names

align

Set this property to true if date range should be aligned

true | false

breakdownBy

Here you input the time set that is to be used to divide up the Expression (year | calendarQuarter | calendarMonth | calendarWeek | calendarDate | quarter | month | week | day | weekday | hour).

year

year | calendarQuarter | calendarMonth | calendarWeek | calendarDate | quarter | month | week | day | weekday | hour

categories

Filter for categories used

categoriesForRank

Filter for categories used in ranking

categoryLabel

Category label, accepts template values, for example: "{code} - {label}"

emptyFirst

For some header cells desired values can be empty. This setting specifies if such cells should go before or after others. Default value is false.

true | false

end

Contains description of range end and applies filter to the date expression.

endShift

Modification of ends of breakdown intervals in the form '<value> <period>'. Here 'value' is an integer (both positive and negative). 'period' can be 'year', 'quarter', 'month', 'week', 'day', 'hour'. If the property is absent, then ends of breakdown intervals will not be modified. Be aware that not all possible periods are valid for each breakdown interval. For example, if you breakdown dates by CalendarMonth you cannot then shift them by quarters. Also, shifts by weeks is only available for breakdown by weeks.

exclude

An array of codes that should be excluded from sorting.

format

Accepts an identifier of a formatter which transforms value to a custom format

hide

Use this property to remove header from widget response.

false

true | false

label

The label, accepts template values, for example: "{code} - {label}"

notAnswered

Not answered position

none

none | first | last

notAnsweredLabel

Not answered label

showLabel

Show label

false

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

start

Contains description of range start and applies filter to the date expression.

startShift

Modification of starts of breakdown intervals in the form '<value> <period>'. Here 'value' is an integer (both positive and negative). 'period' can be 'year', 'quarter', 'month', 'week', 'day', 'hour'. If the property is absent, then starts of breakdown intervals will not be modified. Be aware, that not all possible periods are valid for each breakdown interval. For example, if you breakdown dates by CalendarMonth, you cannot then shift them by quarter. Also, shifts by weeks is only available for breakdown by weeks.

takeBottom

Specifies how many cells are to be taken, starting at the bottom of the column.

takeTop

Specifies how many cells are to be taken, starting at the top of the column.

total

Total position

first

none | first | last

totalLabel

Total label

value

Formula or question ID / alias

width

Column width in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem)

column cutByDate

Data Grid cut by date column

column variable

Variable column

column variableList

Variable list column, supports variableSet

column pathHierarchy

Path hierarchy column

column cutByTable [Beta]

Data Grid cut by table header

column cutByScope [Beta]

Data Grid cut by scope column

activeColumns

Use this property to reorder or hide columns by specifying desired list of column names

categoriesForRank

Filter for categories used in ranking

categoryLabel

Category label, accepts template values, for example: "{code} - {label}"

emptyFirst

For some header cells desired values can be empty. This setting specifies if such cells should go before or after others. Default value is false.

true | false

exclude

An array of codes that should be excluded from sorting.

format

Accepts an identifier of a formatter which transforms value to a custom format

hide

Use this property to remove header from widget response.

false

true | false

label

The label, accepts template values, for example: "{code} - {label}"

mainLabel

Label for the main scope column

notAnswered

Not answered position

none

none | first | last

notAnsweredLabel

Not answered label

otherLabel

Label for the secondary scope column

showLabel

Show label

false

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

takeBottom

Specifies how many cells are to be taken, starting at the bottom of the column.

takeTop

Specifies how many cells are to be taken, starting at the top of the column.

total

Total position

first

none | first | last

totalLabel

Total label

width

Column width in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem)

breakdownBy reportingPeriod

Entity, that specifies the reporting periods that are used in cut

column cutByTable [Beta]

Data Grid cut by table header

activeColumns

Use this property to reorder or hide columns by specifying desired list of column names

categoriesForRank

Filter for categories used in ranking

format

Accepts an identifier of a formatter which transforms value to a custom format

hide

Use this property to remove header from widget response.

false

true | false

label

Common label for a whole column

labels

A list of expressions to create labels for all levels of the header.

showLabel

Show label

false

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

table

The table that this header is based on

take

The number of items to take

width

Column width in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem)

column pathHierarchy

Path hierarchy column

column cutByScope [Beta]

Data Grid cut by scope column

align

This object aligns the column cell content. Note that it may be overridden by a view internal implementation if the view spans the entire column cell.

left | center | right

enableColumnFilter

This option enables filtering by column value in the column header. Not all value expressions are supported at the moment. Known limitations: derived variables, aggregation functions without aggregation target and some others

false

true | false

filterable

Add this property to make the column filterable (true | false).

true

true | false

filterBy

This option defines field name for which filter should be applied

value

format

Accepts an identifier of a formatter which transforms value to a custom format

dateDefaultFormatter

label

This object defines the text that is to be displayed in the column header.

rowHeader

This object emphasizes the text in the column intended to be the row header such that it stands out compared to the other columns.

false

true | false

show

Add this property to control column visibility (true | false).

true

true | false

sortable

Add this property to make the column sortable (true | false).

true

true | false

totalExpression

Add a custom expression to calculate the total value of the column.

value

Formula or question ID / alias

view

This is the identifier of a View, where the View is a special case of a formatter which is responsible for the UI (a formatter is normally used for data transformation). A View must be specified if non-default behavior is needed

valueDefaultView

width

This property specifies column width

suppressRule

Suppression criteria for a column

highDeviation

Describe high deviation number value or an object

label

Title of column

lowDeviation

Describe low deviation number value or an object

normalize

Normalize question score values to 1-100 scores

On

On | Off

sorting

Switching it on enables sorting for scores deviation column

Off

On | Off

grid

lowDeviation/highDeviation properties can be overwritten for different grids.

icons

Switching it on enables icons

On

On | Off

label

Title of column

activationDate

Formula or question ID / alias

align

This object aligns the column cell content. Note that it may be overridden by a view internal implementation if the view spans the entire column cell.

left | center | right

daysNotice

Formula or question ID / alias

enableColumnFilter

This option enables filtering by column value in the column header. Not all value expressions are supported at the moment. Known limitations: derived variables, aggregation functions without aggregation target and some others

false

true | false

expireDate

Formula or question ID / alias

filterable

Add this property to make the column filterable (true | false).

true

true | false

filterBy

This option defines field name for which filter should be applied

value

label

This object defines the text that is to be displayed in the column header.

rowHeader

This object emphasizes the text in the column intended to be the row header such that it stands out compared to the other columns.

false

true | false

show

Add this property to control column visibility (true | false).

true

true | false

sortable

Add this property to make the column sortable (true | false).

true

true | false

sortBy

This object sorts the table by the statuses in the expiry progress column.

expireDate

totalExpression

Add a custom expression to calculate the total value of the column.

view

This is the identifier of a View, where the View is a special case of a formatter which is responsible for the UI (a formatter is normally used for data transformation). A View must be specified if non-default behavior is needed

expirationProgressDefaultView

width

This property specifies column width

suppressRule

Suppression criteria for a column

tooltip value

This object contains the tooltip text that will be displayed under the cell when the user hovers the mouse pointer over it.

align

This object aligns the column cell content. Note that it may be overridden by a view internal implementation if the view spans the entire column cell.

left | center | right

enableColumnFilter

This option enables filtering by column value in the column header. Not all value expressions are supported at the moment. Known limitations: derived variables, aggregation functions without aggregation target and some others

false

true | false

filterable

Add this property to make the column filterable (true | false).

true

true | false

filterBy

This option defines field name for which filter should be applied

value

format

Accepts an identifier of a formatter which transforms value to a custom format

valueDefaultFormatter

label

This object defines the text that is to be displayed in the column header.

labelPostfix

rowHeader

This object emphasizes the text in the column intended to be the row header such that it stands out compared to the other columns.

false

true | false

show

Add this property to control column visibility (true | false).

true

true | false

sortable

Add this property to make the column sortable (true | false).

true

true | false

totalExpression

Add a custom expression to calculate the total value of the column.

value

Formula or question ID / alias

view

This is the identifier of a View, where the View is a special case of a formatter which is responsible for the UI (a formatter is normally used for data transformation). A View must be specified if non-default behavior is needed

valueDefaultView

width

This property specifies column width

suppressRule

Suppression criteria for a column

tooltip value

This object contains the tooltip text that will be displayed under the cell when the user hovers the mouse pointer over it.

align

This object aligns the column cell content. Note that it may be overridden by a view internal implementation if the view spans the entire column cell.

left | center | right

enableColumnFilter

This option enables filtering by column value in the column header. Not all value expressions are supported at the moment. Known limitations: derived variables, aggregation functions without aggregation target and some others

false

true | false

filterable

Add this property to make the column filterable (true | false).

true

true | false

filterBy

This option defines field name for which filter should be applied

value

format

Accepts an identifier of a formatter which transforms value to a custom format

valueDefaultFormatter

icon

Formula or question ID / alias

label

This object defines the text that is to be displayed in the column header.

labelPostfix

rowHeader

This object emphasizes the text in the column intended to be the row header such that it stands out compared to the other columns.

false

true | false

show

Add this property to control column visibility (true | false).

true

true | false

sortable

Add this property to make the column sortable (true | false).

true

true | false

totalExpression

Add a custom expression to calculate the total value of the column.

value

Formula or question ID / alias

view

This is the identifier of a View, where the View is a special case of a formatter which is responsible for the UI (a formatter is normally used for data transformation). A View must be specified if non-default behavior is needed

iconDefaultView

width

This property specifies column width

suppressRule

Suppression criteria for a column

align

This object aligns the column cell content. Note that it may be overridden by a view internal implementation if the view spans the entire column cell.

left | center | right

enableColumnFilter

This option enables filtering by column value in the column header. Not all value expressions are supported at the moment. Known limitations: derived variables, aggregation functions without aggregation target and some others

false

true | false

filterable

Add this property to make the column filterable (true | false).

true

true | false

filterBy

This option defines field name for which filter should be applied

value

format

Accepts an identifier of a formatter which transforms value to a custom format

valueDefaultFormatter

label

This object defines the text that is to be displayed in the column header.

rowHeader

This object emphasizes the text in the column intended to be the row header such that it stands out compared to the other columns.

false

true | false

show

Add this property to control column visibility (true | false).

true

true | false

sortable

Add this property to make the column sortable (true | false).

true

true | false

totalExpression

Add a custom expression to calculate the total value of the column.

value

Formula or question ID / alias

view

This is the identifier of a View, where the View is a special case of a formatter which is responsible for the UI (a formatter is normally used for data transformation). A View must be specified if non-default behavior is needed

copyLinkDefaultView

width

This property specifies column width

suppressRule

Suppression criteria for a column

link href

Simple link.

link survey

Link to some survey.

link surveyQuestion

Link to some question of survey.

link surveyBlock

Link to some block of survey.