# emulates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/views/revenue/revenue_from_revenue.view.lkml
view: revenue_from_revenue {
  extension: required
  ########## DIMENSIONS ############
  dimension: currency_code {
    view_label: "Revenue"
    description: "Three letter currency code (e.g. USD) for local billing amount."
    sql: ${TABLE}.currency_code ;;
  }
  dimension: dynamic_usage_timeframe {
    view_label: "Revenue"
    description: "Dynamic field that is returns usage date, dependent on `Usage Timeframe Selector`. If none selected, defaults to daily."
    type: date
    sql: CASE
          WHEN {% parameter usage_timeframe_selector %} = 'Date' THEN SAFE_CAST(${usage_date} AS STRING)
          WHEN {% parameter usage_timeframe_selector %} = 'Week' THEN ${usage_week}
          WHEN {% parameter usage_timeframe_selector %} = 'Month' THEN CONCAT(${usage_month},"-01")
         END ;;
  }
  dimension: gcp_revenue_source {
    view_label: "Revenue"
    label: "GCP Revenue Source"
    description: "Used by the Northam team to filter revenue.  Values can be Organic GCP (all products except for Marketplace Services), MP Standard (Marketplace Services that aren't pre-paid), or MP Prepay (Marketplace Services that are prepaid)."
    case: {
      when: {
        sql: ${product_group} != "Non-Cloud" ;;
        label: "Organic GCP"
      }
      when: {
        sql: ${product_group} = "Non-Cloud" AND NOT ${is_nonmetered} ;;
        label: "MP Standard"
      }
      when: {
        sql: ${product_group} = "Non-Cloud" AND ${is_nonmetered} ;;
        label: "MP Prepaid"
      }
      else: "Other Revenue"
    }
  }
  dimension_group: invoice_month_start {
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    view_label: "Revenue"
    sql: ${TABLE}.invoice_month_start ;;
    datatype: date
    convert_tz: no
  }

  dimension: is_data_analytics {
    type: yesno
    label: "Is Data Analytics?"
    view_label: "Product"
    sql: ${revenue.product_group_l2} = 'Analytics'
          OR ${revenue.is_dataproc}
          OR ${revenue.logical_product_l3} IN ('AI Platform', 'Confluent', 'Confluent Dev',
          'Confluent Staging', 'Databricks', 'Elastic', 'Elastic - Dev', 'Fivetran',
          'Informatica', 'MongoDB Inc.', 'Palantir') ;;
    description: "Returns yes if this is Data & Analytics (DA) usage"
  }
  dimension: is_dataproc {
    type: yesno
    label: "Is Dataproc Node?"
    view_label: "Product"
    sql: ${TABLE}.is_dataproc_node ;;
    description: "Does this usage come from a Dataproc node?"
  }
  dimension: is_gcp_marketplace {
    type: yesno
    label: "Is GCP Marketplace?"
    view_label: "Product"
    sql: ${TABLE}.is_gcp_marketplace ;;
  }
  dimension: is_gke_node {
    type: yesno
    label: "Is GKE Node?"
    view_label: "Product"
    sql: ${TABLE}.is_gke_node ;;
    description: "Does this usage come from a GKE node?"
  }
  dimension: product_family_l1 {
    label: "Product Family (L1)"
    group_label: "Finance Product Hierarchy"
    view_label: "Product"
    description: "Examples: Google Workspace, GCP, Maps, PSO"
    sql: ${TABLE}.product_group ;;
    drill_fields: [product_group_l2]
  }
  dimension: product_group_l2 {
    label: "Product Group (L2)"
    group_label: "Finance Product Hierarchy"
    view_label: "Product"
    description: "Examples: Marketplace Services, Compute, Support, Databases, etc."
    sql: ${TABLE}.product_group_l2 ;;
    drill_fields: [logical_product_l3]
  }
  dimension: logical_product_l3 {
    label: "Logical Product (L3)"
    group_label: "Finance Product Hierarchy"
    view_label: "Product"
    description: "Examples: Persistent Disk, VM Image Storage, GCE"
    sql: ${TABLE}.logical_product_l3 ;;
  }
  # dimension: machine_type {
  #   view_label: "Product"
  #   description: "Machine Type Classifications for Compute Engine"
  #   sql: IF(${product_line_raw} = "Compute Engine", CASE
  #       WHEN ${is_gke_node} THEN "GKE"
  #       WHEN ${is_dataproc} THEN "Dataproc"
  #       WHEN ${sku_description} LIKE '%A2 %' THEN 'A2'
  #       WHEN ${sku_description} LIKE '%E2 %' THEN 'E2'
  #       WHEN ${sku_description} LIKE '%Memory%optimized%' THEN 'M1/M2'
  #       WHEN ${sku_description} LIKE '%N2 %' THEN 'N2'
  #       WHEN ${sku_description} LIKE '%N2D%' THEN 'N2D'
  #       WHEN ${sku_description} LIKE '%Compute%optimized%' THEN 'C2'
  #       WHEN LOWER(${sku_description}) LIKE '%custom%ram%' OR ${sku_description} LIKE '%Custom%Core%' OR ${sku_description} LIKE '%N1 %' OR ${sku_description} LIKE '%v1: Cpu%' OR ${sku_description} LIKE '%v1: Ram%' OR ${sku_description} LIKE '%Instance Ram hosted on Sole Tenancy%' OR ${sku_description} LIKE '%Sole Tenancy Instance RAM%' OR ${sku_description} LIKE '%Sole Tenancy Instance Ram%' OR ${sku_description} LIKE '%Instance Core hosted on Sole Tenancy%' OR ${sku_description} LIKE '%Sole Tenancy Instance Core%' OR ${sku_description} LIKE 'Micro Instance%' OR ${sku_description} LIKE 'Preemptible Micro Instance%' OR ${sku_description} LIKE '%Small Instance%' THEN "N1"
  #       ELSE "Other Machine Type"
  #     END, NULL) ;;
  #   drill_fields: [sku_description]
  # }
  dimension: product_group {
    group_label: "Legacy Product Hierarchy"
    view_label: "Product"
    description: "Groupings of Product Line into broader categories like \"Compute\" or \"Data Analytics\""
    sql: ${TABLE}.product_group ;;
    drill_fields: [product_line]
  }
  dimension: product_line {
    group_label: "Legacy Product Hierarchy"
    view_label: "Product"
    description: "Product Line, but with is_gke_node = True reassigned to Kubernetes Engine and is_dataproc = True reassigned to Dataproc"
    sql: IF(${product_line_raw} = "Compute Engine",
          CASE
            WHEN ${is_gke_node} THEN "Kubernetes Engine"
            WHEN ${is_dataproc} THEN "Dataproc"
            ELSE "Compute Engine"
          END,
          ${product_line_raw});;
    drill_fields: [sku_description, ]
  }

  dimension: product_line_raw {
    hidden: yes
    group_label: "Legacy Product Hierarchy"
    view_label: "Product"
    sql: ${TABLE}.product_line;;
    #drill_fields: [sku_description]
  }

  # dimension: product_line_raw {
  #   hidden: yes
  #   group_label: "Legacy Product Hierarchy"
  #   view_label: "Product"
  #   sql: {% if project_number._in_query %} ${TABLE}.product_name
  #       {% elsif project_name._in_query %} ${TABLE}.product_name
  #       {% elsif project_id._in_query %} ${TABLE}.product_name
  #       {% elsif sku_id._in_query %} ${TABLE}.product_name
  #       {% elsif sku_description._in_query %} ${TABLE}.product_name
  #       {% elsif machine_type._in_query %} ${TABLE}.product_name
  #       {% elsif resource_group._in_query %} ${TABLE}.product_name
  #       {% elsif storage_locality._in_query %} ${TABLE}.product_name
  #       {% elsif storage_class._in_query %} ${TABLE}.product_name
  #       {% elsif usage_location._in_query %} ${TABLE}.product_name
  #       {% elsif usage_unit._in_query %} ${TABLE}.product_name
  #       {% elsif usage_in_usage_units._in_query %} ${TABLE}.product_name
  #       {% else %} ${TABLE}.product_line {% endif %} ;;
  #   drill_fields: [sku_description]
  # }
  # dimension: product_specialization {
  #   view_label: "Product"
  #   sql: {% if project_number._in_query %} ${TABLE}.specialization
  #       {% elsif project_name._in_query %} ${TABLE}.specialization
  #       {% elsif project_id._in_query %} ${TABLE}.specialization
  #       {% elsif sku_id._in_query %} ${TABLE}.specialization
  #       {% elsif sku_description._in_query %} ${TABLE}.specialization
  #       {% elsif machine_type._in_query %} ${TABLE}.specialization
  #       {% elsif resource_group._in_query %} ${TABLE}.specialization
  #       {% elsif storage_locality._in_query %} ${TABLE}.specialization
  #       {% elsif storage_class._in_query %} ${TABLE}.specialization
  #       {% elsif usage_location._in_query %} ${TABLE}.specialization
  #       {% elsif usage_unit._in_query %} ${TABLE}.specialization
  #       {% elsif usage_in_usage_units._in_query %} ${TABLE}.specialization
  #       {% else %} ${TABLE}.product_specialization {% endif %} ;;
  #   drill_fields: [sku_description]
  # }
  dimension: service_family {
    view_label: "Product"
    description: "Service family, i.e. CLOUD or GEO"
    type: string
    sql: ${TABLE}.service_family ;;
  }
  # dimension: storage_class {
  #   view_label: "Product"
  #   group_label: "Cloud Storage"
  #   description: "Groups Cloud Storage into Archive, Coldline, Nearline, and Standard based on sku description."
  #   case: {
  #     when: {
  #       sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Archive%' ;;
  #       label: "Archive"
  #     }
  #     when: {
  #       sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Coldline%' ;;
  #       label: "Coldline"
  #     }
  #     when: {
  #       sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Nearline%' ;;
  #       label: "Nearline"
  #     }
  #     when: {
  #       sql: ${product_line_raw} = "Cloud Storage" ;;
  #       label: "Standard"
  #     }
  #   }
  # }
  # dimension: storage_locality {
  #   view_label: "Product"
  #   group_label: "Cloud Storage"
  #   description: "Groups Cloud Storage into Multi-Region, Dual-Region, or Regional based on sku description."
  #   case: {
  #     when: {
  #       sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Multi%' ;;
  #       label: "Multi-Region"
  #     }
  #     when: {
  #       sql: ${product_line_raw} = "Cloud Storage" AND ${sku_description} LIKE '%Dual%' ;;
  #       label: "Dual-Region"
  #     }
  #     when: {
  #       sql: ${product_line_raw} = "Cloud Storage" ;;
  #       label: "Regional"
  #     }
  #   }
  # }
  dimension_group: usage {
    type: time
    timeframes: [raw, day_of_month, day_of_year, day_of_week, date, week, month, month_name, quarter, quarter_of_year, year]
    view_label: "Revenue"
    description: "Date on which usage was recorded"
    sql: ${TABLE}.partition_date ;;
    datatype: date
    convert_tz: no
  }
  dimension: usd_revenue_blended {
    hidden: yes
    view_label: "Revenue"
    sql: {% if filter_nonmetered._parameter_value == "true" %}
      IF(NOT ${is_nonmetered}, ${TABLE}.usd_revenue_blended, 0)
      {% else %}
      ${TABLE}.usd_revenue_blended
      {% endif %}
      ;;
  }
  dimension: usd_revenue_bmod {
    hidden: yes
    view_label: "Revenue"
    sql: ${TABLE}.usd_revenue_bmod ;;
  }
  dimension: usd_revenue_cross_pa_credits {
    hidden: yes
    description: "Added to usd_revenue_net_cn to create GCP Actuals"
    sql: ${TABLE}.usd_revenue_cross_pa_credits ;;
  }
  dimension: usd_revenue_cud {
    hidden: yes
    view_label: "Revenue"
    description: "Committed Usage Discount credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate."
    sql: ${TABLE}.usd_revenue_cud ;;
  }
  dimension: usd_revenue_ft {
    hidden: yes
    view_label: "Revenue"
    description: "Free Trial credit applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate."
    sql: ${TABLE}.usd_revenue_ft ;;
  }
  dimension: usd_revenue_gross {
    hidden: yes
    view_label: "Revenue"
    description: "Monetised value for resource consumption, before application of any credits, reported in USD($) using a monthly Ceilometer exchange rate. (Generally a positive number)"
    sql: ${TABLE}.usd_revenue_gross ;;
  }
  dimension: usd_revenue_gross_cn {
    hidden: yes
    view_label: "Revenue"
    sql: ${TABLE}.usd_revenue_gross_cn ;;
  }
  dimension: usd_revenue_list {
    hidden: yes
    view_label: "Revenue"
    sql: ${TABLE}.usd_revenue_list ;;
  }
  dimension: usd_revenue_net {
    hidden: yes
    view_label: "Revenue"
    description: "Final billed amounts after application of all other credits, reported in USD($) using an annual exchange rate. (Net amounts are normally positive or round to zero, but it some cases credits can exceed gross and net will be negative)"
    sql: ${TABLE}.usd_revenue_net ;;
  }
  dimension: usd_revenue_ntg {
    hidden: yes
    view_label: "Revenue"
    description: "Net to Google Revenue"
    sql: ${TABLE}.usd_revenue_ntg ;;
  }
  dimension: usd_revenue_net_cn {
    hidden: yes
    view_label: "Revenue"
    sql: {% if filter_nonmetered._parameter_value == "true" %}
      IF(NOT ${is_nonmetered}, ${TABLE}.usd_revenue_net_cn, 0)
      {% else %}
      ${TABLE}.usd_revenue_net_cn
      {% endif %}
      ;;
  }
  dimension: usd_revenue_promo {
    hidden: yes
    view_label: "Revenue"
    description: "Other promotional credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate."
    sql: ${TABLE}.usd_revenue_promo ;;
  }
  dimension: usd_revenue_protected_credit {
    hidden: yes
    view_label: "Revenue"
    sql: ${TABLE}.usd_revenue_protected_credit ;;
  }
  dimension: usd_revenue_reseller {
    hidden: yes
    view_label: "Revenue"
    sql: ${TABLE}.usd_revenue_reseller ;;
  }
  dimension: usd_revenue_rvp {
    hidden: yes
    view_label: "Revenue"
    description: "Revenue for RVPs: see go/revenue-walk for details"
    sql: ${TABLE}.usd_revenue_rvp ;;
  }
  dimension: usd_revenue_sud {
    hidden: yes
    view_label: "Revenue"
    description: " Usage Discount credits applied against the _gross amount, reported in USD($) using a monthly Ceilometer exchange rate."
    sql: ${TABLE}.usd_revenue_sud ;;
  }
  dimension: is_nonmetered {
    type: yesno
    label: "Is Nonmetered?"
    view_label: "Product"
    sql: ${TABLE}.is_nonmetered ;;
  }
  #### MEASURES ####
  measure: revenue_invoice {
    alias: [revenue_actuals]
    label: "Revenue (Invoice)"
    view_label: "Revenue"
    description: "Sum of Revenue (Sales) minus hug credits. Post alignment we have agreed to keep only one source of truth for revenue and it will be gcc.revenue. Gcp_consumpiton will be deprecated but another table(with adjustments) will be established to enable the bridge from gcc.revenue to finance."
    type: sum
    sql: ${usd_revenue_net} - ${usd_revenue_cross_pa_credits};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_actuals, revenue_net_cn]
    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"
    }
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_bmod {
    group_label: "Discounts, Credits & BMODS"
    label: "Revenue (Billing Modifications)"
    view_label: "Revenue"
    description: "The subset of revenue that is due to a billing modification. Billing Modifications (BMods) are requested when an adjustment affecting the regular invoicing process needs to be made."
    type: sum
    sql: ${usd_revenue_bmod};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, usd_revenue_bmod, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_cross_pa_credits {
    group_label: "Discounts, Credits & BMODS"
    label: "Revenue (xPA Credits)"
    view_label: "Revenue"
    description: "Cross PA Credits."
    type: sum
    sql: ${usd_revenue_cross_pa_credits};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_cross_pa_credits, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_cud {
    group_label: "Discounts, Credits & BMODS"
    label: "Revenue (Committed Usage Discount)"
    view_label: "Revenue"
    description: "Committed Usage Discount credits applied against the Gross amount."
    type: sum
    sql: ${usd_revenue_cud};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_cud, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_discounts_other {
    group_label: "Discounts, Credits & BMODS"
    label: "Revenue (Other Discounts)"
    view_label: "Revenue"
    description: "Differences between Gross and Revenue (Sales) not due to BMods, CUD, SUD, Free Trial, or Promo, Cross PA Credits."
    type: sum
    sql: -1 * (${usd_revenue_gross} - ${usd_revenue_blended} + ${usd_revenue_cud} + ${usd_revenue_ft} + ${usd_revenue_promo} + ${usd_revenue_sud} +${usd_revenue_reseller}) ;;
    value_format_name: usd_0
    drill_fields: [billing_account_id
      , revenue_discounts_other
      , revenue_gross
      , revenue_net_cn
    ]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_ft {
    group_label: "Discounts, Credits & BMODS"
    label: "Revenue (Free Trial)"
    view_label: "Revenue"
    description: "Free Trial credit applied against the Gross amount."
    type: sum
    sql: ${usd_revenue_ft};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_ft, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_gross {
    label: "Revenue (Gross)"
    view_label: "Revenue"
    description: "Monetised values for resource consumption, before application of credits (adjustments). Gross values are generally positive."
    type: sum
    sql: ${usd_revenue_gross};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
    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"
    }
  }
  measure: revenue_list {
    label: "[go/listrev] Revenue (List)"
    view_label: "Revenue"
    description: "Learn more at go/listrev. Amount of monetized usage calculared based on the list price of each SKU (with no discounts applied)."
    type: sum
    sql: ${usd_revenue_list} ;;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_list, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
    link: {
      url: "http://go/listrev"
      label: "Learn more about List Revenue Metric"
    }
    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"
    }
  }
  measure: revenue_net_cn {
    label: "Revenue (Sales)"
    view_label: "Revenue"
    description: "Channel-neutral revenue (usd_revenue_net_cn) for accounts which are SMB, Corp, or GPS. Net-to-google revenue for commercial Select/Enterprise accounts."
    type: sum
    sql: ${usd_revenue_blended};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_net_cn]
    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.product_group,revenue.sku_id,revenue.sku_description\" }}&limit=10&sorts={{ _field._name }}+desc
      "
      label: "Top 10 SKUs"
      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"
    }
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_promo {
    group_label: "Discounts, Credits & BMODS"
    label: "Revenue (Promo)"
    view_label: "Revenue"
    description: "Other promotional credits applied against the Gross amount"
    type: sum
    sql: ${usd_revenue_promo};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_promo, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_reseller {
    group_label: "Discounts, Credits & BMODS"
    label: "Revenue (Reseller)"
    view_label: "Revenue"
    description: "Reseller Discount credits applied against the Gross amount."
    type: sum
    sql: ${usd_revenue_reseller};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_reseller, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_rvp {
    label: "Revenue (RVP)"
    view_label: "Revenue"
    description: "Revenue definition used by Region VPs.  See go/revenue-walk"
    type: sum
    sql: ${usd_revenue_rvp};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_net_cn]
    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.product_group,revenue.sku_id,revenue.sku_description\" }}&limit=10&sorts={{ _field._name }}+desc
      "
      label: "Top 10 SKUs"
      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"
    }
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_sud {
    group_label: "Discounts, Credits & BMODS"
    label: "Revenue (Sustained Usage Discount)"
    view_label: "Revenue"
    description: "Sustained Usage Discount credits applied against the Gross amount."
    type: sum
    sql: ${usd_revenue_sud};;
    value_format_name: usd_0
    drill_fields: [billing_account_id, revenue_sud, revenue_gross, revenue_net_cn]
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  measure: revenue_toggle {
    group_label: "Other Revenue"
    label: "Revenue (Toggle-able)"
    label_from_parameter: metric_selector
    view_label: "Revenue"
    description: "This parameter is for dashboard building only!  This allows users to select a metric type
    from a dashboard filter.  For example, the dashboard might default to using Gross Revenue, but the user
    can use this parameter to change to using 2021 Def. Sales Revenue instead.  Must be used with the
    Metric Selector parameter to select what this metric will display"
    type: sum
    sql:  {% if metric_selector._parameter_value == 'invoice' %} ${usd_revenue_net}
          {% elsif metric_selector._parameter_value == 'ntg' %} ${usd_revenue_ntg}
          {% elsif metric_selector._parameter_value == 'net_channel_neutral' %} ${usd_revenue_net_cn}
          {% elsif metric_selector._parameter_value == 'gross' %} ${usd_revenue_gross}
          {% elsif metric_selector._parameter_value == 'blended' %} ${usd_revenue_blended}
          {% elsif metric_selector._parameter_value == 'rvp' %} ${usd_revenue_rvp}
          {% endif %} ;;
    drill_fields: [billing_account_id, revenue_toggle]
    value_format_name: usd_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"
    }
    # Reference: https://community.looker.com/lookml-5/conditional-formatting-using-value-format-926
    # html: @{custom_dollar_formatting} ;;
  }
  #### PARAMETERS ####
  parameter: metric_selector {
    view_label: "Revenue"
    description: "This parameter is for dashboard building only.  This allows users to select a metric type
    from a dashboard filter.  For example, the dashboard might default to using Gross Revenue, but the user
    can use this parameter to change to using 2021 Def. Sales Revenue instead.  Must be used with the
    Toggleable Revenue Metric, and not the normal metrics."
    default_value: "blended"
    type: unquoted
    allowed_value: {
      label: "Revenue (Sales)"
      value: "blended"
    }
    allowed_value: {
      label: "Revenue (RVP)"
      value: "rvp"
    }
    allowed_value: {
      label: "Revenue (2021 Def.)"
      value: "net_channel_neutral"
    }
    allowed_value: {
      label: "Revenue (Invoice)"
      value: "invoice"
    }
    allowed_value: {
      label: "Revenue (Gross)"
      value: "gross"
    }
    allowed_value: {
      label: "Revenue (Net-to-Google)"
      value: "ntg"
    }
  }
  parameter: filter_nonmetered {
    view_label: "Revenue"
    label: "Remove Prepaid Purchases?"
    description: "Filters out Marketplace Prepaid Purchases, which can erroneously inflate forecasts.  Default is to filter these out."
    default_value: "false"
    type: unquoted
    allowed_value: {
      label: "Remove"
      value: "true"
    }
    allowed_value: {
      label: "Include"
      value: "false"
    }
  }
  parameter: usage_timeframe_selector {
    view_label: "Revenue"
    description: "Updates the `Dynamic Usage Timeframe` field based on selection of granularity."
    type: string
    default_value: "Date"
    allowed_value: {
      value: "Date"
    }
    allowed_value: {
      value: "Week"
    }
    allowed_value: {
      value: "Month"
    }
  }
}