Hi community,
I need to use duration dimension to calculate the time between the same column date but based on value of another column, for instance:
dimension_group: graduation_carrer {
type: duration
intervals: [minute,hour,day]
sql_start: ${TABLE}.register_date where ${TABLE}.event = 'start carrer';;
sql_end: ${TABLE}.register_date where ${TABLE}.event = 'graduation';;
}
Is this posible in Looker?
Thanks for the help
Regards