Sessions

view: sessions {
  sql_table_name: company_orders_production.sessions ;;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    value_format: "[>=1000000]0.00,,\"M\";[>=1000]0.00,\"K\";0.00"
    drill_fields: [accounts.id, accounts.name, count]
  }

  measure: user_count {
    description: "This is a distinct count of creator ids."
    type: count_distinct
    sql: ${creator_id} ;;
  }

  measure: rating_number {
    description: "Rating"
    type: avg
    value_format: "0.00"
    sql: 1.00*${TABLE}.rating ;;
  }
}

- view: sessions
  sql_table_name: company_orders_production.sessions
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: account_id
    type: int
    sql: ${TABLE}.account_id
  - dimension: creator_id
    type: int
    sql: ${TABLE}.creator_id
  - dimension: demographic_group_id
    type: int
    sql: ${TABLE}.demographic_group_id
  - dimension: flags
    type: int
    sql: ${TABLE}.flags
  - dimension: internal_notes
    sql: ${TABLE}.internal_notes
  - dimension: internal_rating
    type: int
    sql: ${TABLE}.internal_rating
  - dimension: internal_rating_reason
    sql: ${TABLE}.internal_rating_reason
  - dimension: notes
    sql: ${TABLE}.notes
  - dimension: panel_id
    type: int
    sql: ${TABLE}.panel_id
  - dimension: panelist_email
    sql: ${TABLE}.panelist_email
  - dimension: participant_group_id
    type: int
    sql: ${TABLE}.participant_group_id
  - dimension: participant_id
    type: int
    sql: ${TABLE}.participant_id
  - dimension: rating
    type: int
    sql: ${TABLE}.rating
  - dimension: rating_reason
    sql: ${TABLE}.rating_reason
  - dimension: reference_id
    sql: ${TABLE}.reference_id
  - dimension: state
    sql: ${TABLE}.state
  - dimension: study_id
    type: int
    sql: ${TABLE}.study_id
  - dimension: system_information
    sql: ${TABLE}.system_information
  - dimension_group: completed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.completed_at
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: exhausted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.exhausted_at
  - dimension_group: requested
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.requested_at
  - dimension_group: started
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.started_at
  - dimension_group: state_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.state_updated_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    value_format: '[>=1000000]0.00,,"M";[>=1000]0.00,"K";0.00'
    drill_fields:
    - accounts.id
    - accounts.name
    - count
  - measure: user_count
    type: count_distinct
    description: This is a distinct count of creator ids.
    sql: ${creator_id}
  - measure: rating_number
    type: avg
    description: Rating
    value_format: 0.00
    sql: 1.00*${TABLE}.rating