Question

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

  • 26 November 2019
  • 1 reply
  • 106 views

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


1 reply

Userlevel 2

@izzy is there a solution for this kind of line-chart, created from start and end-dates?

Reply