Dimension group duration type: sql_start and sql_end parameters

[Franzante]

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