我目前正在开发一个lookml explore模型，它左连接4个表，每个表的pk为pid。这4个表之间的数据粒度不同，这导致了重复和错误的高计数总数问题。
有没有一种方法可以通过使用我们仓库中设置的dimdate表在4个表之间的日期列上左连接？
以下是当前的explore lookml：

### SMS ####################

explore: stg_mysql_twiliooutboundsms {
  group_label: "Usage"
  label: "SMS"

  join: dimaccount {
    sql_on: ${dimaccount.pid} = ${stg_mysql_twiliooutboundsms.pid};;
    type: left_outer
    relationship: many_to_one
  }

  join: stg_mysql_twilioinboundsms {
    sql_on: ${stg_mysql_twiliooutboundsms.pid} = ${stg_mysql_twilioinboundsms.pid} ;;
    type: left_outer
    relationship: one_to_one
  }

  join: stg_mysql_telnyxoutboundsms {
    sql_on: ${stg_mysql_twiliooutboundsms.pid} = ${stg_mysql_telnyxoutboundsms.pid} ;;
    type: left_outer
    relationship: one_to_one
  }

  join: stg_mysql_telnyxinboundsms {
    sql_on: ${stg_mysql_twiliooutboundsms.pid} = ${stg_mysql_telnyxinboundsms.pid}  ;;
    type: left_outer
    relationship: one_to_one
  }
}