Calculate Average......

[prees959]

Hi,

I need to calculate the average productivity of a particular Day, Shift Type, Grade and Dept...

For example, I have a dataset :

Date	Day	Grade	Dept	Shift Type	Units Produced
01/01/2016	Monday	1	A	Day	35
02/01/2016	Tuesday	2	B	Afternoon	53
03/01/2016	Wednesday	4	C	Night	24
04/01/2016	Thursday	2	C	Afternoon	67
05/01/2016	Friday	3	A	Day	35
06/01/2016	Saturday	3	B	Afternoon	24
07/01/2016	Sunday	5	C	Night	64
08/01/2016	Monday	1	A	Day	64
09/01/2016	Tuesday	4	C	Day	23
10/01/2016	Wednesday	6	A	Day	26
11/01/2016	Thursday	2	A	Afternoon	71
12/01/2016	Friday	5	A	Night	15
13/01/2016	Saturday	7	B	Afternoon	84
14/01/2016	Sunday	2	C	Afternoon	43
15/01/2016	Monday	4	C	Night	56
16/01/2016	Tuesday	6	A	Day	32
17/01/2016	Wednesday	8	C	Night	79
18/01/2016	Thursday	3	A	Night	83
19/01/2016	Friday	4	A	Afternoon	26
20/01/2016	Saturday	6	C	Afternoon	83
21/01/2016	Sunday	8	A	Day	23
22/01/2016	Monday	2	C	Night	57
23/01/2016	Tuesday	3	A	Night	24
24/01/2016	Wednesday	1	A	Day	74

So I would need to show that, for example,  Grade 1 Staff in Department A on a Day Shift have an average production of 49.5 etc.  

Is there a way to calculate this as an expression?

Thanks,

Phil

[sunny_talwar]

I don't think I follow. May be it is because of my lack of understanding of your actual data.

[prees959]

Hi,

I've attached a larger sample dataset.

At a point in time a new Rota  (Rota B) was introduced.  What I am trying to portray is if this new Rota is more or less productive than Rota A.

By taking an average of Rota A and comparing it to Rota B seems too simplistic as there maybe Departments, Grades or particular Days which could prove more or less productive than others.

it would be great to have a single High level KPI that says if Rota A is more or less productive than Rota B and then a be able to drill down into Dept, Grade, Day of week....

I hope this helps?

Phil

I hope this helps

[sunny_talwar]

I think this is a great start. Now would you be able to take this data and provide me with few test scenarios with their output to understand this better?