I am looking to work out Take Up Rate Which is Number of Policies/ Number of Quotes.
However the data is stored in 2 tables and joined via QuoteID.
For Quotes we will use the QuoteDate to Measure how many we have quoted and for Policies we will use the Policy Date to measure how many policies we have on cover.
However i want to create a chart which combines these dates so that i am able to see that for the Quote Date of Jan and Policy Date of Jan we have taken up x%.
Below is an example of how our data would look and the expected take up rates.
Jan 16 Take Up - 66%
Feb 16 Table Up - 75%
QuoteID
QuoteDate
PolicyID
PolicyDate
1
01/01/2016
1
01/01/2016
2
01/01/2016
-
-
3
01/01/2016
2
01/01/2016
4
01/02/2016
3
01/02/2016
5
01/02/2016
4
01/02/2016
6
01/02/2016
5
01/02/2016
7
01/02/2016
-
-
Any assistance on how to "merge" these 2 dates into 1 would be greatly appreciated.