Dear community,
I am new to looker and am doing my best to become a pro and would love some advice! My data looks as follows (obvously significantly larger :> ):
| Employee ID | Employment Start date | Employment end date |
| 1 | 15/12/2020 | 13/6/2021 |
| 2 | 18/6/2020 | 15/12/2020 |
| 3 | 15/5/2019 | 11/11/2019 |
| 4 | 10/4/2018 | 7/10/2018 |
| 5 | 15/12/2020 | 13/6/2021 |
| 6 | 11/11/2019 | 9/5/2020 |
| 7 | 15/12/2020 | 13/6/2021 |
I want to be able to build a time series charts which gives me the number of unique IDs that were inbetween employment start date and employment end date on a monthly basis and I want end users of the dashboard to be able to filter it for different time phrames. This means I have a selected data range on x-axis and on y-axis I get the number of unique employee ID´s for which in the given date the date is bigger or equal as employment start date but employer end date is not smaller (could be null)
Could you please advise how to build this from abbove data?
Thanks so much!
P