view: orch_app_sales_goals_digital_marketing_projections_by_country {

  sql_table_name: orchard_app_reporting_v2.prod_sales_goals_sales_goals.digital_marketing_projections_by_country ;;

  dimension: id {
    type: number
    sql: ${TABLE}.id ;;
    primary_key: yes
    hidden: yes
  }

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

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

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

  dimension: downloads_projection_percentage {
    type: number
    sql: ${TABLE}.downloads_projection ;;
  }

  dimension: other_projection_percentage {
    type: number
    sql: ${TABLE}.other_projection ;;
  }

  #
  # # Define your dimensions and measures here, like this:
  # dimension: user_id {
  #   description: "Unique ID for each user that has ordered"
  #   type: number
  #   sql: ${TABLE}.user_id ;;
  # }
  #
  # dimension: lifetime_orders {
  #   description: "The total number of orders for each user"
  #   type: number
  #   sql: ${TABLE}.lifetime_orders ;;
  # }
  #

  # }
}