I am going through an issue to represent Employee data about their trainings and completion status.
I have a simple data model with three table connected with EmpID & a master calender connected to Employee table with DOC(Date of last status change of one of the training completed).
So, in this case whenever such a month is selected in which their is no DOC for any employee, it shows blank on all Charts as Calender cant find any relation to the Month selected.
I want to change my Data model and give such condition that whenver any such empty data month is selected then it should show last available completion status.
