view: facts_prod_metrics_by_channel_country_feed_distributor_rollup {
  sql_table_name: facts.prod.metrics_by_channel_country_feed_distributor_rollup ;;

  dimension: feedid {
    type: number
    hidden: yes
    sql: ${TABLE}.feed_id ;;
  }

  dimension: channel_id {
    type: string
    label: "Channel ID"
    view_label: "Channel"
    sql: ${TABLE}.channel_id ;;
  }

  dimension: country_code {
    type: string
    label: "Country Code"
    view_label: "Transaction Country"
    sql: ${TABLE}.country_code ;;
  }

  dimension: distributor {
    type: string
    hidden: yes
    sql: ${TABLE}.distributor ;;
  }

  dimension: channel_owner {
    type: string
    label: "Channel Owner"
    view_label: "Channel"
    sql: ${TABLE}.channel_owner ;;
  }

  dimension: is_in_mcn {
    type: string
    label: "Is in MCN (True/ False)"
    view_label: "Channel"
    sql: ${TABLE}.is_in_mcn ;;
  }

  dimension: subscriber_count {
    label: "Subscribers"
    view_label: "Metrics"
    type: number
    sql: ${TABLE}.subscriber_count ;;
    value_format: "#,##0"
  }

  measure: total_views {
    label: "All time Views"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.total_views ;;
    value_format: "#,##0"
  }

  measure: total_estimated_gross_revenue {
    label: "All time Estimated Gross Revenue"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.total_estimated_gross_revenue ;;
    value_format: "$#,##0.00"
  }

  measure: average_view_duration_seconds {
    label: "Average View Duration(Minutes)"
    view_label: "Metrics"
    type: average
    sql: ${TABLE}.average_view_duration_seconds/60 ;;
    value_format: "#,##0.00"
  }

  measure: views_1_month_back {
    label: "Previous month Views"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.views_1_month_back ;;
    value_format: "#,##0"
  }

  measure: views_2_months_back {
    label: "Views(2 months ago)"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.views_2_months_back ;;
    value_format: "#,##0"
  }

  measure: views_3_months_back {
    label: "Views(3 months ago)"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.views_3_months_back ;;
    value_format: "#,##0"
  }

  measure: views_4_months_back {
    label: "Views(4 months ago)"
    view_label: "Metrics"
    type: sum
    sql: ${TABLE}.views_4_months_back ;;
    value_format: "#,##0"
  }


}