Looker Community

Looker linechart with date on x-axis from start and end dates

Hi Looker Chiefs

Chief in training here. I have a customer table with start and end dates:

customer_id | _ start_date| end_date
___________ 1 | 2018-01-01 | 2018-07-01
___________ 2 | 2018-02-01 | null
___________ 3 | 2019-01-01 | null

(null means customer is still active)
I’d like to visualize this as a line chart showing the total number of customers from 2018-01-01 to current date:

#customers
|
| /’’’’’’’’’’’’\__________
|/__________________
date

Is there any way to have Looker understand the start and end dates of the table?
Or would I have to restructure my table into daily observations and then feed that to Looker with count(customer_id) as measure?

Best
Elias