The graphical correlation options enable you to create tables and charts by joining two or more exisiting tables based on a common field. This allows you to enrich table and graph data with information not found only in a single table.
There are four graphical correlation options:
- Cross-Search Graph Diagram
- Cross-Search Table Join
- Cross-Search Sankey Diagram
- Cross-Search Line Chart
The tables must be open and active in order to perform the join. The tables must contain fields with shared values for a join to be possible.
You can access the correlation charts by clicking the gear icon and then selecting Graphical correlation from the query toolbar.