Search results

FieldOptions

Configures the fields in dataSource.

Properties

axis

string

It allows to set the axis to render the field in it.

baseField

string

It allows to set the base field to aggregate the values.

baseItem

string

It allows to set the base item to aggregate the values.

caption

string

It allows to set field caption.

isCalculatedField

boolean

It allows to show a field has calculated member type. Note: This option is applicable only for OLAP data source.

Defaults to false

isNamedSet

boolean

It allows to show a field has named set type. Note: This option is applicable only for OLAP data source.

Defaults to false

name

string

It allows to set field name.

showNoDataItems

boolean

It allows to display all the items of its field even any items haven’t data in its row/column intersection in data source.

Defaults to false

showSubTotals

boolean

It allows to disable or enable sub totals in row/column axis.

Defaults to true

type

string

It allows to set the summary type of the field. The available types are,

  • Sum: The summary cells calculated by the sum of its cells.
  • Count: The summary cells calculated by the count of its cells.
  • Min: The summary cells shows the value which is the minimum value of its cells.
  • Max: The summary cells shows the value which is the maximum value of its cells.
  • Percentage: The summary cells displays in percentage format.
  • Avg: The summary cells calculated by the average of its cells.
  • CalculatedField: It should set to include calculated fields.

Defaults to Sum