Table of Contents

• Overview
• Basic Usage
• Attributes
• DSL Configuration
• Examples

Overview

The <rb-pivot-table> component renders an interactive pivot table for multi-dimensional data analysis. Users can drag and drop fields, change aggregations, and filter data.

FlowKraft Apps: The FlowKraft Frontend App has this component pre-configured. Just paste your embed code from the Usage tab—no script setup required. See FlowKraft Frontend App for details.

Basic Usage

<rb-pivot-table
  report-code="sales-analysis"
  api-base-url="http://localhost:9090/api/jobman/reporting">
</rb-pivot-table>

Attributes

DSL Configuration

Pivot table configuration is defined in ReportBurster using a Groovy DSL.

Basic Structure

pivotTable {
    rows 'Region', 'Product'
    cols 'Quarter'
    vals 'Revenue'
    aggregatorName 'Sum'
    rendererName 'Table'
}

Configuration Reference

Aggregators

• Count - Count of records
• Count Unique Values - Distinct count
• Sum - Total of values
• Integer Sum - Rounded sum
• Average - Mean value
• Median - Middle value
• Minimum - Lowest value
• Maximum - Highest value
• Sum as Fraction of Total - Percentage of total
• Sum as Fraction of Rows - Percentage of row
• Sum as Fraction of Columns - Percentage of column

Renderers

• Table - Standard table
• Table Heatmap - Colored by value
• Table Col Heatmap - Colored by column
• Table Row Heatmap - Colored by row

Value Filters

pivotTable {
    rows 'Region'
    cols 'Quarter'
    vals 'Revenue'
    aggregatorName 'Sum'
    
    valueFilter {
        filter 'Status', exclude: ['Cancelled', 'Pending']
    }
}

Hidden Attributes

pivotTable {
    rows 'Region'
    cols 'Quarter'
    vals 'Revenue'
    
    hiddenAttributes 'InternalID', 'CreatedAt'
    hiddenFromAggregators 'Region', 'Quarter'
}

Examples

Sales by Region and Product

pivotTable {
    rows 'Region', 'Product'
    cols 'Quarter'
    vals 'Revenue'
    aggregatorName 'Sum'
    rendererName 'Table'
    rowOrder 'key_a_to_z'
}

Order Analysis with Filtering

pivotTable {
    rows 'Category'
    cols 'Year', 'Month'
    vals 'OrderCount'
    aggregatorName 'Sum'
    
    valueFilter {
        filter 'Status', exclude: ['Cancelled']
    }
}

Heatmap View

pivotTable {
    rows 'Department'
    cols 'Month'
    vals 'Expenses'
    aggregatorName 'Sum'
    rendererName 'Table Heatmap'
}