view: manual_adjustment_category {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.manual_adjustment_category
      ;;


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

  dimension: category_id {
    type: number
    sql: ${TABLE}.CATEGORY_ID ;;
  }

  dimension: category {
    type: string
    sql: ${TABLE}.CATEGORY ;;
  }

  set: detail {
    fields: [category_id, category]
  }
}