view: itunes_us_dt_gross_units_by_date {
  sql_table_name: prod.effective_units.itunes_us_dt_gross_units_by_date ;;

  dimension_group: activity_month {
    type: time
    timeframes: [date, week, month, month_num, year]
    convert_tz: no
    sql: ${TABLE}.ACTIVITY_MONTH ;;
    hidden: yes
  }

  dimension: GROSS_US_ITUNES_DT_CAT {
    type: number
    sql: ${TABLE}.GROSS_US_ITUNES_DT ;;
    hidden: yes
  }

  dimension: UNITS_US_ITUNES_DT_CAT {
    type: number
    sql: ${TABLE}.UNITS_US_ITUNES_DT ;;
    hidden: yes
  }

  dimension: monthly_itunes_us_dt_rev {
    type: number
    sql: ${TABLE}.MONTHLY_ITUNES_US_DT_REV ;;
    hidden: yes
    value_format: "#,##0.00"
  }
}