TopNFilterBuilder class

Pacote:

powerbi-client

Componente do construtor de filtros Top N do Power BI

Extends

FilterBuilder

Propriedades herdadas

target

Métodos

bottom(number)	Define Inferior como operador para o filtro N Superior const topNFilterBuilder = new TopNFilterBuilder().bottom(itemCount);
build()	Cria o filtro N Superior const topNFilterBuilder = new TopNFilterBuilder().build();
orderByTarget(ITarget)	Define a ordem para o filtro N Superior const topNFilterBuilder = new TopNFilterBuilder().orderByTarget(target);
top(number)	Define Top como operador para o filtro N Superior const topNFilterBuilder = new TopNFilterBuilder().top(itemCount);

Métodos herdados

withColumnAggregation(string, string, string)	Define a propriedade de destino para filtro com objeto de destino de agregação de coluna const filterBuilder = new FilterBuilder().withColumnAggregation(tableName, columnName, aggregationFunction);
withColumnTarget(string, string)	Define a propriedade de destino para filtro com objeto de destino de coluna const filterBuilder = new FilterBuilder().withColumnTarget(tableName, columnName);
withHierarchyLevelAggregationTarget(string, string, string, string)	Define a propriedade de destino para filtro com objeto de destino de agregação de nível de hierarquia const filterBuilder = new FilterBuilder().withHierarchyLevelAggregationTarget(tableName, hierarchy, hierarchyLevel, aggregationFunction);
withHierarchyLevelTarget(string, string, string)	Define a propriedade de destino para filtro com objeto de destino no nível da hierarquia const filterBuilder = new FilterBuilder().withHierarchyLevelTarget(tableName, hierarchy, hierarchyLevel);
withMeasureTarget(string, string)	Define a propriedade de destino para filtro com objeto de destino de medida const filterBuilder = new FilterBuilder().withMeasureTarget(tableName, measure);
withTargetObject(IFilterTarget)	Define a propriedade de destino para filtro com objeto de destino const target = { table: 'table1', column: 'column1' }; const filterBuilder = new FilterBuilder().withTargetObject(target);

Detalhes das propriedades herdadas

target

target: IFilterTarget

Valor da propriedade

IFilterTarget

Herdado deFilterBuilder.target

Detalhes do método

bottom(number)

Define Inferior como operador para o filtro N Superior

const topNFilterBuilder = new TopNFilterBuilder().bottom(itemCount);

function bottom(itemCount: number): TopNFilterBuilder

Parâmetros

itemCount

number

Retornos

TopNFilterBuilder

build()

Cria o filtro N Superior

const topNFilterBuilder = new TopNFilterBuilder().build();

function build(): TopNFilter

Retornos

TopNFilter

orderByTarget(ITarget)

Define a ordem para o filtro N Superior

const topNFilterBuilder = new TopNFilterBuilder().orderByTarget(target);

function orderByTarget(target: ITarget): TopNFilterBuilder

Parâmetros

target

ITarget

Retornos

TopNFilterBuilder

top(number)

Define Top como operador para o filtro N Superior

const topNFilterBuilder = new TopNFilterBuilder().top(itemCount);

function top(itemCount: number): TopNFilterBuilder

Parâmetros

itemCount

number

Retornos

TopNFilterBuilder

Detalhes do método herdado

withColumnAggregation(string, string, string)

Define a propriedade de destino para filtro com objeto de destino de agregação de coluna

const filterBuilder = new FilterBuilder().withColumnAggregation(tableName, columnName, aggregationFunction);

function withColumnAggregation(tableName: string, columnName: string, aggregationFunction: string): TopNFilterBuilder

Parâmetros

tableName

string

columnName

string

aggregationFunction

string

Retornos

TopNFilterBuilder

Herdado deFilterBuilder.withColumnAggregation

withColumnTarget(string, string)

Define a propriedade de destino para filtro com objeto de destino de coluna

const filterBuilder = new FilterBuilder().withColumnTarget(tableName, columnName);

function withColumnTarget(tableName: string, columnName: string): TopNFilterBuilder

Parâmetros

tableName

string

columnName

string

Retornos

TopNFilterBuilder

Herdado deFilterBuilder.withColumnTarget

withHierarchyLevelAggregationTarget(string, string, string, string)

Define a propriedade de destino para filtro com objeto de destino de agregação de nível de hierarquia

const filterBuilder = new FilterBuilder().withHierarchyLevelAggregationTarget(tableName, hierarchy, hierarchyLevel, aggregationFunction);

function withHierarchyLevelAggregationTarget(tableName: string, hierarchy: string, hierarchyLevel: string, aggregationFunction: string): TopNFilterBuilder

Parâmetros

tableName

string

hierarchy

string

hierarchyLevel

string

aggregationFunction

string

Retornos

TopNFilterBuilder

Herdado deFilterBuilder.withHierarchyLevelAggregationTarget

withHierarchyLevelTarget(string, string, string)

Define a propriedade de destino para filtro com objeto de destino no nível da hierarquia

const filterBuilder = new FilterBuilder().withHierarchyLevelTarget(tableName, hierarchy, hierarchyLevel);

function withHierarchyLevelTarget(tableName: string, hierarchy: string, hierarchyLevel: string): TopNFilterBuilder

Parâmetros

tableName

string

hierarchy

string

hierarchyLevel

string

Retornos

TopNFilterBuilder

Herdado deFilterBuilder.withHierarchyLevelTarget

withMeasureTarget(string, string)

Define a propriedade de destino para filtro com objeto de destino de medida

const filterBuilder = new FilterBuilder().withMeasureTarget(tableName, measure);

function withMeasureTarget(tableName: string, measure: string): TopNFilterBuilder

Parâmetros

tableName

string

measure

string

Retornos

TopNFilterBuilder

Herdado deFilterBuilder.withMeasureTarget

withTargetObject(IFilterTarget)

Define a propriedade de destino para filtro com objeto de destino

const target = {
 table: 'table1',
 column: 'column1'
};

const filterBuilder = new FilterBuilder().withTargetObject(target);

function withTargetObject(target: IFilterTarget): TopNFilterBuilder

Parâmetros

target

IFilterTarget

Retornos

TopNFilterBuilder

Herdado deFilterBuilder.withTargetObject