widget crosstab

Data Grid cut row

Data Grid cut by multi row

Data Grid cut by date row

Data Grid cut by overlapping date row

Data Grid row

 row cut
Data Grid cut row

Name Description Default value Available options

bottom

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

top

topBottomOrder

value

Formula or question ID / alias

 row cutByMulti
Data Grid cut by multi row

Name Description Default value Available options

bottom

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

top

topBottomOrder

value

Formula or question ID / alias

 row cutByDate
Data Grid cut by date row

Name Description Default value Available options

align

Set this property to true if date range should be aligned

true | false

breakdownBy

year

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

value

Formula or question ID / alias

 row cutByOverlappingDate
Data Grid cut by overlapping date row

Name Description Default value Available options

align

Set this property to true if date range should be aligned

true | false

breakdownBy

year

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

value

Formula or question ID / alias

 row
Data Grid row

Name Description Default value Available options

format

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

rows splits

Crosstab splits in rows position

Name

Description

Default value

Available options

Data Grid cut row

Data Grid cut by multi row

Data Grid cut by date row

Data Grid cut by overlapping date row

Data Grid row

row comparison

Crosstab comparison row

row selectedHierarchy

Crosstab selectedHierarchy row

row selectedFlat

Data Grid selectedFlat row

 row cut
Data Grid cut row

Name Description Default value Available options

bottom

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

top

topBottomOrder

value

Formula or question ID / alias

 row cutByMulti
Data Grid cut by multi row

Name Description Default value Available options

bottom

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

top

topBottomOrder

value

Formula or question ID / alias

 row cutByDate
Data Grid cut by date row

Name Description Default value Available options

align

Set this property to true if date range should be aligned

true | false

breakdownBy

year

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

value

Formula or question ID / alias

 row cutByOverlappingDate
Data Grid cut by overlapping date row

Name Description Default value Available options

align

Set this property to true if date range should be aligned

true | false

breakdownBy

year

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

value

Formula or question ID / alias

 row
Data Grid row

Name Description Default value Available options

format

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

 row comparison
Crosstab comparison row

Name Description Default value Available options

exportLevelsDepth

Count of expanded hierarchy levels for export

format

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

mode

Overrides hierachy mode for this row

direct | rollup | mixed

nodeIds

Changes the reporting hierarchy nodes from default / selected in the filter to particular nodes

reportingHierarchy

Name of hierarchy configuration

requestTotal [Beta]

true | false

showTotal

Enables total

true

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

 row selectedHierarchy
Crosstab selectedHierarchy row

Name Description Default value Available options

exportLevelsDepth

Count of expanded hierarchy levels for export

format

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

labelSeparator

Crosstab selectedHierarchy row label separator

mode

Overrides hierachy mode for this row

direct | rollup

nodeIds

Changes the reporting hierarchy nodes from default / selected in the filter to particular nodes

reportingHierarchy

Name of hierarchy configuration

showTotal

Enables total

true

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

 row selectedFlat
Data Grid selectedFlat row

Name Description Default value Available options

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

labelSeparator

Crosstab selectedHierarchy row label separator

labelStyle

Hierarchy label display style. Has two options: nodeOnly and fullPath

fullPath

nodeOnly | fullPath

mode

Overrides hierachy mode for this row

direct | rollup

nodeIds

Changes the reporting hierarchy nodes from default / selected in the filter to particular nodes

reportingHierarchy

Name of hierarchy configuration

showTotal

Enables total

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.

columns questions

Crosstab questions in columns position

Name

Description

Default value

Available options

Data Grid column

Data Grid cut column

Data Grid cut by multi column

Data Grid cut by date column

Data Grid cut by overlapping date column

columns splits

Crosstab splits in columns position

Name

Description

Default value

Available options

Data Grid column

Data Grid cut column

Data Grid cut by multi column

Data Grid cut by date column

calculation categoricalMean

Data Grid cut by overlapping date column

filters

Set of filter expressions

calculations

Calculation settings used to create cell definition for dataGrid

Name

Description

Default value

Available options

calculation count

Crosstab count calculation

calculation percentage

Crosstab percentage share calculation

calculation mean

Crosstab numerical mean calculation

Crosstab categorical mean calculation

calculation categoricalStandardError

Crosstab categorical standard error calculation

calculation categoricalStandardDeviation

Crosstab categorical standard deviation calculation

calculation median

Crosstab median calculation

calculation sum

Crosstab sum calculation

calculation min

Crosstab min calculation

calculation max

Crosstab max calculation

calculation stddev

Crosstab standard deviation calculation

calculation stderr

Crosstab standard error calculation

calculation nps

Crosstab nps calculation

 calculation count
Crosstab count calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

0

postfix

 calculation percentage
Crosstab percentage share calculation

Name Description Default value Available options

format

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

percentDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation mean
Crosstab numerical mean calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation categoricalMean
Crosstab categorical mean calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation categoricalStandardError
Crosstab categorical standard error calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

 calculation categoricalStandardDeviation
Crosstab categorical standard deviation calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

 calculation median
Crosstab median calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation sum
Crosstab sum calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation min
Crosstab min calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation max
Crosstab max calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation stddev
Crosstab standard deviation calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation stderr
Crosstab standard error calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

 calculation nps
Crosstab nps calculation

Name Description Default value Available options

format

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

floatDefaultFormatter

label

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

numberDecimals

2

postfix

significanceTesting

Crosstab significance testing options

Name

Description

Default value

Available options

compare

Comparison mode for significance testing, 'parent' will compare among the hierarchy, 'next', 'first', 'last', 'previous' - compares column or row with next/first/etc column or row. 'adjacent' compares column with adjacent column. (Same as 'previous', preserved for compatability reasons),

confidenceLevels

Significance testing confidence levels

80 | 90 | 95 | 98 | 99 | 99.8

dimension

Axis for significance testing: 'rows' or 'columns'

rows | columns

results

Result format for significance testing: 'positive', 'negative' or 'both'

default

positive | negative | both | default

threshold

Sample threshold for significance test evaluation. If the value is specified then a test is not computed for smaller samples.

type

Crosstab significance test type

Z | T

benchmark

Crosstab benchmark options

rank

Crosstab rank options

correlation

Crosstab correlation options

settings

Crosstab settings that user has defined and from which dataGrid will be created

Name

Description

Default value

Available options

exportable

This activates the possibility for the user to download the widget content as a Microsoft Excel (.xslx) file.

true

true | false

isHierarchyMode

false

true | false

removeEmptyColumns

Use this property to remove from the results all columns that contain no data (true | false).

false

true | false

removeEmptyRows

Use this property to remove from the results all rows that contain no data (true | false).

false

true | false

showCode

true

true | false

showSplitsLabel

true

true | false

showUnweightedBase

Crosstab unweighted base options

true | false

showWeightedBase

Crosstab weighted base options

true | false

tableKey

tableKeyForEachTable

Show table keys for each table

false

true | false

total

Total position

none

none | first | last

totalLabel

Total label

Total

useWeights

This property holds a list of the weights that are to be used by default.

rows questions

Crosstab questions in rows position

rows splits

Crosstab splits in rows position

columns questions

Crosstab questions in columns position

columns splits

Crosstab splits in columns position

filters

Set of filter expressions

calculations

Calculation settings used to create cell definition for dataGrid

significanceTesting

Crosstab significance testing options

benchmark

Crosstab benchmark options

rank

Crosstab rank options

correlation

Crosstab correlation options

rows questions

Crosstab questions in rows position

Name

Description

Default value

Available options

Data Grid cut row

Data Grid cut by multi row

Data Grid cut by date row

Data Grid cut by overlapping date row

Data Grid row

row cut

Data Grid cut row

Name Description Default value Available options

bottom

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

top

topBottomOrder

value

Formula or question ID / alias

row cutByMulti

Data Grid cut by multi row

Name Description Default value Available options

bottom

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

top

topBottomOrder

value

Formula or question ID / alias

row cutByDate

Data Grid cut by date row

Name Description Default value Available options

align

Set this property to true if date range should be aligned

true | false

breakdownBy

year

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

value

Formula or question ID / alias

row cutByOverlappingDate

Data Grid cut by overlapping date row

Name Description Default value Available options

align

Set this property to true if date range should be aligned

true | false

breakdownBy

year

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

value

Formula or question ID / alias

row

Data Grid row

Name Description Default value Available options

format

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

rows splits

Crosstab splits in rows position

Name

Description

Default value

Available options

Data Grid cut row

Data Grid cut by multi row

Data Grid cut by date row

Data Grid cut by overlapping date row

Data Grid row

row comparison

Crosstab comparison row

row selectedHierarchy

Crosstab selectedHierarchy row

row selectedFlat

Data Grid selectedFlat row

row cut

Data Grid cut row

Name Description Default value Available options

bottom

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

top

topBottomOrder

value

Formula or question ID / alias

row cutByMulti

Data Grid cut by multi row

Name Description Default value Available options

bottom

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

top

topBottomOrder

value

Formula or question ID / alias

row cutByDate

Data Grid cut by date row

Name Description Default value Available options

align

Set this property to true if date range should be aligned

true | false

breakdownBy

year

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

value

Formula or question ID / alias

row cutByOverlappingDate

Data Grid cut by overlapping date row

Name Description Default value Available options

align

Set this property to true if date range should be aligned

true | false

breakdownBy

year

categories

Filter for categories used

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

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

true

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.

value

Formula or question ID / alias

row

Data Grid row

Name Description Default value Available options

format

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

row comparison

Crosstab comparison row

Name Description Default value Available options

exportLevelsDepth

Count of expanded hierarchy levels for export

format

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

mode

Overrides hierachy mode for this row

direct | rollup | mixed

nodeIds

Changes the reporting hierarchy nodes from default / selected in the filter to particular nodes

reportingHierarchy

Name of hierarchy configuration

requestTotal [Beta]

true | false

showTotal

Enables total

true

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

row selectedHierarchy

Crosstab selectedHierarchy row

Name Description Default value Available options

exportLevelsDepth

Count of expanded hierarchy levels for export

format

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

labelSeparator

Crosstab selectedHierarchy row label separator

mode

Overrides hierachy mode for this row

direct | rollup

nodeIds

Changes the reporting hierarchy nodes from default / selected in the filter to particular nodes

reportingHierarchy

Name of hierarchy configuration

showTotal

Enables total

true

true | false

sortBy

Path to column that data should be sorted by.

sortOrder

Sort order

none | ascending | descending

row selectedFlat

Data Grid selectedFlat row

Name Description Default value Available options

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

height

Row height in CSS units (px - pixels, mm - millimeters, cm - centimeters, in - inches, rem). Minimum value is 40px

hide

Use this property to remove header from widget response.

false

true | false

label

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

labelSeparator

Crosstab selectedHierarchy row label separator

labelStyle

Hierarchy label display style. Has two options: nodeOnly and fullPath

fullPath

nodeOnly | fullPath

mode

Overrides hierachy mode for this row

direct | rollup

nodeIds

Changes the reporting hierarchy nodes from default / selected in the filter to particular nodes

reportingHierarchy

Name of hierarchy configuration

showTotal

Enables total

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.

columns questions

Crosstab questions in columns position

Name

Description

Default value

Available options

Data Grid column

Data Grid cut column

Data Grid cut by multi column

Data Grid cut by date column

Data Grid cut by overlapping date column

columns splits

Crosstab splits in columns position

Name

Description

Default value

Available options

Data Grid column

Data Grid cut column

Data Grid cut by multi column

Data Grid cut by date column