1 Reply Latest reply: Apr 26, 2016 12:46 PM by Sunny Talwar RSS

    2 Dates in 1 Chart

    Natalie Doswell

      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%

       

       

       

      QuoteIDQuoteDatePolicyIDPolicyDate
      101/01/2016101/01/2016
      201/01/2016--
      301/01/2016201/01/2016
      401/02/2016301/02/2016
      501/02/2016401/02/2016
      601/02/2016501/02/2016
      701/02/2016--

       

      Any assistance on how to "merge" these 2 dates into 1 would be greatly appreciated.

       

      Natalie