(Sum([PRINCIPALAMTINTRADECURR]) - Sum([PRINCIPALAMTINTRADECURR]) OVER (Previous([Axis.X]))) / Sum([PRINCIPALAMTINTRADECURR]) OVER (Previous([Axis.X]))
Mar 31, 2014
Mar 24, 2014
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)
Mar 21, 2014
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;
Mar 12, 2014
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}]
Subscribe to:
Posts (Atom)