or run

npx @tessl/cli init
Log in

Version

Tile

Overview

Evals

Files

docs

authorization.mdcharts.mdcompiler.mdconditional-formatting.mddashboards.mddbt.mdee-features.mdexplore-fields.mdfilters.mdformatting.mdindex.mdmetric-queries.mdparameters.mdpivot.mdprojects-spaces.mdsql-runner.mdtemplating.mdtypes.mdutilities.mdvisualizations.mdwarehouse.md
tile.json

pivot.mddocs/

Pivot Tables

Pivot table configuration and query result transformation.

Types

interface PivotConfig {
  pivotDimensions: string[];
  metricsAsRows: boolean;
  columnOrder?: string[];
  hiddenMetricFieldIds?: string[];
  columnTotals?: boolean;
  rowTotals?: boolean;
}

Functions

function getPivotConfig(
  savedChart: Pick<CreateSavedChartVersion, 'chartConfig' | 'pivotConfig' | 'tableConfig'>
): PivotConfig | undefined;

function pivotQueryResults(args: PivotQueryResultsArgs): PivotData;

function derivePivotConfigurationFromChart(
  savedChart: SavedChartDAO,
  metricQuery: MetricQuery,
  itemsMap: ItemsMap
): PivotConfiguration | undefined;