Unrelated Data

Is this your situation? You have two different tables of data with no relationship between them, but yet you want to have one chart which needs to show say two different lines of data, one for each data source.

For the purposes of example, let's say that the tables consists of Widget Production and Defects.

If that is your situation, then here is what I would do. 

I would create a table called Consolidated data. It would include a multiple choice field for the data type (Widget or Defect).

On each of the two respective source tables create a formula equal to either "Widget" or "Defect".

Create two saved table to table imports into the consolidated table, respectively from each of the two tables and populate, the data source field appropriately from the source table formula fields along with any other fidls oyu need.

Create a helper table and create just one record in that table. The purpose of that is to allow the user to click a button to re-populate the consolidated table.

On that single record table, create a formula URL button with tested redirect, which would do the following steps in one click. 

1. Purge the consolidated table

2. Run import #1

3. Run import#2

4. Land the user on the chart. You would need to run the imports manually first to get initial data in to make the chart and you hould be able to have the "series" be the data type (Widget or Defects).

Feel free to post back if you have any additional questions about the syntax of the URL formula button or the set up.