CALCULATE MONTH AVERAGE OF STAFF ON LEAVE

[Asavela_]

Hey guys I would like assistance on this:

Fields: YearMonth = YYYYMM, Department, Employee, Leave Types = Sick, Annual, Maternity etc. 

Measures: Total Staff = count(distinct Employee)

On my analysis I want to create a bar chart where I get averages of each leave type per month for each department.

It would be great to do this in the back end.