view: store_physical_sales_goal {
  sql_table_name: orchard_app_reporting_v2.prod_sales_goals_sales_goals.store ;;

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

  dimension: id {
    type: number
    sql: ${TABLE}.ID ;;
  }

  dimension: name {
    type: string
    sql: ${TABLE}.NAME ;;
  }

  set: detail {
    fields: [id, name]
  }
}