Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Create a date array dimension in Looker

Hi, I want to count resolved and created tickets per day in the same Looker graph. However, each measure relies on a different time dimension unfortunately (created_date & resolution_date). 

I think I need a third dimension e.g."day" where each measure can looker for day=created_date and day=resolution_date respectively to do the count. 

How can I create a time dimension_group with dummy dates for both measures to work properly in one graph? 

Essentially I am looking for the equivalent of the following BQ statement: 

SELECT day
FROM UNNEST(
GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1 DAY)
) AS day

 

 

Thanks!

0 0 702
0 REPLIES 0
Top Labels in this Space
Top Solution Authors