########################################################
#
# Author: hillz@
# Updated Date: Oct 6, 2021 Def.
# Fields related to "Revenue" from the revenue table
# Meant to be extended into the revenue view
# Primary key will be in the primary (revenue) view
#
########################################################

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: {% 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_sales {
    hidden: yes
    view_label: "Revenue"
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.sales_revenue ;;
  }

  dimension: usd_revenue_invoice {
    hidden: yes
    view_label: "Revenue"
    sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.invoice_revenue ;;
  }

  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_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 ;;
  }

  ## Metric Components

  # Invoice Revenue

  dimension: usd_invoice_revenue_components_gross {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    description: "Gross Revenue component of Invoice Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_gross ;;
  }

  dimension: usd_invoice_revenue_components_sud {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    description: "SUD component of Invoice Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_sud ;;
  }

  dimension: usd_invoice_revenue_components_cud {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    description: "CUD component of Invoice Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_cud ;;
  }

  dimension: usd_invoice_revenue_components_ft {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    description: "FT component of Invoice Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_ft ;;
  }

  dimension: usd_invoice_revenue_components_promo {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    description: "Promo component of Invoice Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_promo ;;
  }

  dimension: usd_invoice_revenue_components_reseller_credit {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    description: "Reseller Credit component of Invoice Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.revenue_reseller_credit ;;
  }

  dimension: usd_invoice_revenue_components_cross_pa_credits_addback {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    description: "xPA component of Invoice Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.invoice_revenue.components.cross_pa_credits_addback ;;
  }

## Metric Components

# Sales Revenue

  dimension: usd_sales_revenue_components_gross {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "Gross Revenue component of Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_gross ;;
  }

  dimension: usd_sales_revenue_components_sud {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "SUD component of Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_sud ;;
  }

  dimension: usd_sales_revenue_components_cud {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "CUD component of Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_cud ;;
  }

  dimension: usd_sales_revenue_components_ft {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "FT component of Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_ft ;;
  }

  dimension: usd_sales_revenue_components_promo {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "Promo component of Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_promo ;;
  }

  dimension: usd_sales_revenue_components_reseller_credit {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "Reseller Credit component of Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.revenue_reseller_credit ;;
  }

  dimension: usd_sales_revenue_components_cross_pa_credits_addback {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "xPA component of Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.cross_pa_credits_addback ;;
  }

  dimension: usd_sales_revenue_components_partner_margin_addback {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "Partner Margin addback component of Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.partner_margin_addback ;;
  }


  dimension: usd_sales_revenue_components_isv_tier {
    hidden:  no
    label: "ISV Tier"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "ISV tier used to calculate marketplace tier adjustment in Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.isv_tier ;;
  }

  dimension: usd_sales_revenue_components_isv_deduction {
    hidden:  yes
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    description: "Marketplace ISV deduction in Sales Revenue calculation."
    sql: ${TABLE}.usd_revenue_metrics.sales_revenue.components.isv_deduction ;;
  }


  #### MEASURES ####
  measure: revenue_invoice {
    alias: [revenue_actuals]
    label: "Revenue (Invoice)"
    view_label: "Revenue"
    description: "Invoice Revenue, aligned with go/revenue-walk."
    type: sum
    sql: ${usd_revenue_invoice};;
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, revenue_invoice, revenue_net_cn]
    link: {
      url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.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, \"=\" }}&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: \".reporting_account_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: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
      {{ link | replace: column_name, \"=vector_customers.is_digital_native\" }}&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: \".reporting_account_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: \".reporting_account_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: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.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: [reporting_account_name
      , 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"
    }
  }

  # TODO: delete this measure during a scheduled maintenance window, and replace with a measure pointing to `usd_revenue_net_cn` directly

  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} ;;
  }


  # TODO: unhide this measure once we have re-pointed usd_revenue_net_cn

  measure: revenue_sales {
    label: "Revenue (Sales)"
    hidden:  no
    view_label: "Revenue"
    description: "Sales Revenue, aligned with go/revenue-walk."
    type: sum
    sql: ${usd_revenue_sales};;
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, revenue_sales]
    link: {
      url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.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, \"=\" }}&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: \".reporting_account_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: \".reporting_account_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: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
      {{ link | replace: column_name, \"=vector_customers.is_digital_native\" }}&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: \".reporting_account_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: \".reporting_account_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: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.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_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: [reporting_account_name, 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}
          {% endif %} ;;
    drill_fields: [reporting_account_name, billing_account_id, revenue_toggle]
    value_format_name: usd_0
    link: {
      url: "{{ link | replace: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.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, \"=\" }}&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: \".reporting_account_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: \".reporting_account_name,\" | append: _view._name | append: \".billing_account_id\" %}
      {{ link | replace: column_name, \"=vector_customers.is_digital_native\" }}&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: \".reporting_account_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: \".reporting_account_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: \"revenue.reporting_account_name,revenue.billing_account_id\", \"revenue.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} ;;
  }

  ## Metric Components

  # Invoice Revenue

  measure: invoice_revenue_components_gross {
    label: "Gross Revenue (Invoice Component)"
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_gross, revenue_invoice]
    #html: @{custom_dollar_formatting} ;;
    description: "Gross Revenue component of Invoice Revenue calculation."
    sql: ${usd_invoice_revenue_components_gross} ;;
  }

  measure: invoice_revenue_components_sud {
    label: "SUDs (Invoice Component)"
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_sud, revenue_invoice]
    #html: @{custom_dollar_formatting} ;;
    description: "SUD component of Invoice Revenue calculation."
    sql: ${usd_invoice_revenue_components_sud} ;;
  }

  measure: invoice_revenue_components_cud {
    label: "CUDs (Invoice Component)"
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_cud, revenue_invoice]
    #html: @{custom_dollar_formatting} ;;
    description: "CUD component of Invoice Revenue calculation."
    sql: ${usd_invoice_revenue_components_cud} ;;
  }

  measure: invoice_revenue_components_ft {
    label: "Free Trial Credits (Invoice Component)"
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_ft, revenue_invoice]
    #html: @{custom_dollar_formatting} ;;
    description: "FT component of Invoice Revenue calculation."
    sql: ${usd_invoice_revenue_components_ft} ;;
  }

  measure: invoice_revenue_components_promo {
    label: "Promo Credits (Invoice Component)"
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_promo, revenue_invoice]
    #html: @{custom_dollar_formatting} ;;
    description: "Promo component of Invoice Revenue calculation."
    sql: ${usd_invoice_revenue_components_promo} ;;
  }

  measure: invoice_revenue_components_reseller_credit {
    label: "Reseller Margin (Invoice Component)"
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_reseller_credit, revenue_invoice]
    #html: @{custom_dollar_formatting} ;;
    description: "Reseller Credit component of Invoice Revenue calculation."
    sql: ${usd_invoice_revenue_components_reseller_credit} ;;
  }

  measure: invoice_revenue_components_cross_pa_credits_addback {
    label: "xPA Credit Addback (Invoice Component)"
    view_label: "Revenue"
    group_label: "Invoice Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_invoice_revenue_components_cross_pa_credits_addback, revenue_invoice]
    #html: @{custom_dollar_formatting} ;;
    description: "xPA component of Invoice Revenue calculation."
    sql: ${usd_invoice_revenue_components_cross_pa_credits_addback} ;;
  }

# Sales Revenue

  measure: sales_revenue_components_gross {
    label: "Gross Revenue (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_gross, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "Gross Revenue component of Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_gross} ;;
  }

  measure: sales_revenue_components_sud {
    label: "SUDs (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_sud, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "SUD component of Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_sud} ;;
  }

  measure: sales_revenue_components_cud {
    label: "CUDs (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_cud, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "CUD component of Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_cud} ;;
  }

  measure: sales_revenue_components_ft {
    label: "Free Trial Credits (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_ft, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "FT component of Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_ft} ;;
  }

  measure: sales_revenue_components_promo {
    label: "Promo Credits (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_promo, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "Promo component of Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_promo} ;;
  }

  measure: sales_revenue_components_reseller_credit {
    label: "Reseller Margin (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_reseller_credit, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "Reseller Credit component of Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_reseller_credit} ;;
  }

  measure: sales_revenue_components_cross_pa_credits_addback {
    label: "xPA Credit Addback (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_cross_pa_credits_addback, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "xPA component of Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_cross_pa_credits_addback} ;;
  }

  measure: sales_revenue_components_partner_margin_addback {
    label: "Partner Margin Addback (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_partner_margin_addback, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "Partner Margin addback component of Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_partner_margin_addback} ;;
  }

  measure: sales_revenue_components_isv_deduction {
    label: "ISV Deduction (Sales Component)"
    view_label: "Revenue"
    group_label: "Sales Revenue Components"
    type: sum
    value_format_name: usd_0
    drill_fields: [reporting_account_name, billing_account_id, usd_sales_revenue_components_isv_deduction, revenue_sales]
    #html: @{custom_dollar_formatting} ;;
    description: "Marketplace ISV deduction in Sales Revenue calculation."
    sql: ${usd_sales_revenue_components_isv_deduction} ;;
  }

  #### 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 (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"
    }
  }

}