I am using a external data connection to build a visualization, in the DB there are two tables I am using in my Spotfire doc. I have a main table I use to build the bulk of the visualization, but in a specific vis.
I am trying to plot a "trend line" with static values that I have put into a different table in my DB. I have built the line in Lines/Curves but it does not show up in my visualization and I am not getting an error.
Any idea what I could be doing wrong????
Trend lines are really made to by dynamic and based off the underlying data, usually through some mathematical computation. Since you are using two tables, I would use a combination chart instead. In both cases, the two tables would need what ever column you are using on your X axis, in both tables, so you can relate them.
Right Click > Switch Visualization To > Combination Chart. Then on your vertical axis, put the data from your second table. You'll need to set this up in the Series by as well. Right Click > Series > Click on New Table and change Type to Line. Lastly (or first if you want), manage relations via Edit > Data Table Properties > Relations.