Question

Dimension group duration type: sql_start and sql_end parameters

  • 5 August 2021
  • 0 replies
  • 17 views

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


0 replies

Be the first to reply!

Reply