Finding Previous value in bar chart spotfire

(Sum([PRINCIPALAMTINTRADECURR]) - Sum([PRINCIPALAMTINTRADECURR]) OVER (Previous([Axis.X]))) / Sum([PRINCIPALAMTINTRADECURR]) OVER (Previous([Axis.X]))

Data table with stored procedure (with parameter) in spotfire

You can use stored procedure in information link instead elements in Information Link, Note: we cannot find the parameters in information link when you create but, when you add this info link through "Data on Demand" it prompt you to assign parameter values. Steps below Information Designer: 1. Data source: Expand Server->schema -> procedure name (right click) -> New -> Procedure (save) 2. Library (Element tab): Saved procedure (right click) ->New-> Information Link (Save) File ->Add On-Demand data Table -> choose Information link ->define Input for each parameter (fixed value/property/expression/marking etc)

Axis zoom range in Scatter plot spotfire

from Spotfire.Dxp.Application.Visuals import AxisRange from Spotfire.Dxp.Application.Visuals import ScatterPlot for vis in Application.Document.ActivePageReference.Visuals: if vis.Title == "Alerts": MyChart = vis.As[ScatterPlot]() MyChart.XAxis.ZoomRange = AxisRange(StartDate,EndDate); MyChart.YAxis.ZoomRange = AxisRange.DefaultRange;

Choose different column as Axis based on parameter value in Tibco Spotfire

case "${Column}" when "EXECUTION" then [LONG_EXECUTION] when "EXEVOLUME" then [VOLUME] when "COUNT" then [LONG_COUNT] end as [${Column}]