User Subscriptions

view: user_subscriptions {
  sql_table_name: core_data.user_subscriptions ;;

  dimension: id {
    type: int
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

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

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

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

  dimension_group: start {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.start_date ;;
  }

  dimension_group: updated {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.updated_date ;;
  }

  measure: count {
    type: count
    drill_fields: [id]
  }

  measure: totalrevenue {
    type: sum
    value_format: "$#,##0.00"
    sql: ${amount} ;;
  }
}

- view: user_subscriptions
  sql_table_name: core_data.user_subscriptions
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: amount
    type: number
    sql: ${TABLE}.amount
  - dimension: subscription_type
    type: int
    sql: ${TABLE}.subscription_type
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension_group: start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.start_date
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_date
  - measure: count
    type: count
    drill_fields:
    - id
  - measure: totalrevenue
    type: sum
    value_format: '$#,##0.00'
    sql: ${amount}