Use data from multiple tables

Hello all,

I'm using the online version of Spotfire (TIBCO® Spotfire® 7.6.0 HF-007).

I have dashboards using multiple tables and I'd like to be able to use calculated fields by using data from another table.

I have for example 2 tables:
jan17
feb17

In feb17 I'd like to add a calculated column using fields from jan17 (ex: to see the difference in sales volume). Each time I try to call a function referring to the other file, I get an error message saying that the table is not known.

Ex:
If I use DateDiff('day',jan17.[Date],feb17.[Date])
I get: the table jan17 could not be found

Any idea of how I could do this?

Thanks
Laurent

(2) Answers

Login