Use data from multiple tables
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:
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.
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?