I’m at a loss as to how to do this as it’s throwing an error in looker …
I have 2 dates were i’m calculating the duration dimension_group:
dwell_time { type: duration intervals: [second, minute, hour, day]
sql_start: ${firstfield_date_created_time} ;...