Skip to main content

QueryColumn

Index​

ColumnColumn
QueryColumn.aggregationTypeQueryColumn.calenderGuid
QueryColumn.chartSpecificColumnTypeQueryColumn.columnProperties
QueryColumn.customOrderQueryColumn.dataType
QueryColumn.formatQueryColumn.id
QueryColumn.isMeasureValueQueryColumn.name
QueryColumn.timeBucketQueryColumn.type

Properties​

aggregationType​

aggregationType: ColumnAggregationType

Optional

Aggregation applied on the column data

calenderGuid​

calenderGuid: string

Optional

Guid of Custom calender for the column if defined in worksheet else null

chartSpecificColumnType​

chartSpecificColumnType: ChartSpecificColumnType

Type of arbitrary column, can be measure names or measure values also, unknown if regular column

columnProperties​

columnProperties: {conditionalFormatting?: Maybe< ConditionalFormatting > , numberFormatting?: Maybe< FormatConfig > }

Optional

Column Properties of the columns

Parameters

conditionalFormatting​

conditionalFormatting: Maybe

Optional

numberFormatting​

numberFormatting: Maybe

Optional

customOrder​

customOrder: string[]

Optional

Custom sort order defined for the column to sort charts in a specific order Defined in worksheet

dataType​

dataType: DataType

Type of data for the column

format​

format: ColumnFormat

Optional

Formatting for the columns defined in the worksheet

id​

id: string

Column ID

isMeasureValue​

isMeasureValue: boolean

Optional

Flag to identify if the column is a measure value, to be used along with MEASURE_NAME/MEASUE_VALUE column in the query

name​

name: string

Column name property

timeBucket​

timeBucket: ColumnTimeBucket

Type of the time-based aggregation when the column data is of type Date, Datetime, Time

type​

type: ColumnType

Type of column if attribute or measure