Visualizations using and combining any data columns as chart axis (x, y, z, color, trellis, size, shape, ...) across relational data tables

Hi All:

One of the most important weakness of Spotfire is that combining data columns from different related data tables in a visualization is not effectively enabled.

For example: I have three tables.  The table "Cars" lists each car my company owns. The table "People" lists all the people in my company. the table "Rides" lists each ride that people in my company have taken with the company cars.

I now want to make a scatter plot showing the length of each ride in miles (Y), the date of the ride (X), color coded by the job title of the person taking the ride, and trellised by the type of car used. I want to do this without having to create a new table in which I merge all of this information first. I just want to use the three tables Cars, People, and Rides as they are loaded in Spotfire.

Basically, the request is that once tables in a data schema have established relationships, visualizations allow selecting and combining any data column across these related data tables as chart axis (x, y, z, color, trellis, size, shape, ...) without restrictions and without the need of creating merged tables first.