explores/revenue.view.lkml

# Approximates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/explores/revenue.view.lkml
include: "/views/revenue/*.view.lkml"
include: "/views/nal.view.lkml"
include: "/views/vector/customers.view.lkml"

explore: revenue {
  label: "Usage Revenue"
  description: "Daily Revenue for GCC Cloud BI Sales, defaults to Split Revenue"
  always_filter: {
    filters: [
      revenue.segment: "-Scaled"
      , revenue.product_line: "-Looker,-Looker Data Platform SaaS"
      , revenue.sub_region: "-NULL"
      , revenue.service_family: "CLOUD"
    ]
  }

  join: vector_customers {
    view_label: "Account"
    sql_on: ${revenue.sfdc_account_id} = ${vector_customers.sfdc_account_id};;
    relationship: many_to_one
    fields: [vector_customers.digital_native_details*
      , vector_customers.nal_sub_cluster
      , vector_customers.account_name
      , vector_customers.count_sfdc_account_id
      , vector_customers.is_isv]
  }

  join: max_date {
    type: cross
    relationship: one_to_one
  }
  join: nal {
    view_label: "Account"
    type: left_outer
    sql_on: ${revenue.nal_id} = ${nal.nal_id} ;;
    relationship: many_to_one
  }
}