User Credit Transactions

view: user_credit_transactions {
  sql_table_name: public.user_credit_transactions ;;

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

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

  dimension: admin_reason {
    type: string
    sql: ${TABLE}.admin_reason ;;
  }

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

  dimension: amount_currency {
    type: string
    sql: ${TABLE}.amount_currency ;;
  }

  dimension: credit_type {
    sql: (case when ${TABLE}.credit_type = 'CREDIT' then 'Issued' when ${TABLE}.credit_type = 'DEBIT' then 'Redeemed' else NULL end) ;;
  }

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

  dimension: sub_order_id {
    type: int
    hidden: yes
    sql: ${TABLE}.sub_order_id ;;
  }

  dimension: user_credit_id {
    type: int
    hidden: yes
    sql: ${TABLE}.user_credit_id ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [id, user_credits.id, sub_orders.id]
  }

  measure: sum_currency {
    type: sum
    value_format: "$#,##0.00"
    sql: ${amount_cents} / 100.0 ;;
  }
}

- view: user_credit_transactions
  sql_table_name: public.user_credit_transactions
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: admin_id
    type: int
    sql: ${TABLE}.admin_id
  - dimension: admin_reason
    type: string
    sql: ${TABLE}.admin_reason
  - dimension: amount_cents
    type: int
    sql: ${TABLE}.amount_cents
  - dimension: amount_currency
    type: string
    sql: ${TABLE}.amount_currency
  - dimension: credit_type
    sql: (case when ${TABLE}.credit_type = 'CREDIT' then 'Issued' when ${TABLE}.credit_type = 'DEBIT' then 'Redeemed' else NULL end)
  - dimension: payment_method_id
    type: int
    sql: ${TABLE}.payment_method_id
  - dimension: sub_order_id
    type: int
    hidden: true
    sql: ${TABLE}.sub_order_id
  - dimension: user_credit_id
    type: int
    hidden: true
    sql: ${TABLE}.user_credit_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - user_credits.id
    - sub_orders.id
  - measure: sum_currency
    type: sum
    value_format: '$#,##0.00'
    sql: ${amount_cents} / 100.0