Line Graph over two different time series

[#1]

Hi -

I am trying to create a simple line graph with two sets of data. For example, I have a customer table, that has the Membership Date. So I want one line graph to show the number of Customers growing. I have a second table called Purchases which has a column Purchase Date. So on the same graph, I want another line showing the number of Purchases growing.

The problem I have is that the line graph is only using one set of dates for the Y-axis. I don't know how to associate # of Purchaes to Purchase Date and # of Customers to Membership Date.

I have created an example attached.

Thanks!

[Gysbert_Wassenaar]

Is giving the date fields the same name an option? See attached qvw

[Anonymous]

Why can't you use one date for both?  See attached.

[#4]

This is a great idea, but in my larger data set, it will create a join on this column which will cause other data issues.

[#5]

Thanks for the reply. Your sample gave me a "failed to open" error. Can you explain your solution?

[Anonymous]

It was exactly the same as form Gysbert 🙂

See another one, using Date as island.  In case you canot open it:

Script addition

Date:

LOAD Series1Date as Date RESIDENT Series1;
LOAD Series2Date as Date RESIDENT Series2;

Chart is using Date as dimension, and eaxpressions are

Count(if(Series1Date=Date,  Series1Value))

Count(if(Series2Date=Date,  Series2Value))

[#7]

This definitely works, but it creates a join between those two tables that causes other data issues. The search continues....

[Anonymous]

No, there is no join at all here.  Did you open my 2nd example?