Credits

view: credits {
  sql_table_name: public_credits ;;

  dimension: _id {
    primary_key: yes
    sql: ${TABLE}._id ;;
  }

  dimension: currency {
    sql: ${TABLE}.currency ;;
  }

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

  dimension: currency_amount_converted {
    label: "Currency Amount Converted to USD"
    type: number
    sql: ${TABLE}.currency_amount * ${TABLE}.payout_foreign_exchange_rate ;;
  }

  dimension: description {
    sql: ${TABLE}.description ;;
  }

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

  dimension: is_gift_order {
    type: yesno
    sql: ${TABLE}.is_gift_order ;;
  }

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

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

  dimension: purchase_sequence_number {
    type: number
    sql: (SELECT COUNT(*)
FROM public_credits c
WHERE c._id < ${TABLE}._id
AND c.user_id=${TABLE}.user_id) + 1 ;;
  }

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

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

  dimension_group: purchase {
    type: time
    timeframes: [time, date, week, month, dow]
    sql: FROM_UNIXTIME(${TABLE}.time) ;;
  }

  measure: count {
    type: count
  }

  measure: total_amount_usd {
    type: sum
    sql: ${currency_amount_converted} ;;
  }
}

- view: credits
  sql_table_name: public_credits
  fields:
  - dimension: _id
    primary_key: true
    sql: ${TABLE}._id
  - dimension: currency
    sql: ${TABLE}.currency
  - dimension: currency_amount
    type: number
    sql: ${TABLE}.currency_amount
  - dimension: currency_amount_converted
    type: number
    label: Currency Amount Converted to USD
    sql: ${TABLE}.currency_amount * ${TABLE}.payout_foreign_exchange_rate
  - dimension: description
    sql: ${TABLE}.description
  - dimension: gamebucks
    type: number
    sql: ${TABLE}.gamebucks
  - dimension: is_gift_order
    type: yesno
    sql: ${TABLE}.is_gift_order
  - dimension: payout_foreign_exchange_rate
    type: number
    sql: ${TABLE}.payout_foreign_exchange_rate
  - dimension: quantity
    type: int
    sql: ${TABLE}.quantity
  - dimension: purchase_sequence_number
    type: number
    sql: (SELECT COUNT(*)
FROM public_credits c
WHERE c._id < ${TABLE}._id
AND c.user_id=${TABLE}.user_id) + 1
  - dimension: usd_receipts_cents
    type: number
    sql: ${TABLE}.usd_receipts_cents
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension_group: purchase
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - dow
    sql: FROM_UNIXTIME(${TABLE}.time)
  - measure: count
    type: count
  - measure: total_amount_usd
    type: sum
    sql: ${currency_amount_converted}