Forum Discussion
Daily Mapping table
Anonymous , here is a quick mock up chart, basically we just select a date and it will show the count of employees for each Deparment as at selected date
Hi Anonymous ,
Imo, would suggest to keep the dimension table small without duplicates. Since each employee is unique you can create a employeeid in the dimension table as a unique key but that would require you to modify your dimension and fact table.
Step 1: Modify your dimension table to the below, A new row is created whenever structural change happens (Note: if you do not want to use employee id you could use employee name as the mapping, but not advisable as some employees have same first name)
Step 2: Map Employee Id to Employee id, Or employee name to employee name
Step 3: Visualize
I hope that helps, if it does please mark that as a solution
BR
Dax_Noob