Subscribe to feed

 

Creating a Summary Table

Code example explaining how to set up summary tables.

Refer to What is a Summary Table? for a summary table presentation.

Create and Configure a Summary Table Plot

public static void CreateSummaryTable(AnalysisApplication application)
{
    // Add a summary table to the page
    SummaryTable summaryTable = application.Document.ActivePageReference.Visuals.AddNew<SummaryTable>();
    summaryTable.Title = "Basic Summary Table";

    // Connect the summary table to data
    DataManager dataManager = application.Document.Data;
    summaryTable.Data.DataTableReference = dataManager.Tables.DefaultTableReference;

    // Set filtering for the visualization
    summaryTable.Data.UseActiveFiltering = true;

    // Set marking for the visualization
    summaryTable.Data.MarkingReference = dataManager.Markings.DefaultMarkingReference;

    // Add aggregations
    summaryTable.Aggregations.Clear();
    SummaryTableAggregationColumn aggSum = summaryTable.Aggregations.AddNew("Sum");
    SummaryTableAggregationColumn aggAvg = summaryTable.Aggregations.AddNew("Avg");
    SummaryTableAggregationColumn aggMedian = summaryTable.Aggregations.AddNew("Median");
    SummaryTableAggregationColumn aggUniqueConcatenate = summaryTable.Aggregations.AddNew("UniqueConcatenate");

    // Add columns
    summaryTable.Columns.AddNew("Sales");
    summaryTable.Columns.AddNew("Cost");
    summaryTable.Columns.AddNew("Type");
    summaryTable.Columns.AddNew("Category");

    // sort columns by sum
    summaryTable.SortColumns.Set(aggSum, Spotfire.Dxp.Data.SortOrder.Ascending);
}