Batch Analytic Fact

view: batch_analytic_fact {
  sql_table_name: public.batch_analytic_fact ;;

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

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

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

  dimension: batch_analytic_key_production_date {
    label: "Production Date"
    value_format: "yyyy mmm dd"
    sql: ${TABLE}.batch_analytic_key_production_date ;;
  }

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

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

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

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

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

  dimension: batch_analytic_action_savings_1 {
    type: number
    value_format: "$#.00"
    sql: ${TABLE}.batch_analytic_action_savings_1 ;;
  }

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

  dimension: batch_analytic_action_savings_2 {
    type: number
    value_format: "$#.00"
    sql: ${TABLE}.batch_analytic_action_savings_2 ;;
  }

  dimension: batch_analytic_avg_bill_consumption {
    type: number
    value_format: "#,### \" kWh\""
    sql: ${TABLE}.batch_analytic_avg_bill_consumption ;;
  }

  dimension: batch_analytic_avg_bill_cost {
    type: number
    value_format: "$#.00"
    sql: ${TABLE}.batch_analytic_avg_bill_cost ;;
  }

  dimension: batch_analytic_bill_consumption {
    type: number
    value_format: "#,### \" kWh\""
    sql: ${TABLE}.batch_analytic_bill_consumption ;;
  }

  dimension: batch_analytic_bill_cost {
    type: number
    value_format: "$#.00"
    sql: ${TABLE}.batch_analytic_bill_cost ;;
  }

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

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

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

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

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

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

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

  dimension: batch_analytic_cooling_type {
  }

  dimension: batch_analytic_daily_consumption {
    type: number
    value_format: "#,### \" kWh\""
    sql: ${TABLE}.batch_analytic_daily_consumption ;;
  }

  dimension: batch_analytic_daily_cost {
    type: number
    value_format: "$#.00"
    sql: ${TABLE}.batch_analytic_daily_cost ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: treatment_group {
    sql: CASE
WHEN ${batch_analytic_group_treatment} = 'Yes' THEN 'Treatment'
ELSE 'Not Treatment'
END ;;
  }

  dimension: control_group {
    sql: CASE
WHEN ${batch_analytic_group_control} = 'Yes' THEN 'Control'
ELSE 'Not Control'
END ;;
  }

  dimension: duke_treatment_control_group {
    sql: CASE
WHEN ${batch_analytic_group_control} = 'No' THEN 'Treatment'
ELSE 'Control'
END ;;
  }

  dimension: vip_group {
    sql: CASE
WHEN ${batch_analytic_group_vip} = 'Yes' THEN 'VIP'
ELSE 'Not VIP'
END ;;
  }

  dimension: batch_analytic_heating_type {
  }

  dimension: batch_analytic_home_type {
  }

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

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

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

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

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

  dimension: batch_analytic_most_efficient_bill_consumption {
    type: number
    value_format: "#,### \" kWh\""
    sql: ${TABLE}.batch_analytic_most_efficient_bill_consumption ;;
  }

  dimension: batch_analytic_most_efficient_bill_cost {
    type: number
    value_format: "$#.00"
    sql: ${TABLE}.batch_analytic_most_efficient_bill_cost ;;
  }

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

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

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

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

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

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

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

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

  dimension: eher_received {
    sql: CASE
WHEN ${batch_analytic_received_paper_this_cycle} = 'Yes' THEN 'eHER received'
ELSE 'No eHer'
END ;;
  }

  dimension: paper_received {
    sql: CASE
WHEN ${batch_analytic_received_eher_this_cycle} = 'Yes' THEN 'Paper HER received'
ELSE 'No Paper HER'
END ;;
  }

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

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

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

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

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

  dimension_group: batch_analytic_key_promotion {
    type: time
    timeframes: [date, week, year, day_of_week, day_of_month, month]
    sql: TO_DATE (${TABLE}.batch_analytic_key_promotion_date, 'YYYYMMDD') ;;
  }

  measure: average_action_savings_1 {
    type: average
    value_format: "$#.00"
    sql: ${batch_analytic_action_savings_1} ;;
  }

  measure: stdev_action_savings_1 {
    type: number
    value_format: "$#.00"
    sql: STDDEV(${batch_analytic_action_savings_1}) ;;
  }

  measure: min_h_action_savings_1 {
    type: min
    value_format: "$#.00"
    sql: ${batch_analytic_action_savings_1} ;;
  }

  measure: max_h_action_savings_1 {
    type: max
    value_format: "$#.00"
    sql: ${batch_analytic_action_savings_1} ;;
  }

  measure: average_action_savings_2 {
    type: average
    value_format: "$#.00"
    sql: ${batch_analytic_action_savings_2} ;;
  }

  measure: stdev_action_savings_2 {
    type: number
    value_format: "$#.00"
    sql: STDDEV(${batch_analytic_action_savings_2}) ;;
  }

  measure: min_h_action_savings_2 {
    type: min
    value_format: "$#.00"
    sql: ${batch_analytic_action_savings_2} ;;
  }

  measure: max_h_action_savings_2 {
    type: max
    value_format: "$#.00"
    sql: ${batch_analytic_action_savings_2} ;;
  }

  measure: batch_analytic_avg_daily_consumption {
    type: average
    value_format: "#,### \" kWh\""
    sql: ${batch_analytic_daily_consumption} ;;
  }

  measure: batch_analytic_avg_daily_cost {
    type: average
    value_format: "$#.00"
    sql: ${batch_analytic_daily_cost} ;;
  }

  measure: batch_analytic_daily_consumption_per_sq_foot {
    type: number
    sql: ${batch_analytic_daily_consumption} / NULLIF(${batch_analytic_sq_footage}, 0) ;;
  }

  measure: batch_analytic_avg_daily_consumption_per_sq_foot {
    type: average
    sql: ${batch_analytic_daily_consumption_per_sq_foot} ;;
  }

  measure: control_group_count {
    type: count
    filters: [batch_analytic_group_control: "Yes"]
  }

  measure: treatment_group_count {
    type: count
    filters: [batch_analytic_group_treatment: "Yes"]
  }

  measure: partner_treatment_group_count {
    type: count
    filters: [batch_analytic_group_control: "No"]
  }

  measure: control_group_percent {
    type: number
    value_format: "#.00\%"
    sql: 100.0 * ${control_group_count} / ${count} ;;
  }

  measure: treatment_group_percent {
    type: number
    value_format: "#.00\%"
    sql: 100.0 * ${treatment_group_count} / ${count} ;;
  }

  measure: partner_treatment_group_percent {
    type: number
    value_format: "#.00\%"
    sql: 100.0 * ${partner_treatment_group_count} / ${count} ;;
  }

  measure: count {
    type: count
  }
}

- view: batch_analytic_fact
  sql_table_name: public.batch_analytic_fact
  fields:
  - dimension: batch_analytic_id_internal
    type: int
    sql: ${TABLE}.batch_analytic_id_internal
  - dimension: batch_analytic_key_bill_end_date
    sql: ${TABLE}.batch_analytic_key_bill_end_date
  - dimension: batch_analytic_key_geo
    sql: ${TABLE}.batch_analytic_key_geo
  - dimension: batch_analytic_key_production_date
    label: Production Date
    value_format: yyyy mmm dd
    sql: ${TABLE}.batch_analytic_key_production_date
  - dimension: batch_analytic_key_production_id
    sql: ${TABLE}.batch_analytic_key_production_id
  - dimension: batch_analytic_key_promotion_id
    sql: ${TABLE}.batch_analytic_key_promotion_id
  - dimension: batch_analytic_tenant_id
    type: int
    sql: ${TABLE}.batch_analytic_tenant_id
  - dimension: batch_analytic_tenant_group
    sql: ${TABLE}.batch_analytic_tenant_group
  - dimension: batch_analytic_action_id_1
    sql: ${TABLE}.batch_analytic_action_id_1
  - dimension: batch_analytic_action_savings_1
    type: number
    value_format: '$#.00'
    sql: ${TABLE}.batch_analytic_action_savings_1
  - dimension: batch_analytic_action_id_2
    sql: ${TABLE}.batch_analytic_action_id_2
  - dimension: batch_analytic_action_savings_2
    type: number
    value_format: '$#.00'
    sql: ${TABLE}.batch_analytic_action_savings_2
  - dimension: batch_analytic_avg_bill_consumption
    type: number
    value_format: '#,### " kWh"'
    sql: ${TABLE}.batch_analytic_avg_bill_consumption
  - dimension: batch_analytic_avg_bill_cost
    type: number
    value_format: '$#.00'
    sql: ${TABLE}.batch_analytic_avg_bill_cost
  - dimension: batch_analytic_bill_consumption
    type: number
    value_format: '#,### " kWh"'
    sql: ${TABLE}.batch_analytic_bill_consumption
  - dimension: batch_analytic_bill_cost
    type: number
    value_format: '$#.00'
    sql: ${TABLE}.batch_analytic_bill_cost
  - dimension: batch_analytic_bill_duration_days
    type: number
    sql: ${TABLE}.batch_analytic_bill_duration_days
  - dimension: batch_analytic_bill_month
    type: number
    sql: ${TABLE}.batch_analytic_bill_month
  - dimension: batch_analytic_bill_year
    type: number
    sql: ${TABLE}.batch_analytic_bill_year
  - dimension: batch_analytic_comparison_callout_amount
    sql: ${TABLE}.batch_analytic_comparison_callout_amount
  - dimension: batch_analytic_comparison_callout_text
    sql: ${TABLE}.batch_analytic_comparison_callout_text
  - dimension: batch_analytic_comparison_historical_amount
    sql: ${TABLE}.batch_analytic_comparison_historical_amount
  - dimension: batch_analytic_comparison_historical_text
    sql: ${TABLE}.batch_analytic_comparison_historical_text
  - dimension: batch_analytic_cooling_type
  - dimension: batch_analytic_daily_consumption
    type: number
    value_format: '#,### " kWh"'
    sql: ${TABLE}.batch_analytic_daily_consumption
  - dimension: batch_analytic_daily_cost
    type: number
    value_format: '$#.00'
    sql: ${TABLE}.batch_analytic_daily_cost
  - dimension: batch_analytic_dq_already_received_eher
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_already_received_eher
  - dimension: batch_analytic_dq_bill_implausible_duration_long
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_bill_implausible_duration_long
  - dimension: batch_analytic_dq_bill_implausible_duration_short
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_bill_implausible_duration_short
  - dimension: batch_analytic_dq_bill_implausible_high
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_bill_implausible_high
  - dimension: batch_analytic_dq_bill_implausible_low
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_bill_implausible_low
  - dimension: batch_analytic_dq_bill_overlapping
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_bill_overlapping
  - dimension: batch_analytic_dq_bill_too_few_historical
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_bill_too_few_historical
  - dimension: batch_analytic_dq_location_state_invalid
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_location_state_invalid
  - dimension: batch_analytic_dq_neighborhood_small
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_neighborhood_small
  - dimension: batch_analytic_dq_no_current_bill
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_no_current_bill
  - dimension: batch_analytic_dq_verimove_undeliverable
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_verimove_undeliverable
  - dimension: batch_analytic_dq_wrong_type_homeowner
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_wrong_type_homeowner
  - dimension: batch_analytic_dq_wrong_type_household
    type: yesno
    sql: ${TABLE}.batch_analytic_dq_wrong_type_household
  - dimension: batch_analytic_eher_dq_reason
    sql: ${TABLE}.batch_analytic_eher_dq_reason
  - dimension: batch_analytic_eher_invalid_email
    type: yesno
    sql: ${TABLE}.batch_analytic_eher_invalid_email
  - dimension: batch_analytic_eher_qualified
    type: yesno
    sql: ${TABLE}.batch_analytic_eher_qualified
  - dimension: batch_analytic_eher_voluntary_opt_out
    type: yesno
    sql: ${TABLE}.batch_analytic_eher_voluntary_opt_out
  - dimension: batch_analytic_free_form_text_1
    sql: ${TABLE}.batch_analytic_free_form_text_1
  - dimension: batch_analytic_free_form_text_2
    sql: ${TABLE}.batch_analytic_free_form_text_2
  - dimension: batch_analytic_group_control
    type: yesno
    sql: ${TABLE}.batch_analytic_group_control
  - dimension: batch_analytic_group_treatment
    type: yesno
    sql: ${TABLE}.batch_analytic_group_treatment
  - dimension: batch_analytic_group_vip
    type: yesno
    sql: ${TABLE}.batch_analytic_group_vip
  - dimension: treatment_group
    sql: CASE
WHEN ${batch_analytic_group_treatment} = 'Yes' THEN 'Treatment'
ELSE 'Not Treatment'
END
  - dimension: control_group
    sql: CASE
WHEN ${batch_analytic_group_control} = 'Yes' THEN 'Control'
ELSE 'Not Control'
END
  - dimension: duke_treatment_control_group
    sql: CASE
WHEN ${batch_analytic_group_control} = 'No' THEN 'Treatment'
ELSE 'Control'
END
  - dimension: vip_group
    sql: CASE
WHEN ${batch_analytic_group_vip} = 'Yes' THEN 'VIP'
ELSE 'Not VIP'
END
  - dimension: batch_analytic_heating_type
  - dimension: batch_analytic_home_type
  - dimension: batch_analytic_homeowner_type
    type: number
    sql: ${TABLE}.batch_analytic_homeowner_type
  - dimension: batch_analytic_max_dwelling_size
    type: int
    sql: ${TABLE}.batch_analytic_max_dwelling_size
  - dimension: batch_analytic_max_year_built
    type: number
    sql: ${TABLE}.batch_analytic_max_year_built
  - dimension: batch_analytic_min_dwelling_size
    type: int
    sql: ${TABLE}.batch_analytic_min_dwelling_size
  - dimension: batch_analytic_min_year_built
    type: number
    sql: ${TABLE}.batch_analytic_min_year_built
  - dimension: batch_analytic_most_efficient_bill_consumption
    type: number
    value_format: '#,### " kWh"'
    sql: ${TABLE}.batch_analytic_most_efficient_bill_consumption
  - dimension: batch_analytic_most_efficient_bill_cost
    type: number
    value_format: '$#.00'
    sql: ${TABLE}.batch_analytic_most_efficient_bill_cost
  - dimension: batch_analytic_neighborhood_id
    sql: ${TABLE}.batch_analytic_neighborhood_id
  - dimension: batch_analytic_neighborhood_size
    type: int
    sql: ${TABLE}.batch_analytic_neighborhood_size
  - dimension: batch_analytic_paper_dq_reason
    sql: ${TABLE}.batch_analytic_paper_dq_reason
  - dimension: batch_analytic_paper_qualified
    type: yesno
    sql: ${TABLE}.batch_analytic_paper_qualified
  - dimension: batch_analytic_paper_voluntary_opt_out
    type: yesno
    sql: ${TABLE}.batch_analytic_paper_voluntary_opt_out
  - dimension: batch_analytic_post_filtered
    type: yesno
    sql: ${TABLE}.batch_analytic_post_filtered
  - dimension: batch_analytic_received_eher_this_cycle
    type: yesno
    sql: ${TABLE}.batch_analytic_received_eher_this_cycle
  - dimension: batch_analytic_received_paper_this_cycle
    type: yesno
    sql: ${TABLE}.batch_analytic_received_paper_this_cycle
  - dimension: eher_received
    sql: CASE
WHEN ${batch_analytic_received_paper_this_cycle} = 'Yes' THEN 'eHER received'
ELSE 'No eHer'
END
  - dimension: paper_received
    sql: CASE
WHEN ${batch_analytic_received_eher_this_cycle} = 'Yes' THEN 'Paper HER received'
ELSE 'No Paper HER'
END
  - dimension: batch_analytic_simplified_heating_type
    type: number
    sql: ${TABLE}.batch_analytic_simplified_heating_type
  - dimension: batch_analytic_sq_footage
    type: int
    sql: ${TABLE}.batch_analytic_sq_footage
  - dimension: batch_analytic_verimode_address_code
    sql: ${TABLE}.batch_analytic_verimode_address_code
  - dimension: batch_analytic_welcome_letter
    type: yesno
    sql: ${TABLE}.batch_analytic_welcome_letter
  - dimension: batch_analytic_year_built
    type: int
    sql: ${TABLE}.batch_analytic_year_built
  - dimension_group: batch_analytic_key_promotion
    type: time
    timeframes:
    - date
    - week
    - year
    - day_of_week
    - day_of_month
    - month
    sql: TO_DATE (${TABLE}.batch_analytic_key_promotion_date, 'YYYYMMDD')
  - measure: average_action_savings_1
    type: average
    value_format: '$#.00'
    sql: ${batch_analytic_action_savings_1}
  - measure: stdev_action_savings_1
    type: number
    value_format: '$#.00'
    sql: STDDEV(${batch_analytic_action_savings_1})
  - measure: min_h_action_savings_1
    type: min
    value_format: '$#.00'
    sql: ${batch_analytic_action_savings_1}
  - measure: max_h_action_savings_1
    type: max
    value_format: '$#.00'
    sql: ${batch_analytic_action_savings_1}
  - measure: average_action_savings_2
    type: average
    value_format: '$#.00'
    sql: ${batch_analytic_action_savings_2}
  - measure: stdev_action_savings_2
    type: number
    value_format: '$#.00'
    sql: STDDEV(${batch_analytic_action_savings_2})
  - measure: min_h_action_savings_2
    type: min
    value_format: '$#.00'
    sql: ${batch_analytic_action_savings_2}
  - measure: max_h_action_savings_2
    type: max
    value_format: '$#.00'
    sql: ${batch_analytic_action_savings_2}
  - measure: batch_analytic_avg_daily_consumption
    type: average
    value_format: '#,### " kWh"'
    sql: ${batch_analytic_daily_consumption}
  - measure: batch_analytic_avg_daily_cost
    type: average
    value_format: '$#.00'
    sql: ${batch_analytic_daily_cost}
  - measure: batch_analytic_daily_consumption_per_sq_foot
    type: number
    sql: ${batch_analytic_daily_consumption} / NULLIF(${batch_analytic_sq_footage}, 0)
  - measure: batch_analytic_avg_daily_consumption_per_sq_foot
    type: average
    sql: ${batch_analytic_daily_consumption_per_sq_foot}
  - measure: control_group_count
    type: count
    filters:
    - batch_analytic_group_control: Yes
  - measure: treatment_group_count
    type: count
    filters:
    - batch_analytic_group_treatment: Yes
  - measure: partner_treatment_group_count
    type: count
    filters:
    - batch_analytic_group_control: No
  - measure: control_group_percent
    type: number
    value_format: '#.00\%'
    sql: 100.0 * ${control_group_count} / ${count}
  - measure: treatment_group_percent
    type: number
    value_format: '#.00\%'
    sql: 100.0 * ${treatment_group_count} / ${count}
  - measure: partner_treatment_group_percent
    type: number
    value_format: '#.00\%'
    sql: 100.0 * ${partner_treatment_group_count} / ${count}
  - measure: count
    type: count