I am often in a position where I would like to compare data from two tables.
Say for example, one table was my Estimations table, where I have many entries where I forecasted the result of something.
In a separate table, I have my Records, where I recorded the results of entries.
If I wanted to map those those table together, there is no way to do so. The only solution is to merge those two tables into one single table.
This would be fine if the data was used in exactly the same way (all of it’s subsequent columns were doing the same things to the data), or the columns were simple, but this is not the case. I calculate different things on my Estimates than my Results.
The solution for this would be permitting Multi-Table Charts, where I select:
Table 1 X, Y, Grouping
Table 2 X, Y, Grouping
X Value Table 1: COL, Table 2: COL
Y Value Table 1: COL, Table 2: COL
This would allow for much more powerful data comparison, and would not require me to try to merge different data into one table for the sake of charting-only.