Am creating a bar chart in spotfire and would like to plot a line on top of the chart that acts as a trend line but need to manually enter the data points. Is there a way to do so? Have not found any documentation on such thing. Would really appreciate some help with this!! Thanks!
Since the points will be static, I would put the points in a column in excel and embed the data into your analysis. Then you can change your chart type to combination (line and bar) and plot your newly added data as a line.
You will need a column in both tables which will be used as the relation and set up the relation via Edit > Data Table Properties > Relations.
Relations are like keys to link two separate data sources. In database terms, it's a KEY. For example, take a look at THIS MODEL. These tables are related based off the Activity Code.
Here are some other helpful references.
https://docs.tibco.com/pub/spotfire/7.0.1/doc/html/md/md_working_with_data_tables.htm
