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

# Employee Tenure and Shift Count in Scatterplot

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

• ###### 1. Re: Employee Tenure and Shift Count in Scatterplot

Hi,

I don't know how much I've understood your requirement, however take a look if this is what you wanted else share your expected result with one example.

Mahfooj

1 of 1 people found this helpful
• ###### 2. Re: Employee Tenure and Shift Count in Scatterplot

Hello,

Thanks for your work on this. It's almost what I need.

In terms of tenure, that should be the difference between their Role Start Date and today's date so the calc should be:

DATEDIFF('month',

{FIXED [Employee ID]:MIN([Role Start Date])},

{FIXED [Employee ID]:MIN(TODAY())}

)

When comparing 2017 and 2018 we need to work out the median tenure and median shift count at the same time period, so Dec 2017 versus Dec 2018, regardless of Role Start Date.

So for median shift count as of Dec 2017 this needs to be median shift count excluding all the shifts done in Jan-Dec 2018

For median tenure as of Dec 2017 this needs to be the difference between Role Start Date and Dec 2017.

• ###### 3. Re: Employee Tenure and Shift Count in Scatterplot

Sorry for late reply, could you please explain with one example of any state from the graph and its expected output? I'm unable to understand the question

• ###### 4. Re: Employee Tenure and Shift Count in Scatterplot

Mahfooj Khan i have a question on my feed i am hoping you can help me with.