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!