view: max_itunes_us_dt_gross_units_by_date {
  sql_table_name: prod.effective_units.MAX_ITUNES_US_DT_GROSS_UNITS_BY_DATE ;;

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

  dimension: max_gross_us_itunes_dt {
    type: number
    sql: ${TABLE}.MAX_GROSS_US_ITUNES_DT ;;
    hidden: yes
  }

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

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