2 Replies Latest reply on May 23, 2016 9:20 AM by Salimah Brooks

    Combine dates into 1 year for dual axis graph

    Salimah Brooks

      Hello,

      I am posting this because i need some assistance.  I am looking to create a dual axis graph. Here is what I need.

       

      - The year on the bottom (First Opportunity Date) on the x axis.

      - The running total of policies across first opportunity date (Distinct count of policy number)

      -The distinct count of policies by last opportunity date on the other axis.

       

      I think this is difficult because I am using two different dates for each policy number but i need to somehow get one date to aggregate the policies based on first opportunity which is ongoing and last opportunity which is not.