Internal Architecture Details

/**
 * Internal pivot table rendering component
 * Handles the actual pivot table display and interaction
 * Note: This is an internal component, not exported from the public API
 */
// Internal: PivotTable component from react-pivottable library

/**
 * Internal collection of aggregation function templates
 * Each template returns a configured aggregation function
 * Note: This is internal to the plugin, not exported from the public API
 */
// Internal: aggregatorTemplates from react-pivottable utilities

interface AggregatorTemplates {
  /** Count of non-null values */
  count: (formatter: NumberFormatter) => AggregatorFunction;
  /** Count of unique values */
  countUnique: (formatter: NumberFormatter) => AggregatorFunction;
  /** List unique values separated by delimiter */
  listUnique: (separator: string, formatter: NumberFormatter) => AggregatorFunction;
  /** Sum of numeric values */
  sum: (formatter: NumberFormatter) => AggregatorFunction;
  /** Average of numeric values */
  average: (formatter: NumberFormatter) => AggregatorFunction;
  /** Median of numeric values */
  median: (formatter: NumberFormatter) => AggregatorFunction;
  /** Sample variance calculation */
  var: (ddof: number, formatter: NumberFormatter) => AggregatorFunction;
  /** Sample standard deviation calculation */
  stdev: (ddof: number, formatter: NumberFormatter) => AggregatorFunction;
  /** Minimum value */
  min: (formatter: NumberFormatter) => AggregatorFunction;
  /** Maximum value */
  max: (formatter: NumberFormatter) => AggregatorFunction;
  /** First non-null value */
  first: (formatter: NumberFormatter) => AggregatorFunction;
  /** Last non-null value */ 
  last: (formatter: NumberFormatter) => AggregatorFunction;
  /** Fraction calculations relative to total, row, or column */
  fractionOf: (
    numeratorAgg: AggregatorFunction,
    denominatorType: 'total' | 'row' | 'col',
    formatter: NumberFormatter
  ) => AggregatorFunction;
}

import { aggregatorTemplates } from "@superset-ui/plugin-chart-pivot-table/src/react-pivottable";
import { getNumberFormatter } from "@superset-ui/core";

const formatter = getNumberFormatter('.2f');

// Create specific aggregation functions
const aggregators = {
  'Count': aggregatorTemplates.count(formatter),
  'Sum': aggregatorTemplates.sum(formatter),
  'Average': aggregatorTemplates.average(formatter),
  'Sum as % of Total': aggregatorTemplates.fractionOf(
    aggregatorTemplates.sum(),
    'total',
    formatter
  ),
};

/**
 * Sorting utility function
 * Provides natural sorting for pivot table data
 */
export const sortAs: SortFunction;

type SortFunction = (order: string[]) => (a: string, b: string) => number;

import { sortAs } from "@superset-ui/plugin-chart-pivot-table/src/react-pivottable";

// Create custom sort order
const customSort = sortAs(['High', 'Medium', 'Low']);
const sortedData = data.sort((a, b) => customSort(a.priority, b.priority));

/**
 * Factory function that creates all available aggregation functions
 * @param formatter - Number formatter for displaying aggregated values
 * @returns Object containing all aggregation functions
 */
const aggregatorsFactory = (formatter: NumberFormatter) => ({
  /** Count of non-null values */
  'Count': AggregatorFunction;
  /** Count of unique values */
  'Count Unique Values': AggregatorFunction;
  /** List unique values with comma separation */
  'List Unique Values': AggregatorFunction;
  /** Sum of numeric values */
  'Sum': AggregatorFunction;
  /** Average of numeric values */
  'Average': AggregatorFunction;
  /** Median of numeric values */
  'Median': AggregatorFunction;
  /** Sample variance */
  'Sample Variance': AggregatorFunction;
  /** Sample standard deviation */
  'Sample Standard Deviation': AggregatorFunction;
  /** Minimum value */
  'Minimum': AggregatorFunction;
  /** Maximum value */
  'Maximum': AggregatorFunction;
  /** First non-null value */
  'First': AggregatorFunction;
  /** Last non-null value */
  'Last': AggregatorFunction;
  /** Sum as fraction of total */
  'Sum as Fraction of Total': AggregatorFunction;
  /** Sum as fraction of row total */
  'Sum as Fraction of Rows': AggregatorFunction;
  /** Sum as fraction of column total */
  'Sum as Fraction of Columns': AggregatorFunction;
  /** Count as fraction of total */
  'Count as Fraction of Total': AggregatorFunction;
  /** Count as fraction of row total */
  'Count as Fraction of Rows': AggregatorFunction;
  /** Count as fraction of column total */
  'Count as Fraction of Columns': AggregatorFunction;
});

type AggregatorFunction = {
  /** Function to process and aggregate data values */
  (data: DataRecord[], rowKey: string[], colKey: string[]): {
    /** Aggregated numeric value */
    value: number;
    /** Formatted display string */
    format: (value: number) => string;
  };
};

interface NumberFormatter {
  /** Format a number for display */
  (value: number): string;
  /** Formatter ID */
  id: string;
}

import { 
  aggregatorTemplates, 
  PivotTable 
} from "@superset-ui/plugin-chart-pivot-table/src/react-pivottable";
import { getNumberFormatter } from "@superset-ui/core";

const percentFormatter = getNumberFormatter('.1%');
const currencyFormatter = getNumberFormatter('$,.2f');

// Configure pivot table with custom aggregations
const pivotConfig = {
  data: salesData,
  rows: ['region'],
  cols: ['quarter'],
  aggregatorName: 'Sum',
  aggregators: {
    'Sum': aggregatorTemplates.sum(currencyFormatter),
    'Average': aggregatorTemplates.average(currencyFormatter),
    '% of Total': aggregatorTemplates.fractionOf(
      aggregatorTemplates.sum(),
      'total',
      percentFormatter
    ),
  },
  vals: ['amount']
};

interface TableRenderer {
  /** Standard table renderer */
  'Table': ReactComponent;
  /** Table with bars for visual representation */
  'Table Barchart': ReactComponent;
  /** Heatmap table renderer */
  'Table Heatmap': ReactComponent;
  /** Row heatmap renderer */
  'Table Row Heatmap': ReactComponent;
  /** Column heatmap renderer */
  'Table Col Heatmap': ReactComponent;
}