I need to count(distinct) number of employees in last 12 Months. Line chart should show Year_Month from 2018 till today.
I need to distinct count of employees( for example Mai 2021 should have all employees between Juni 2020 and Mai 2021) where status date is there. But if one employee is there each month in this time period i need to count him as one and not as twelve.
Any suggestions?
