0 Replies Latest reply on Nov 29, 2018 6:42 AM by flavio.gustavio

    SQL code for calculating percentage over time period

    flavio.gustavio

      I'm
      looking to combine certain data, but my SQL knowledge is lacking to do so...

       

      I've got an employee table:

      employeeID 1

      employeeID 2

      employeeID 3

       

      A table with subtypes:

      subtype 100

      subtype 200

       

      And I've got time.

       

      Everyday an employee will have a certain subtype. For example:

       

      JAN 2017 week 1:

      employee1 subtype 100

      employee2 subtype 100

      employee3 subtype 100

       

      FEB 2017 week 2:

      employee1 subtype 100 (day 1-3)

      employee1 subtype 200 (day 4-5)

      employee2 subtype 100

      employee3 subtype 100

       

       

      I need to calculate the percentage of employees that do not have subtype 200 over the selected time period (ideally over the span of 52 weeks).

       

       

      How can I do this? Thanks a lot for helping!