TIBCO Spotfire

Hi, is there any way to show curve fit result in a cross table? E.g. There is a line chart for US GDP from 2000 to 2010, with a curve fit. And I want to show both the actual and curve fit result of every point. Thank you!

Hi,

In order to show external or visual only data you will need to create it first.

Lets assume your data set is:

Year             GDP

2001             3333

2002             4444

... and so on

Now to show in a crosstable the GDP is easy: show sum/avg of GDP Column.

To add curve fit beside it you will need to creat a local custom expression or a global calculated field:

simple example is > create calculated field (menu) : U95([GDP]) as [95% upper]

Now add this new filter to the crosstable and choose calculation method of avg (this will keep the original field value.

Regards,

Eran

Hi, Thank you for your answer. I would like to understand more if my curves show in line chart is aggregated by dynamic expression, and the line fit is based on the aggregated number. I found it is a bit difficult. Also, most of the time i use the curve fit feature, which the equations behind is complex. Any ideas?

Hi,

Aggregations can be pre-calculated as additional columns in your data table.

Please review the OVER extensions to any aggregation formula. In Spotfire Help > Search Tab > Look for "cumulative" it will take you to all examples and usage of calculated aggregations. example sum([value]) over ([Year]) will summarize all values per year; Like you would choose in a line chart year in the X axis and sum(value) in the Y axis. Now when it is in the data you can use it easily in table views (Simple or Cross).

As for the Curve fit formulas I cant help here . In the help you will see how its calculated and then you will need to regenerate (calculations)  by yourself.

 Best Regards,

Eran