Dispatch Projects

view: dispatch_projects {
  sql_table_name: public.dispatch_projects ;;

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

  dimension: beneficiaries {
    type: int
    sql: ${TABLE}.beneficiaries ;;
  }

  dimension: community_name {
    sql: ${TABLE}.community_name ;;
  }

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

  dimension: days_for_daily_average_liters {
    type: int
    sql: ${TABLE}.days_for_daily_average_liters ;;
  }

  dimension: deployment_code {
    sql: ${TABLE}.deployment_code ;;
  }

  dimension: district {
    sql: ${TABLE}.district ;;
  }

  dimension: grant_id {
    type: int
    sql: ${TABLE}.grant_id ;;
  }

  dimension: inventory_type {
    sql: ${TABLE}.inventory_type ;;
  }

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

  dimension: location_type {
    sql: ${TABLE}.location_type ;;
  }

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

  dimension: program_id {
    type: int
    sql: ${TABLE}.program_id ;;
  }

  dimension: site_name {
    sql: ${TABLE}.site_name ;;
  }

  dimension: state {
    sql: ${TABLE}.state ;;
  }

  dimension: status {
    type: int
    sql: ${TABLE}.status ;;
  }

  dimension: sub_district {
    sql: ${TABLE}.sub_district ;;
  }

  dimension: system_name {
    sql: ${TABLE}.system_name ;;
  }

  dimension: water_point_name {
    sql: ${TABLE}.water_point_name ;;
  }

  dimension: donor_org_id {
    type: int
    sql: ${TABLE}.donor_org_id ;;
  }

  dimension_group: created {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.created_at ;;
  }

  dimension_group: updated {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.updated_at ;;
  }

  measure: count {
    type: count
    drill_fields: [id, community_name, site_name, system_name, water_point_name]
  }

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

- view: dispatch_projects
  sql_table_name: public.dispatch_projects
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: beneficiaries
    type: int
    sql: ${TABLE}.beneficiaries
  - dimension: community_name
    sql: ${TABLE}.community_name
  - dimension: daily_average_liters
    type: number
    sql: ${TABLE}.daily_average_liters
  - dimension: days_for_daily_average_liters
    type: int
    sql: ${TABLE}.days_for_daily_average_liters
  - dimension: deployment_code
    sql: ${TABLE}.deployment_code
  - dimension: district
    sql: ${TABLE}.district
  - dimension: grant_id
    type: int
    sql: ${TABLE}.grant_id
  - dimension: inventory_type
    sql: ${TABLE}.inventory_type
  - dimension: latitude
    type: number
    sql: ${TABLE}.latitude
  - dimension: location_type
    sql: ${TABLE}.location_type
  - dimension: longitude
    type: number
    sql: ${TABLE}.longitude
  - dimension: program_id
    type: int
    sql: ${TABLE}.program_id
  - dimension: site_name
    sql: ${TABLE}.site_name
  - dimension: state
    sql: ${TABLE}.state
  - dimension: status
    type: int
    sql: ${TABLE}.status
  - dimension: sub_district
    sql: ${TABLE}.sub_district
  - dimension: system_name
    sql: ${TABLE}.system_name
  - dimension: water_point_name
    sql: ${TABLE}.water_point_name
  - dimension: donor_org_id
    type: int
    sql: ${TABLE}.donor_org_id
  - dimension_group: created
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - community_name
    - site_name
    - system_name
    - water_point_name
  - measure: total_in_district
    type: count
    drill_fields:
    - district