Her Fact

view: her_fact {
  sql_table_name: public.her_fact ;;

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

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

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

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

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

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

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

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

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

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

  dimension: h_eher_qualified {
    type: yesno
    sql: ${TABLE}.h_eher_qualified ;;
  }

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

  dimension: h_key_bill_end {
    type: time
    sql: TO_DATE (${TABLE}.h_key_bill_end_date, 'YYYYMMDD') ;;
  }

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

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

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

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

  dimension: h_paper_qualified {
    type: yesno
    sql: ${TABLE}.h_paper_qualified ;;
  }

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

  dimension: h_sq_ft_tier {
    type: tier
    sql: ${h_sq_footage} ;;
  }

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

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

  measure: average_bill_consumption {
    type: average
    value_format: "#,### \" kWh\""
    sql: ${h_bill_consumption} ;;
  }

  measure: total_bill_consumption {
    type: sum
    value_format: "###### \" kWh\""
    sql: ${h_bill_consumption} ;;
  }

  measure: average_bill_cost {
    type: average
    value_format: "$#.00"
    sql: ${h_bill_cost} ;;
  }

  measure: total_bill_cost {
    type: sum
    value_format: "$####.00"
    sql: ${h_bill_cost} ;;
  }

  measure: average_daily_consumption {
    type: average
    value_format: "#,### \" kWh\""
    sql: ${h_daily_consumption} ;;
  }

  measure: avg_daily_cost {
    type: average
    value_format: "$#.00"
    sql: ${TABLE}.h_daily_cost ;;
  }

  measure: count {
    type: count
    drill_fields: [h_tenant_id, h_key_run_date, h_year_built, h_sq_footage, h_bill_cost, h_bill_consumption]
  }
}

- view: her_fact
  sql_table_name: public.her_fact
  fields:
  - dimension: h_action_id_1
    sql: ${TABLE}.h_action_id_1
  - dimension: h_action_id_2
    sql: ${TABLE}.h_action_id_2
  - dimension: h_action_savings_1
    type: number
    sql: ${TABLE}.h_action_savings_1
  - dimension: h_action_savings_2
    type: number
    sql: ${TABLE}.h_action_savings_2
  - dimension: h_bill_consumption
    type: number
    sql: ${TABLE}.h_bill_consumption
  - dimension: h_bill_cost
    type: number
    sql: ${TABLE}.h_bill_cost
  - dimension: h_bill_duration_days
    type: number
    sql: ${TABLE}.h_bill_duration_days
  - dimension: h_daily_consumption
    type: number
    sql: ${TABLE}.h_daily_consumption
  - dimension: h_daily_cost
    type: number
    sql: ${TABLE}.h_daily_cost
  - dimension: h_eher_dq_reason
    sql: ${TABLE}.h_eher_dq_reason
  - dimension: h_eher_qualified
    type: yesno
    sql: ${TABLE}.h_eher_qualified
  - dimension: h_id_internal
    type: int
    sql: ${TABLE}.h_id_internal
  - dimension: h_key_bill_end
    type: time
    sql: TO_DATE (${TABLE}.h_key_bill_end_date, 'YYYYMMDD')
  - dimension: h_key_run
    type: number
    sql: ${TABLE}.h_key_run
  - dimension: h_key_run_date
    sql: ${TABLE}.h_key_run_date
  - dimension: h_key_geo
    sql: ${TABLE}.h_key_geo
  - dimension: h_paper_dq_reason
    sql: ${TABLE}.h_paper_dq_reason
  - dimension: h_paper_qualified
    type: yesno
    sql: ${TABLE}.h_paper_qualified
  - dimension: h_sq_footage
    type: int
    sql: ${TABLE}.h_sq_footage
  - dimension: h_sq_ft_tier
    type: tier
    sql: ${h_sq_footage}
  - dimension: h_tenant_id
    sql: ${TABLE}.h_tenant_id
  - dimension: h_year_built
    type: int
    sql: ${TABLE}.h_year_built
  - measure: average_bill_consumption
    type: average
    value_format: '#,### " kWh"'
    sql: ${h_bill_consumption}
  - measure: total_bill_consumption
    type: sum
    value_format: '###### " kWh"'
    sql: ${h_bill_consumption}
  - measure: average_bill_cost
    type: average
    value_format: '$#.00'
    sql: ${h_bill_cost}
  - measure: total_bill_cost
    type: sum
    value_format: '$####.00'
    sql: ${h_bill_cost}
  - measure: average_daily_consumption
    type: average
    value_format: '#,### " kWh"'
    sql: ${h_daily_consumption}
  - measure: avg_daily_cost
    type: average
    value_format: '$#.00'
    sql: ${TABLE}.h_daily_cost
  - measure: count
    type: count
    drill_fields:
    - h_tenant_id
    - h_key_run_date
    - h_year_built
    - h_sq_footage
    - h_bill_cost
    - h_bill_consumption