How can I make deptt-wise month-wise trend(header count trend)?
I have linked the Master Calendar with the following scripting. Please suggest me a way to generate the deptt-wise month-wise trend.
SCRIPTING:
fact:
load * inline [
EmpID,WefDate,Dept
1,15/07/2016,HR
1,01/01/2017,Admin
2,25/09/2016,HR
3,25/09/2016,Analytics Developer
3,01/02/2017,Analytics Sales
4,01/08/2016,Analytics Sales];
details:
load*,
DATE(DOJ)&' - '&date(DOL) as Period;
load * Inline [
EmpID,DOJ,DOL
1,15/07/2016,
2,25/09/2016,31/12/2016
3,25/09/2016,
4,01/08/2016,
];
Bridge:
inner join IntervalMatch("WefDate",EmpID)
Load distinct
DOJ,
DOL,EmpID Resident details;
DROP TABLE details;