view: facts_prod_fact_analytics_for_master_calendar {
  sql_table_name: facts.prod.fact_analytics ;;

  dimension: dayid {
    type: number
    sql: ${TABLE}.dayid ;;
    hidden: no
    primary_key: yes
  }

  dimension: feedid {
    view_label: "Data Source"
    label: "Feed ID"
    type: number
    sql: ${TABLE}.feedid ;;
    value_format: "0"
  }

  dimension: labelid {
    view_label: "Data Source"
    label: "Label ID"
    type: number
    sql: ${TABLE}.labelid ;;
    value_format: "0"
  }

  dimension: licensorid {
    view_label: "Data Source"
    label: "Licensor ID"
    type: number
    sql: ${TABLE}.licensorid ;;
    value_format: "0"
  }

  measure: units {
    view_label: "Units"
    type: number
    sql: COALESCE(SUM(${TABLE}.units), 0) ;;
  }

}