Page Received Donation Supporter

view: page_received_donation_supporter {
  sql_table_name: production.page_received_donation_supporter ;;

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

  dimension: amount_number {
    value_format: "#,##0.00"
    sql: CAST(REPLACE(SUBSTRING(${amount},2,99999),',','') AS FLOAT) ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  dimension: pk {
    primary_key: yes
    hidden: yes
    sql: ${event_id} || ${TABLE}.sent_at || ${user_id} ;;
  }

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

  dimension_group: received {
    type: time
    timeframes: [time, date, week, month, month_num, year]
    sql: ${TABLE}.received_at ;;
  }

  dimension_group: sent {
    type: time
    timeframes: [time, date, week, month]
    convert_tz: no
    sql: ${TABLE}.sent_at ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  measure: total_amount_cents {
    type: sum
    drill_fields: [detail*]
    sql: ${amount_cents} ;;
  }

  measure: average_amount_cents {
    type: average
    drill_fields: [detail*]
    sql: ${amount_cents} ;;
  }

  measure: total_amount {
    type: sum
    value_format: "$#,##0.00"
    drill_fields: [detail*]
    sql: ${amount_number} ;;
  }

  measure: average_amount {
    type: average
    value_format: "$#,##0.00"
    drill_fields: [detail*]
    sql: ${amount_number} ;;
  }
}

- view: page_received_donation_supporter
  sql_table_name: production.page_received_donation_supporter
  fields:
  - dimension: amount
    type: number
    sql: ${TABLE}.amount
  - dimension: amount_number
    value_format: '#,##0.00'
    sql: CAST(REPLACE(SUBSTRING(${amount},2,99999),',','') AS FLOAT)
  - dimension: amount_cents
    type: number
    sql: ${TABLE}.amount_cents
  - dimension: campaign_uuid
    sql: ${TABLE}.campaign_uuid
  - dimension: charity_uuid
    sql: ${TABLE}.charity_uuid
  - dimension: context_library_name
    sql: ${TABLE}.context_library_name
  - dimension: context_library_version
    sql: ${TABLE}.context_library_version
  - dimension: country_code
    sql: ${TABLE}.country_code
  - dimension: currency
    sql: ${TABLE}.currency
  - dimension: donation_id
    type: int
    sql: ${TABLE}.donation_id
  - dimension: donation_type
    sql: ${TABLE}.donation_type
  - dimension: donor_email
    sql: ${TABLE}.donor_email
  - dimension: donor_nickname
    sql: ${TABLE}.donor_nickname
  - dimension: donor_uuid
    sql: ${TABLE}.donor_uuid
  - dimension: event
    sql: ${TABLE}.event
  - dimension: event_id
    sql: ${TABLE}.event_id
  - dimension: event_text
    sql: ${TABLE}.event_text
  - dimension: message
    sql: ${TABLE}.message
  - dimension: page_id
    type: int
    sql: ${TABLE}.page_id
  - dimension: page_url
    sql: ${TABLE}.page_url
  - dimension: timestamp
    sql: ${TABLE}.timestamp
  - dimension: user_email
    sql: ${TABLE}.user_email
  - dimension: user_id
    sql: ${TABLE}.user_id
  - dimension: user_name
    sql: ${TABLE}.user_name
  - dimension: pk
    primary_key: true
    hidden: true
    sql: ${event_id} || ${TABLE}.sent_at || ${user_id}
  - dimension_group: original_timestamp
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.original_timestamp
  - dimension_group: received
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - month_num
    - year
    sql: ${TABLE}.received_at
  - dimension_group: sent
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.sent_at
  - measure: count
    type: count
    drill_fields:
    - detail*
  - measure: total_amount_cents
    type: sum
    drill_fields:
    - detail*
    sql: ${amount_cents}
  - measure: average_amount_cents
    type: average
    drill_fields:
    - detail*
    sql: ${amount_cents}
  - measure: total_amount
    type: sum
    value_format: '$#,##0.00'
    drill_fields:
    - detail*
    sql: ${amount_number}
  - measure: average_amount
    type: average
    value_format: '$#,##0.00'
    drill_fields:
    - detail*
    sql: ${amount_number}