Invoice Totals

view: invoice_totals {
  sql_table_name: public.invoice_totals ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [invoices.invoice_id]
  }

  measure: total_amount_adjusted {
    type: sum
    sql: ${amount_adjusted} ;;
  }

  measure: total_amount_credited {
    type: sum
    sql: ${amount_credited} ;;
  }

  measure: total_amount_invoiced {
    type: sum
    sql: ${amount_invoiced} ;;
  }

  measure: total_amount_invoiced_net {
    type: sum
    sql: ${amount_invoiced_net} ;;
  }

  measure: average_amount_invoiced_net {
    type: average
    sql: ${amount_invoiced_net} ;;
  }

  measure: total_amount_received {
    type: sum
    sql: ${amount_received} ;;
  }

  measure: total_amount_returned {
    type: sum
    sql: ${amount_returned} ;;
  }
}

- view: invoice_totals
  sql_table_name: public.invoice_totals
  fields:
  - dimension: invoice_id
    type: int
    primary_key: true
    sql: ${TABLE}.invoice_id
  - dimension: account_id
    type: int
    hidden: true
    sql: ${TABLE}.account_id
  - dimension: amount_adjusted
    type: number
    sql: ${TABLE}.amount_adjusted
  - dimension: amount_credited
    type: number
    sql: ${TABLE}.amount_credited
  - dimension: amount_invoiced
    type: number
    sql: ${TABLE}.amount_invoiced
  - dimension: amount_invoiced_net
    type: number
    sql: ${TABLE}.amount_invoiced_net
  - dimension: amount_received
    type: number
    sql: ${TABLE}.amount_received
  - dimension: amount_returned
    type: number
    sql: ${TABLE}.amount_returned
  - dimension: balance
    type: number
    sql: ${TABLE}.balance
  - dimension: num_adjustments
    type: int
    sql: ${TABLE}.num_adjustments
  - dimension: num_credits
    type: int
    sql: ${TABLE}.num_credits
  - dimension: num_items
    type: number
    sql: ${TABLE}.num_items
  - dimension: num_receipts
    type: int
    sql: ${TABLE}.num_receipts
  - dimension: num_returns
    type: number
    sql: ${TABLE}.num_returns
  - measure: count
    type: count
    drill_fields:
    - invoices.invoice_id
  - measure: total_amount_adjusted
    type: sum
    sql: ${amount_adjusted}
  - measure: total_amount_credited
    type: sum
    sql: ${amount_credited}
  - measure: total_amount_invoiced
    type: sum
    sql: ${amount_invoiced}
  - measure: total_amount_invoiced_net
    type: sum
    sql: ${amount_invoiced_net}
  - measure: average_amount_invoiced_net
    type: average
    sql: ${amount_invoiced_net}
  - measure: total_amount_received
    type: sum
    sql: ${amount_received}
  - measure: total_amount_returned
    type: sum
    sql: ${amount_returned}