Sorting a Graphical Table visualization in Spotfire® using IronPython

Introduction

This example demonstrates how to set the sort order in a Graphical Table visualization

Code Sample

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

from Spotfire.Dxp.Application.Visuals.Miniatures import GraphicalTable
from Spotfire.Dxp.Application.Visuals import *

gt = MyGraphTable.As[GraphicalTable]()
for col in gt.Columns:
  if col.Title == "Sales":
  sort_info = vi.SortInfos.TryGetSortInfo(col)
  if str(sort_info[1].SortMode) == "Ascending":
    sort_info[1].SortMode=TablePlotColumnSortMode.Descending
  else:
    sort_info[1].SortMode=TablePlotColumnSortMode.Ascending

#MyGraphTable - Graphical table visualization script parameter

References

• GraphicalTableColumnSortInfoCollection

License: TIBCO BSD-Style License