Time series chart of unique ID in given data range subject to condition between date range

  • 30 January 2023
  • 0 replies

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!


0 replies

Be the first to reply!