label: "AWAL Community Support"
connection: "awal-looker"

include: "/DOSC/Community_Support/applications_data/views/sony_applications_data.view.lkml"
include: "/DOSC/Community_Support/applications_data/views/sony_applications_data_leads.view.lkml"
include: "/DOSC/Community_Support/applications_data/views/sony_applications_data_approval.view.lkml"
include: "/DOSC/Community_Support/applications_data/views/sony_applications_data_unqualified.view.lkml"
include: "/DOSC/Community_Support/applications_data/views/sony_applications_data_submit.view.lkml"
include: "/DOSC/Community_Support/applications_data/views/sony_applications_data_signup.view.lkml"
include: "/DOSC/Community_Support/applications_data/views/sax_applications_data.view.lkml"


explore: sony_applications_data {
  hidden: yes
  label: "SONY Applications Data"
}

explore: sony_applications_data_leads {
  hidden: yes
  label: "SONY Raw Applications Data"


  join: sony_applications_data_approval {
    sql_on: ${sony_applications_data_approval.Id} = ${sony_applications_data_leads.ConvertedContactId} ;;
    type: left_outer
    relationship: one_to_many
    view_label: "SONY Applications Data - approval"
  }

  join: sony_applications_data_unqualified {
    sql_on: ${sony_applications_data_unqualified.Id} = ${sony_applications_data_leads.Id} ;;
    type: left_outer
    relationship: one_to_many
    view_label: "SONY Applications Data - unqualified leads"
  }

  join: sony_applications_data_submit {
    sql_on: ${sony_applications_data_submit.CorrelationId} = ${sony_applications_data_approval.CorrelationId} ;;
    type: left_outer
    relationship: one_to_many
    view_label: "SONY Applications Data - submit"
  }

  join: sony_applications_data_signup {
    sql_on: ${sony_applications_data_signup.CorrelationId} = ${sony_applications_data_submit.CorrelationId} ;;
    type: left_outer
    relationship: one_to_many
    view_label: "SONY Applications Data - signup"
  }
}

explore: sax_applications_data {
  hidden: yes
  label: "SAX Applications Data"
}