I would like to know a proper way to compare two tables over a period of time.

In the most basic example:

I want a bar chart in the following way:

In Y-Axis, the count of distinct records from table 1

Also in Y-Axis, I want the same for table 2.

In X-Axis I want a date value. Both table 1 and 2 have a 'Creation Date' column, but if I use the one from table 1, then the count of table 2 is wrong, and vice versa.

In this case I want to see Quotes vs Sales over time. But can't find a way to properly display the chart.

Thanks in advance