LookML Fintech payments

Cases

Cases model for fintech payments.

source-preserved

Blocks

LKML LookML

cases.view.lkml · 203 lines

inferred

view: cases {
  sql_table_name: generic_looker_test.cases ;;

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

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

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

  dimension: created_day {
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 6 THEN 'Saturday'
ELSE NULL
END ;;
  }

  dimension: created_dom {
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) ;;
  }

  dimension: created_shift {
    sql: CASE
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) BETWEEN 0 AND 4 THEN 'Unstaffed'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) BETWEEN 5 AND 8 THEN 'Morning'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) BETWEEN 9 AND 16 THEN 'Day'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) BETWEEN 17 AND 23 THEN 'Night'
END ;;
  }

  dimension: resolved_shift {
    sql: CASE
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) BETWEEN 0 AND 4 THEN 'Unstaffed'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) BETWEEN 5 AND 8 THEN 'Morning'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) BETWEEN 9 AND 16 THEN 'Day'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) BETWEEN 17 AND 23 THEN 'Night'
END ;;
  }

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

  dimension: first_opened_at_day {
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 6 THEN 'Saturday'
ELSE NULL
END ;;
  }

  dimension: first_opened_at_dom {
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) ;;
  }

  dimension: first_resolved_at_dom {
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) ;;
  }

  dimension: last_opened_at_dom {
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) ;;
  }

  dimension: last_resolved_at_dom {
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) ;;
  }

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

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

  dimension: minutes_to_first_resolve {
    type: int
    sql: DATEDIFF(minutes, ${TABLE}.created_at, ${TABLE}.first_resolved_at) ;;
  }

  dimension: minutes_to_first_open {
    type: int
    sql: DATEDIFF(minutes, ${TABLE}.created_at, ${TABLE}.first_opened_at) ;;
  }

  dimension_group: created {
    type: time
    timeframes: [time, date, week, month, hod, dow, month_num, tod]
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at) ;;
  }

  dimension_group: first_opened_at {
    type: time
    timeframes: [time, date, week, month, hod, dow, month_num, tod]
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at) ;;
  }

  dimension_group: first_resolved_at {
    type: time
    timeframes: [time, date, week, month, hod, dow, month_num, tod]
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at) ;;
  }

  dimension_group: first_resolved_at_day {
    type: time
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 6 THEN 'Saturday'
ELSE NULL
END ;;
  }

  dimension_group: last_opened_at {
    type: time
    timeframes: [time, date, week, month, hod, dow, month_num, tod]
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at) ;;
  }

  dimension_group: last_opened_at_day {
    type: time
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 6 THEN 'Saturday'
ELSE NULL
END ;;
  }

  dimension_group: last_resolved_at {
    type: time
    timeframes: [time, date, week, month, hod, dow, month_num, tod]
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at) ;;
  }

  dimension_group: last_resolved_at_day {
    type: time
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 6 THEN 'Saturday'
ELSE NULL
END ;;
  }

  dimension_group: updated {
    type: time
    timeframes: [time, date, week, month, hod, dow, month_num, tod]
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.updated_at) ;;
  }

  measure: count {
    type: count
  }

  measure: percent_of_cases {
    type: percent_of_total
    sql: ${count} ;;
  }

  measure: customer_count {
    type: count_distinct
    sql: ${customer_id} ;;
  }
}

cases.view.lookml · 193 lines

source-preserved

- view: cases
  sql_table_name: generic_looker_test.cases
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: assigned_group_id
    type: int
    sql: ${TABLE}.assigned_group_id
  - dimension: assigned_user_id
    type: int
    sql: ${TABLE}.assigned_user_id
  - dimension: created_day
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) = 6 THEN 'Saturday'
ELSE NULL
END
  - dimension: created_dom
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at))
  - dimension: created_shift
    sql: CASE
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) BETWEEN 0 AND 4 THEN 'Unstaffed'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) BETWEEN 5 AND 8 THEN 'Morning'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) BETWEEN 9 AND 16 THEN 'Day'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)) BETWEEN 17 AND 23 THEN 'Night'
END
  - dimension: resolved_shift
    sql: CASE
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) BETWEEN 0 AND 4 THEN 'Unstaffed'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) BETWEEN 5 AND 8 THEN 'Morning'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) BETWEEN 9 AND 16 THEN 'Day'
  WHEN EXTRACT(HOUR FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) BETWEEN 17 AND 23 THEN 'Night'
END
  - dimension: customer_id
    type: int
    sql: ${TABLE}.customer_id
  - dimension: first_opened_at_day
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)) = 6 THEN 'Saturday'
ELSE NULL
END
  - dimension: first_opened_at_dom
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at))
  - dimension: first_resolved_at_dom
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at))
  - dimension: last_opened_at_dom
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at))
  - dimension: last_resolved_at_dom
    type: int
    sql: EXTRACT(DAY FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at))
  - dimension: status
    sql: ${TABLE}.status
  - dimension: type
    sql: ${TABLE}.type
  - dimension: minutes_to_first_resolve
    type: int
    sql: DATEDIFF(minutes, ${TABLE}.created_at, ${TABLE}.first_resolved_at)
  - dimension: minutes_to_first_open
    type: int
    sql: DATEDIFF(minutes, ${TABLE}.created_at, ${TABLE}.first_opened_at)
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hod
    - dow
    - month_num
    - tod
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.created_at)
  - dimension_group: first_opened_at
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hod
    - dow
    - month_num
    - tod
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_opened_at)
  - dimension_group: first_resolved_at
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hod
    - dow
    - month_num
    - tod
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)
  - dimension_group: first_resolved_at_day
    type: time
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.first_resolved_at)) = 6 THEN 'Saturday'
ELSE NULL
END
  - dimension_group: last_opened_at
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hod
    - dow
    - month_num
    - tod
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)
  - dimension_group: last_opened_at_day
    type: time
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.opened_at)) = 6 THEN 'Saturday'
ELSE NULL
END
  - dimension_group: last_resolved_at
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hod
    - dow
    - month_num
    - tod
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)
  - dimension_group: last_resolved_at_day
    type: time
    sql: CASE
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 0 THEN 'Sunday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 1 THEN 'Monday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 2 THEN 'Tuesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 3 THEN 'Wednesday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 4 THEN 'Thursday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 5 THEN 'Friday'
WHEN EXTRACT(dow FROM CONVERT_TIMEZONE('America/Chicago', ${TABLE}.resolved_at)) = 6 THEN 'Saturday'
ELSE NULL
END
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hod
    - dow
    - month_num
    - tod
    sql: CONVERT_TIMEZONE('America/Chicago', ${TABLE}.updated_at)
  - measure: count
    type: count
  - measure: percent_of_cases
    type: percent_of_total
    sql: ${count}
  - measure: customer_count
    type: count_distinct
    sql: ${customer_id}

cases.view.lkml
cases.view.lookml

Cases

Blocks

Contents