4 Replies Latest reply on Jan 16, 2019 3:35 AM by Tablo.0

    Employee Tenure and Shift Count in Scatterplot

    Elie Rahi

      I need a scatterplot like the below. This shows the median shifts done by employees versus the median tenure of the employee. This is segmented by state and year so we are comparing across all states and comparing 2018 with 2017.

       

       

      Attached is the data, that have all the fields necessary. We have each row denotes a shift and:

       

      Hours - hours rostered

      Status - whether the shift is completed or cancelled.

      Role start date - The date the employee has started working

      Shift date - the date of the shift. We can have multiple shifts for a particular employee