########################################################
#
# Author: hillz@
# Updated Date: December 7, 2021
# Fields related to "Project Usage" from the project_usage_daily
# table.  If these fields are selected, Looker will switch to
# using the project_usage_daily table instead of revenue.
#
########################################################
view: revenue_from_project_usage_daily {
  extension:  required
  #### DIMENSIONS ####
  dimension: project_id {
    view_label: "Project/SKU"
    description: "Project ID for GCP Usage, maps to Project Number. Selecting this field will make your query much slower."
    type: string
    sql: ${TABLE}.project_id ;;
    full_suggestions: yes
    link: {
      label: "Project Lookup"
      url: "/dashboards-next/143?Project%20ID={{filterable_value}}&Product%20Group={{_filters['revenue.product_group']}}&Account%20Name={{_filters['vector_customers.account_name']}}&NAL%20Name={{_filters['revenue.nal_name']}}&Project%20Name={{_filters['revenue.project_name']}}"
      icon_url: "https://www.google.com/s2/favicons?domain=www.looker.com"
    }
  }
  dimension: project_name {
    view_label: "Project/SKU"
    description: "Project name for GCP usage, can change over time. For a static value, use Project ID. Selecting this field will make your query much slower."
    sql: ${TABLE}.project_name ;;
    type: string
    full_suggestions: yes
  }
  dimension: project_number {
    view_label: "Project/SKU"
    description: "Project number for GCP usage.  Selecting this field will make your query much slower."
    sql: ${TABLE}.project_number ;;
    type: string
  }
  dimension: resource_group {
    view_label: "Project/SKU"
    description: "Resource group collects various SKUs.  Selecting this field will make your query much slower."
    sql: ${TABLE}.resource_group ;;
    type: string
  }
  dimension: sku_description {
    label: "SKU Description"
    group_label: "SKU"
    view_label: "Project/SKU"
    description: "Human-readable identifier for each product at the SKU level.  Selecting this field will make your query much slower."
    sql: ${TABLE}.sku_description ;;
    type: string
  }
  dimension: sku_id {
    label: "SKU ID"
    group_label: "SKU"
    view_label: "Project/SKU"
    description: "Unique identifier for each product at the SKU level.  Selecting this field will make your query much slower."
    sql: ${TABLE}.sku_id ;;
    type: string
  }
  dimension: usage_in_usage_units_dim {
    hidden: yes
    sql: ${TABLE}.usage_in_usage_units ;;
    type: number
  }
  dimension: usage_location {
    view_label: "Project/SKU"
    description: "Location of usage.  Selecting this field will make your query much slower."
    sql: ${TABLE}.usage_location ;;
    type: string
  }
  dimension: usage_unit {
    view_label: "Project/SKU"
    description: "Unit for measuring SKU usage (i.e., GiBi, Second, etc.).  Selecting this field will make your query much slower."
    sql: ${TABLE}.usage_unit ;;
    type: string
  }
  #### MEASURES ####
  measure: usage_in_usage_units {
    view_label: "Project/SKU"
    sql: ${usage_in_usage_units_dim} ;;
    type: sum
    drill_fields: [billing_account_id, usage_unit, usage_in_usage_units]
    value_format_name: decimal_0
    link: {
      url: "{{ link | replace: \"billing_account_id\", \"product_line\" }}&limit=10"
      label: "Top 10 Product Lines"
      icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
    }
    link: {
      url: "
      {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
      {{ link | replace: column_name, \"=revenue.nal_name,revenue.reporting_account_name\" }}&limit=10&sorts={{ _field._name }}+desc
      "
      label: "Top 10 Accounts"
      icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
    }
    link: {
      url: "
      {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
      {{ link | replace: column_name, \"=revenue.segment\" }}&limit=10&sorts={{ _field._name }}+desc
      "
      label: "Drill by Segment"
      icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
    }
    link: {
      url: "
      {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
      {{ link | replace: column_name, \"=revenue.account_category\" }}&limit=10&sorts={{ _field._name }}+desc
      "
      label: "Drill by Account Category"
      icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
    }
    link: {
      url: "
      {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
      {{ link | replace: column_name, \"=revenue.region\" }}&limit=10&sorts={{ _field._name }}+desc
      "
      label: "Drill by Region"
      icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
    }
    link: {
      url: "
      {% assign column_name = \"=\" | append: _view._name | append: \".billing_account_id\" %}
      {{ link | replace: column_name, \"=revenue.region,revenue.sub_region,revenue.micro_region,revenue.nal_cluster,revenue.nal_name,revenue.nal_id\" }}&sorts={{ _field._name }}+desc
      "
      label: "Drill by NAL"
      icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
    }
    link: {
      url: "{{ link | replace: \"billing_account_id\", \"product_group\" }}"
      label: "Drill by Product Group"
      icon_url: "https://g3doc.corp.google.com/company/teams/concord/portal/images/logo-concord-no-text.png"
    }
  }
}