v5.20192.624
|

CubePivotField Class

Extends the PivotField class to represent a field in a server-based cube data source.

Hierarchy

Constructors

constructor

  • Initializes a new instance of the CubePivotField class.

    Parameters

    • engine: PivotEngine

      PivotEngine that owns this field.

    • binding: string

      Property that this field is bound to.

    • Optional header: string

      Header shown to identify this field (defaults to the binding).

    • Optional options: any

      JavaScript object containing initialization data for the field.

    Returns CubePivotField

Properties

aggregate

aggregate: Aggregate

Gets or sets how the field should be summarized.

The default value for this property is Aggregate.Sum for numeric fields, and Aggregate.Count for other field types.

binding

binding: string

Gets or sets the name of the property the field is bound to.

collectionView

collectionView: ICollectionView

Gets the ICollectionView bound to this field.

dataType

dataType: DataType

Gets or sets the data type of the field.

descending

descending: boolean

Gets or sets a value that determines whether keys should be sorted in descending order for this field.

The default value for this property is false.

dimensionType

dimensionType: DimensionType

Gets or sets the dimension type of the field.

engine

engine: PivotEngine

Gets a reference to the PivotEngine that owns this PivotField.

filter

filter: PivotFilter

Gets a reference to the PivotFilter used to filter values for this field.

For measure fields in cube data sources, the filter is applied to aggregated cell values. For measure fields in non-cube data sources, the filter is applied to the raw data.

format

format: string

Gets or sets the format to use when displaying field values.

The default value for this property is 'd' for date fields, 'n0' for numeric fields, and the empty string for other field types.

getValue

getValue: Function

Gets or sets a function to be used for retrieving the field values.

This property is set to null by default, causing the engine to use the field's binding property to retrieve the value.

If specified, the function should take a single parameter that represents the data item being evaluated and should return the calculated value for the item.

Example

header

header: string

Gets or sets a string used to represent this field in the user interface.

isActive

isActive: boolean

Gets or sets a value that determines whether this field is currently being used in the view.

Setting this property to true causes the field to be added to the view's PivotEngine.rowFields or PivotEngine.valueFields, depending on the field's data type.

isContentHtml

isContentHtml: boolean

Gets or sets a value indicating whether items in this field contain HTML content rather than plain text.

The default value for this property is false.

isMeasure

isMeasure: boolean

Overridden to account for the dimension type.

key

key: string

Gets the key for this CubePivotField.

For this type of field, the key is the field's binding.

parentField

parentField: PivotField

Gets this field's parent field.

When you drag the same field into the Values list multiple times, copies of the field are created so you can use the same binding with different parameters. The copies keep a reference to their parent fields.

showAs

showAs: ShowAs

Gets or sets a value that specifies how to display the aggregate value.

Options for this property are defined by the ShowAs enumeration and include differences between the value and the one in the previous row or column, percentages over the row, column, or grand total, and running totals.

This property is similar to the Show Values As feature in Excel.

The default value for this property is ShowAs.NoCalculation.

sortComparer

sortComparer: Function

Gets or sets a function used to compare values when sorting.

If provided, the sort comparer function should take as parameters two values of any type, and should return -1, 0, or +1 to indicate whether the first value is smaller than, equal to, or greater than the second. If the sort comparer returns null, the standard built-in comparer is used.

This sortComparer property allows you to use custom comparison algorithms that in some cases result in sorting sequences that are more consistent with user's expectations than plain string comparisons.

The example below shows a typical use for the sortComparer property:

// define list of products
app.products = 'Wijmo,Aoba,Olap,Xuni'.split(',');

// sort products by position in the 'app.products' array
ng.viewDefinitionChanged.addHandler(function () {
  var fld = ng.fields.getField('Product');
  if (fld) {
    fld.sortComparer = function (val1, val2) {
      return app.products.indexOf(val1) - app.products.indexOf(val2);
    }
  }
});

subFields

subFields: PivotField[]

Gets this field's child fields.

visible

visible: boolean

Gets or sets a value indicating whether this field should be displayed in instances of the PivotPanel control.

The default value for this property is true.

Setting this property to false hides the field any PivotPanel controls, preventing users from adding, removing, or changing the the field position in the engine's view definition.

weightField

weightField: PivotField

Gets or sets the PivotField used as a weight for calculating aggregates on this field.

If this property is set to null, all values are assumed to have weight one.

This property allows you to calculate weighted averages and totals. For example, if the data contains a 'Quantity' field and a 'Price' field, you could use the 'Price' field as a value field and the 'Quantity' field as a weight. The output would contain a weighted average of the data.

width

width: number

Gets or sets the preferred width to be used for showing this field in user interface controls such as the PivotGrid.

wordWrap

wordWrap: boolean

Gets or sets a value that indicates whether the content of this field should be allowed to wrap within cells.

The default value for this property is false.

Methods

onPropertyChanged

Events

propertyChanged

propertyChanged: Event

Occurs when the value of a property in this Range changes.