Jump to content

Can i set trellis by different table's column

Wonseon LEE

Recommended Posts

As Kirsten wrote, the main table used in the plot needs to have the column that you want to split/group by (in this case trellis). One way is to add (join) such a column to the table you are already using. Another way though, which may or not may not work depending on what your data looks like and what kind of aggregations you are using to display it, is to do it the other way around:


Use the other table as the main data table in the plot, trellis using the column in that data table, and then pull in the (aggregated) measures from one or more secondary tables. For example Avg([TableA].[someColumn]), Median([TableB].[YetAnotherColumn]). For this to work, you need to configure Column Matches between the main data table and any tables you wish to pull in aggregated measures from. In some cases, the aggregation method First() is quite handy, if the data was already "aggregated" as one single value.


That way, you are performing a kind of "live join" in that plot during rendering, rather than an explicit join in the data canvas.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...