Tickets

view: tickets {
  sql_table_name: external_system._tickets ;;

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

  dimension: _charged_to_client_custom_apps {
    type: number
    sql: ${TABLE}.$_charged_to_client_(custom_apps) ;;
  }

  dimension: _quoted_custom_apps {
    type: number
    sql: ${TABLE}.$_quoted_(custom_apps) ;;
  }

  dimension: _quoted_custom_apps_1 {
    sql: ${TABLE}.$_quoted_(custom_apps)_1 ;;
  }

  dimension: action_flag_custom_apps {
    sql: ${TABLE}.action_flag_(custom_apps) ;;
  }

  dimension: annual_maintenance_custom_apps {
    sql: ${TABLE}.annual_maintenance_(custom_apps) ;;
  }

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

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

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

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

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

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

  dimension: client_downtime_min {
    type: number
    sql: ${TABLE}.client_downtime_(min) ;;
  }

  dimension: client_impact_minutes_ops {
    type: number
    sql: ${TABLE}.client_impact_minutes_(ops) ;;
  }

  dimension: client_program_sos_support_custom_apps {
    sql: ${TABLE}.client_program_(sos,_support,_custom_apps) ;;
  }

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

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

  dimension: customer_support_custom_apps {
    sql: ${TABLE}.customer_(support,_custom_apps) ;;
  }

  dimension: debt_items_involved_quality {
    sql: ${TABLE}.debt_items_involved_(quality) ;;
  }

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

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

  dimension: dev_hours_spent_support {
    sql: ${TABLE}.dev_hours_spent_(support) ;;
  }

  dimension: disposition_custom_apps {
    sql: ${TABLE}.disposition_(custom_apps) ;;
  }

  dimension: environment_ops {
    sql: ${TABLE}.environment_(ops) ;;
  }

  dimension: escalated_to_custom_apps_support {
    sql: ${TABLE}.escalated_to_(custom_apps_support) ;;
  }

  dimension: escalated_to_dev_support {
    type: yesno
    sql: ${TABLE}.escalated_to_dev?_(support) ;;
  }

  dimension: escalated_to_dev_support_1 {
    sql: ${TABLE}.escalated_to_dev?_(support)_1 ;;
  }

  dimension: escalated_to_ess_sos {
    sql: ${TABLE}.escalated_to_ess_(sos) ;;
  }

  dimension: escalated_to_shield_support {
    type: yesno
    sql: ${TABLE}.escalated_to_shield?_(support) ;;
  }

  dimension: escalated_to_shield_support_1 {
    sql: ${TABLE}.escalated_to_shield?_(support)_1 ;;
  }

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

  dimension: escalation_hours_spent_solutions {
    sql: ${TABLE}.escalation_hours_spent_(solutions) ;;
  }

  dimension: ess_hours_spent_support {
    sql: ${TABLE}.ess_hours_spent_(support) ;;
  }

  dimension: ess_hours_spent_support_1 {
    sql: ${TABLE}.ess_hours_spent_(support)_1 ;;
  }

  dimension: etech__company_staff {
    sql: ${TABLE}.etech_-_company_staff ;;
  }

  dimension: etech__program {
    sql: ${TABLE}.etech_-_program_name ;;
  }

  dimension: etech__skills_setup {
    sql: ${TABLE}.etech_-_setup_skills ;;
  }

  dimension: etech__staffing {
    sql: ${TABLE}.etech_-_staffing_for ;;
  }

  dimension: etech__staff_level {
    sql: ${TABLE}.etech_-_staffing_level ;;
  }

  dimension: expense_transfer_amount_custom_apps_ {
    sql: ${TABLE}.expense_transfer_amount_(custom_apps)_($,) ;;
  }

  dimension: expense_transfer_authorized_by_custom_apps {
    sql: ${TABLE}.expense_transfer_authorized_by_(custom_apps) ;;
  }

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

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

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

  dimension: functional_area_sos_support {
    sql: ${TABLE}.functional_area_(sos,_support) ;;
  }

  dimension: functional_area_support {
    sql: ${TABLE}.functional_area_(support) ;;
  }

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

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

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

  dimension: how_many_customer_instances_are_impacted_quality {
    sql: ${TABLE}.how_many_customer_instances_are_impacted?_(quality) ;;
  }

  dimension: impact_to_the_customer_quality {
    sql: ${TABLE}.impact_to_the_customer_(quality) ;;
  }

  dimension: incident_impact_points_ops {
    type: number
    sql: ${TABLE}.incident_impact_points_(ops) ;;
  }

  dimension: incident_start_time_ops {
    sql: ${TABLE}.incident_start_time_(ops) ;;
  }

  dimension: incidents_ops_metrics_required {
    type: yesno
    sql: ${TABLE}.incidents?_(ops_metrics_required) ;;
  }

  dimension: incorrectly_assigned_to_ess_solutionssupport {
    sql: ${TABLE}.incorrectly_assigned_to_ess_(solutions/support) ;;
  }

  dimension: is_this_a_customer_quality_issue_quality {
    sql: ${TABLE}.is_this_a_customer_quality_issue?_(quality) ;;
  }

  dimension: is_this_a_recurring_issue_for_the_customer {
    sql: ${TABLE}.is_this_a_recurring_issue_for_the_customer? ;;
  }

  dimension: kanbanstatus {
    sql: ${TABLE}.kanban-status ;;
  }

  dimension: l_1_deployment {
    sql: CASE
  WHEN ${TABLE}.l_1_deployment = 'emergency_deployment' THEN 'Emergency'
  WHEN ${TABLE}.l_1_deployment = 'regular_deployme' THEN 'Regular'
  ELSE NULL
END ;;
  }

  dimension: l_1_documentation_available_custom_apps_support {
    sql: ${TABLE}.l_1_documentation_available?_(custom_apps_support) ;;
  }

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

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

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

  dimension: nonescalation_hours_spent_solutions {
    type: number
    sql: ${TABLE}.non-escalation_hours_spent_(solutions) ;;
  }

  dimension: offending_case_ops {
    sql: ${TABLE}.offending_case_(ops) ;;
  }

  dimension: offhours_custom_apps_support {
    sql: ${TABLE}.off-hours?_(custom_apps_support) ;;
  }

  dimension: ops_category_ops {
    sql: ${TABLE}.ops_category_(ops) ;;
  }

  dimension: ops_subcategory_ops {
    sql: ${TABLE}.ops_subcategory_(ops) ;;
  }

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

  dimension: price_in_usd_custom_apps_ {
    sql: ${TABLE}.price_in_usd_(custom_apps)_($,) ;;
  }

  dimension: price_waived_by_custom_apps {
    sql: ${TABLE}.price_waived_by_(custom_apps) ;;
  }

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

  dimension: probability_of_commencement_custom_apps_ {
    sql: ${TABLE}.probability_of_commencement_(custom_apps)_ ;;
  }

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

  dimension: product_team_support {
    sql: ${TABLE}.product_team_(support) ;;
  }

  dimension: project_size_custom_apps {
    sql: ${TABLE}.project_size_(custom_apps) ;;
  }

  dimension: quality_categories_quality {
    sql: ${TABLE}.quality_categories_(quality) ;;
  }

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

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

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

  dimension: request_type_custom_apps {
    sql: ${TABLE}.request_type_(custom_apps) ;;
  }

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

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

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

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

  dimension: risk_level_ops {
    sql: ${TABLE}.risk_level_(ops) ;;
  }

  dimension: root_cause_ops {
    sql: ${TABLE}.root_cause_(ops) ;;
  }

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

  dimension: severity_ops {
    sql: ${TABLE}.severity_(ops) ;;
  }

  dimension: shield_hours_spent_support {
    sql: ${TABLE}.shield_hours_spent_(support) ;;
  }

  dimension: short_business_case_custom_apps_ {
    sql: ${TABLE}.short_business_case_(custom_apps)_ ;;
  }

  dimension: sm_support_hours_spent_social_media {
    sql: ${TABLE}.sm_support_hours_spent_(social_media) ;;
  }

  dimension: solutions_area_sos {
    sql: ${TABLE}.solutions_area_(sos) ;;
  }

  dimension: source_flag_custom_apps {
    sql: ${TABLE}.source_flag_(custom_apps) ;;
  }

  dimension: spotchecked_it {
    type: yesno
    sql: ${TABLE}.spot-checked?_(it) ;;
  }

  dimension: squad_support {
    sql: ${TABLE}.squad_(support) ;;
  }

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

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

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

  dimension: summaryresolution_solutions {
    sql: ${TABLE}.summary/resolution_(solutions) ;;
  }

  dimension: target_test {
    sql: ${TABLE}.target_(test) ;;
  }

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

  dimension: total_incident_duration_min {
    type: number
    sql: ${TABLE}.total_incident_duration_(min) ;;
  }

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

  dimension: type_of_support_custom_apps_support_ {
    sql: ${TABLE}.type_of_support_(custom_apps_support)_ ;;
  }

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

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

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

  dimension: visibility_of_the_issue_to_the_customer_quality {
    sql: ${TABLE}.visibility_of_the_issue_to_the_customer?_(quality) ;;
  }

  dimension: wake_operations_up {
    type: yesno
    sql: ${TABLE}.wake_operations_up? ;;
  }

  dimension: what_could_have_prevented_ticket_support {
    sql: ${TABLE}.what_could_have_prevented_ticket?_(support) ;;
  }

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

  dimension_group: date_support {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.date_(support) ;;
  }

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

  dimension_group: etech__deployment {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.etech_-_rollout_date ;;
  }

  dimension_group: etech__initiation {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.etech_-_start_date ;;
  }

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

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

- view: tickets
  sql_table_name: external_system._tickets
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: _charged_to_client_custom_apps
    type: number
    sql: ${TABLE}.$_charged_to_client_(custom_apps)
  - dimension: _quoted_custom_apps
    type: number
    sql: ${TABLE}.$_quoted_(custom_apps)
  - dimension: _quoted_custom_apps_1
    sql: ${TABLE}.$_quoted_(custom_apps)_1
  - dimension: action_flag_custom_apps
    sql: ${TABLE}.action_flag_(custom_apps)
  - dimension: annual_maintenance_custom_apps
    sql: ${TABLE}.annual_maintenance_(custom_apps)
  - dimension: assignee_id
    type: int
    sql: ${TABLE}.assignee_id
  - dimension: category
    sql: ${TABLE}.category
  - dimension: change_tracker_id
    sql: ${TABLE}.change_tracker_id
  - dimension: checkpoint_requested
    sql: ${TABLE}.checkpoint_requested
  - dimension: citrix_session_details
    sql: ${TABLE}.citrix_session_details
  - dimension: client
    sql: ${TABLE}.client
  - dimension: client_downtime_min
    type: number
    sql: ${TABLE}.client_downtime_(min)
  - dimension: client_impact_minutes_ops
    type: number
    sql: ${TABLE}.client_impact_minutes_(ops)
  - dimension: client_program_sos_support_custom_apps
    sql: ${TABLE}.client_program_(sos,_support,_custom_apps)
  - dimension: customer_quality_issue
    type: yesno
    sql: ${TABLE}.customer_quality_issue
  - dimension: customer_quality_issue_severity
    sql: ${TABLE}.customer_quality_issue_severity
  - dimension: customer_support_custom_apps
    sql: ${TABLE}.customer_(support,_custom_apps)
  - dimension: debt_items_involved_quality
    sql: ${TABLE}.debt_items_involved_(quality)
  - dimension: debt_related_request
    sql: ${TABLE}.debt_related_request
  - dimension: description
    sql: ${TABLE}.description
  - dimension: dev_hours_spent_support
    sql: ${TABLE}.dev_hours_spent_(support)
  - dimension: disposition_custom_apps
    sql: ${TABLE}.disposition_(custom_apps)
  - dimension: environment_ops
    sql: ${TABLE}.environment_(ops)
  - dimension: escalated_to_custom_apps_support
    sql: ${TABLE}.escalated_to_(custom_apps_support)
  - dimension: escalated_to_dev_support
    type: yesno
    sql: ${TABLE}.escalated_to_dev?_(support)
  - dimension: escalated_to_dev_support_1
    sql: ${TABLE}.escalated_to_dev?_(support)_1
  - dimension: escalated_to_ess_sos
    sql: ${TABLE}.escalated_to_ess_(sos)
  - dimension: escalated_to_shield_support
    type: yesno
    sql: ${TABLE}.escalated_to_shield?_(support)
  - dimension: escalated_to_shield_support_1
    sql: ${TABLE}.escalated_to_shield?_(support)_1
  - dimension: escalation_flag
    type: yesno
    sql: ${TABLE}.escalation_flag
  - dimension: escalation_hours_spent_solutions
    sql: ${TABLE}.escalation_hours_spent_(solutions)
  - dimension: ess_hours_spent_support
    sql: ${TABLE}.ess_hours_spent_(support)
  - dimension: ess_hours_spent_support_1
    sql: ${TABLE}.ess_hours_spent_(support)_1
  - dimension: etech__company_staff
    sql: ${TABLE}.etech_-_company_staff
  - dimension: etech__program
    sql: ${TABLE}.etech_-_program_name
  - dimension: etech__skills_setup
    sql: ${TABLE}.etech_-_setup_skills
  - dimension: etech__staffing
    sql: ${TABLE}.etech_-_staffing_for
  - dimension: etech__staff_level
    sql: ${TABLE}.etech_-_staffing_level
  - dimension: expense_transfer_amount_custom_apps_
    sql: ${TABLE}.expense_transfer_amount_(custom_apps)_($,)
  - dimension: expense_transfer_authorized_by_custom_apps
    sql: ${TABLE}.expense_transfer_authorized_by_(custom_apps)
  - dimension: external_id
    sql: ${TABLE}.external_id
  - dimension: fog_bugz_fixit_case
    type: number
    sql: ${TABLE}.fog_bugz_fixit_case
  - dimension: forum_topic_id
    type: int
    sql: ${TABLE}.forum_topic_id
  - dimension: functional_area_sos_support
    sql: ${TABLE}.functional_area_(sos,_support)
  - dimension: functional_area_support
    sql: ${TABLE}.functional_area_(support)
  - dimension: group_chosen_by_requester
    sql: ${TABLE}.group_chosen_by_requester
  - dimension: group_id
    type: int
    sql: ${TABLE}.group_id
  - dimension: has_incidents
    type: yesno
    sql: ${TABLE}.has_incidents
  - dimension: how_many_customer_instances_are_impacted_quality
    sql: ${TABLE}.how_many_customer_instances_are_impacted?_(quality)
  - dimension: impact_to_the_customer_quality
    sql: ${TABLE}.impact_to_the_customer_(quality)
  - dimension: incident_impact_points_ops
    type: number
    sql: ${TABLE}.incident_impact_points_(ops)
  - dimension: incident_start_time_ops
    sql: ${TABLE}.incident_start_time_(ops)
  - dimension: incidents_ops_metrics_required
    type: yesno
    sql: ${TABLE}.incidents?_(ops_metrics_required)
  - dimension: incorrectly_assigned_to_ess_solutionssupport
    sql: ${TABLE}.incorrectly_assigned_to_ess_(solutions/support)
  - dimension: is_this_a_customer_quality_issue_quality
    sql: ${TABLE}.is_this_a_customer_quality_issue?_(quality)
  - dimension: is_this_a_recurring_issue_for_the_customer
    sql: ${TABLE}.is_this_a_recurring_issue_for_the_customer?
  - dimension: kanbanstatus
    sql: ${TABLE}.kanban-status
  - dimension: l_1_deployment
    sql: CASE
  WHEN ${TABLE}.l_1_deployment = 'emergency_deployment' THEN 'Emergency'
  WHEN ${TABLE}.l_1_deployment = 'regular_deployme' THEN 'Regular'
  ELSE NULL
END
  - dimension: l_1_documentation_available_custom_apps_support
    sql: ${TABLE}.l_1_documentation_available?_(custom_apps_support)
  - dimension: l_1_new_instance_setup
    sql: ${TABLE}.l_1_new_instance_setup
  - dimension: l_1_ticket
    sql: ${TABLE}.l_1_ticket
  - dimension: marketing_assignee
    sql: ${TABLE}.marketing_assignee
  - dimension: nonescalation_hours_spent_solutions
    type: number
    sql: ${TABLE}.non-escalation_hours_spent_(solutions)
  - dimension: offending_case_ops
    sql: ${TABLE}.offending_case_(ops)
  - dimension: offhours_custom_apps_support
    sql: ${TABLE}.off-hours?_(custom_apps_support)
  - dimension: ops_category_ops
    sql: ${TABLE}.ops_category_(ops)
  - dimension: ops_subcategory_ops
    sql: ${TABLE}.ops_subcategory_(ops)
  - dimension: organization_id
    type: int
    sql: ${TABLE}.organization_id
  - dimension: price_in_usd_custom_apps_
    sql: ${TABLE}.price_in_usd_(custom_apps)_($,)
  - dimension: price_waived_by_custom_apps
    sql: ${TABLE}.price_waived_by_(custom_apps)
  - dimension: priority
    sql: ${TABLE}.priority
  - dimension: probability_of_commencement_custom_apps_
    sql: ${TABLE}.probability_of_commencement_(custom_apps)_
  - dimension: problem_id
    type: int
    sql: ${TABLE}.problem_id
  - dimension: product_team_support
    sql: ${TABLE}.product_team_(support)
  - dimension: project_size_custom_apps
    sql: ${TABLE}.project_size_(custom_apps)
  - dimension: quality_categories_quality
    sql: ${TABLE}.quality_categories_(quality)
  - dimension: quality_risk_list_disposition
    sql: ${TABLE}.quality_risk_list_disposition
  - dimension: quality_stand_up
    sql: ${TABLE}.quality_stand_up
  - dimension: recipient
    sql: ${TABLE}.recipient
  - dimension: request_type_custom_apps
    sql: ${TABLE}.request_type_(custom_apps)
  - dimension: requester_email
    sql: ${TABLE}.requester_email
  - dimension: requester_id
    type: int
    sql: ${TABLE}.requester_id
  - dimension: requester_locale_id
    type: int
    sql: ${TABLE}.requester_locale_id
  - dimension: requester_name
    sql: ${TABLE}.requester_name
  - dimension: risk_level_ops
    sql: ${TABLE}.risk_level_(ops)
  - dimension: root_cause_ops
    sql: ${TABLE}.root_cause_(ops)
  - dimension: security_categories
    sql: ${TABLE}.security_categories
  - dimension: severity_ops
    sql: ${TABLE}.severity_(ops)
  - dimension: shield_hours_spent_support
    sql: ${TABLE}.shield_hours_spent_(support)
  - dimension: short_business_case_custom_apps_
    sql: ${TABLE}.short_business_case_(custom_apps)_
  - dimension: sm_support_hours_spent_social_media
    sql: ${TABLE}.sm_support_hours_spent_(social_media)
  - dimension: solutions_area_sos
    sql: ${TABLE}.solutions_area_(sos)
  - dimension: source_flag_custom_apps
    sql: ${TABLE}.source_flag_(custom_apps)
  - dimension: spotchecked_it
    type: yesno
    sql: ${TABLE}.spot-checked?_(it)
  - dimension: squad_support
    sql: ${TABLE}.squad_(support)
  - dimension: status
    sql: ${TABLE}.status
  - dimension: subject
    sql: ${TABLE}.subject
  - dimension: submitter_id
    type: int
    sql: ${TABLE}.submitter_id
  - dimension: summaryresolution_solutions
    sql: ${TABLE}.summary/resolution_(solutions)
  - dimension: target_test
    sql: ${TABLE}.target_(test)
  - dimension: ticket_form_id
    type: int
    sql: ${TABLE}.ticket_form_id
  - dimension: total_incident_duration_min
    type: number
    sql: ${TABLE}.total_incident_duration_(min)
  - dimension: type
    sql: ${TABLE}.type
  - dimension: type_of_support_custom_apps_support_
    sql: ${TABLE}.type_of_support_(custom_apps_support)_
  - dimension: url
    sql: ${TABLE}.url
  - dimension: vertical
    sql: ${TABLE}.vertical
  - dimension: via_channel
    sql: ${TABLE}.via_channel
  - dimension: visibility_of_the_issue_to_the_customer_quality
    sql: ${TABLE}.visibility_of_the_issue_to_the_customer?_(quality)
  - dimension: wake_operations_up
    type: yesno
    sql: ${TABLE}.wake_operations_up?
  - dimension: what_could_have_prevented_ticket_support
    sql: ${TABLE}.what_could_have_prevented_ticket?_(support)
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: date_support
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.date_(support)
  - dimension_group: due
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.due_at
  - dimension_group: etech__deployment
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.etech_-_rollout_date
  - dimension_group: etech__initiation
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.etech_-_start_date
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail*