How to add Statistical Measures to the Summary Plot in Spotfire® Using IronPython Scripting

Back to main IronPython scripting page

Introduction

This article includes a Code Sample which shows you how to programmatically add Statistical Measures to the Summary Plot. 

Code Sample

# Copyright © 2017. TIBCO Software Inc. Licensed under TIBCO BSD-style license.

from Spotfire.Dxp.Application.Visuals import *
from Spotfire.Dxp.Data import *

viz = Application.Document.ActivePageReference.Visuals.AddNew[SummaryTable]() 
dataTable = Document.Data.Tables["SalesAndMarketing"]
viz.Data.DataTableReference=dataTable 
viz.Title = "Summary Table" 

#Add Columns to the Summary Table
viz.Columns.AddNew("Rank")
viz.Columns.AddNew("Store ID")

# Add Statistical Measures to the Summary Table
viz.Aggregations.AddNew("Sum") 
viz.Aggregations.AddNew("Median") 
viz.Aggregations.AddNew("Max")

References

• API Reference: SummaryTable Class
• API Reference: SummaryTable.Aggregations Property

BSD License