Script to set Bar and Line for different Series in CombinationChart

[Chung-Kan Huang]

Hi,

I have a combination chart currently setup using Series with follow custom expression

 

The numbers of series could change depend on the filter configuration.

I want to write a script that could loop through the series in a combination chart and set those data with Axis.Default.Names equal to "Obs" to Lines and "Model" to Bars.

Would it be possible

 

Thanks,

 

Kan

[Donald Johnson]

What TIBCO product are you referring to

[Khushboo Rabadia]

You can setup ironpython script as below

## import the necessary namespaces

from Spotfire.Dxp.Application.Visuals import *

 

#visual is a script parameter that contains your combination chart.

 

vc = visual.As[CombinationChart]()

vc.IndexedSeriesType.Clear()

vc.IndexedSeriesType.Item["Obs"]= CombinationChartSeriesType.Line

vc.IndexedSeriesType.Item["Model"]= CombinationChartSeriesType.Bar

[Janos Novits]

For me unfortunately it doesnt work.

IT doesnt change the type on the viz, but only on the legend.

[David Boot-Olazabal]

Hi Janos,

 

A slightly different code worked for me:

## import the necessary namespaces

from Spotfire.Dxp.Application.Visuals import CombinationChart,CombinationChartSeriesType

#visual is a script parameter that contains your combination chart.

vc = visual.As[CombinationChart]()

vc.SeriesType = CombinationChartSeriesType.Bar

vc.IndexedSeriesType.Item["Sales"]= CombinationChartSeriesType.Bar

vc.IndexedSeriesType.Item["Share"]= CombinationChartSeriesType.Line

But you have to make sure (at least that was the case for me) that your Y axis columns are only one word. I had to rename my Class Sales column to Sales in order to have it work.

Kind regards,

David