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.