views/revenue.view.lkml

view: revenue_view {
  sql_table_name: `irvine-sbx2.gcc_internal.revenue`
    ;;

  dimension: billing_account_id {
    type: string
    sql: ${TABLE}.billing_account_id ;;
  }

  dimension: currency_code {
    type: string
    sql: ${TABLE}.currency_code ;;
  }

  dimension_group: invoice_month_start {
    type: time
    timeframes: [
      raw,
      date,
      week,
      month,
      quarter,
      year
    ]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.invoice_month_start ;;
  }

  dimension: product_group {
    type: string
    sql: ${TABLE}.product_group ;;
  }

  dimension: product_line {
    type: string
    sql: ${TABLE}.product_line ;;
  }

  dimension: segment {
    type: string
    sql: ${TABLE}.segment ;;
  }

  dimension: sfdc_account_id {
    type: string
    sql: ${TABLE}.sfdc_account_id ;;
  }

  dimension_group: usage {
    type: time
    timeframes: [
      raw,
      date,
      week,
      month,
      quarter,
      year
    ]
    convert_tz: no
    datatype: date
    sql: ${TABLE}.usage_date ;;
  }

  dimension: usd_revenue_cn {
    type: number
    sql: ${TABLE}.usd_revenue_cn ;;
  }

  dimension: usd_revenue_gross {
    type: number
    sql: ${TABLE}.usd_revenue_gross ;;
  }

  dimension: usd_revenue_net {
    type: number
    sql: ${TABLE}.usd_revenue_net ;;
  }

  measure: count {
    type: count
    drill_fields: []
  }
}