3 Replies Latest reply on May 28, 2015 9:20 AM by Ankit Patel

    Proportional Brushing with Open/Close Dates

    Ryan Packer

      I am trying to display the sales versus potential sales.  This is a problem across all business areas of my business and seems to be very difficult to solve.  I have two data tables.  One that has start and end dates for the ownerships of vehicle and another that has service events for those vehicle.  A service event is only possible on vehicles that have an ownership so knowing the proportion of sales is important for reporting

       

      Data is in two table

      Ownerships which have a start and end date

      Jobs Which have a date and and ownership number

       

      I want to know on any given date aggregation

      1) How Many Jobs There were

      2) How Total Number of Open Ownerships regardless of their servicing