I suspect I know the answer to this question, but am hoping that someone has better solution.
I have unrelated data except for the fact that is time stamped. I need to chart both series. The two options I know are:
Export to SQL and use Tableau, then embed a Tableau report in QB.
Create a table of dates to force the different sets to be related together.
Anyone know of another method?
Qrew LegendIs 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.
Mark,
That is essentially the scenario. In this case it is actually Sources and Uses of Funds. The chart shows money flowing in and out. I will try the consolidated table approach.
I have always hated the table of dates method with changing the key field.
