monitoring/dashboards/environment_performance_dashboard.dashboard.lookml (2,212 lines of code) (raw):
- dashboard: environment_performance_dashboard
title: Environment Performance Dashboard
layout: newspaper
preferred_viewer: dashboards-next
description: ''
preferred_slug: qo4RsUk7JZW040IYxsMRAq
elements:
- title: Runtime Run Count and Query Count by Dashboard L30D
name: Runtime Run Count and Query Count by Dashboard L30D
model: system__activity
explore: history
type: looker_column
fields: [dashboard.title, history.average_runtime, history.dashboard_run_count,
history.query_run_count]
filters:
history.completed_date: 30 days
sorts: [history.average_runtime desc]
limit: 100
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: false
legend_position: center
point_style: circle
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
color_application:
collection_id: bergfreunde
palette_id: bergfreunde-categorical-0
options:
steps: 5
y_axes: [{label: !!null '', orientation: left, series: [{axisId: history.average_runtime,
id: history.average_runtime, name: Average Runtime in Seconds}], showLabels: false,
showValues: true, unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
type: linear}, {label: !!null '', orientation: right, series: [{axisId: history.dashboard_run_count,
id: history.dashboard_run_count, name: Dashboard Run Count}], showLabels: false,
showValues: false, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
type: linear}, {label: !!null '', orientation: right, series: [{axisId: history.query_run_count,
id: history.query_run_count, name: Query Run Count}], showLabels: false,
showValues: false, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
type: linear}]
series_types:
history.query_run_count: scatter
history.dashboard_run_count: scatter
series_colors:
history.average_runtime: "#2C72AC"
history.dashboard_run_count: "#222"
query.count: "#2C72AC"
history.query_run_count: "#F88017"
series_labels: {}
reference_lines: [{reference_type: line, line_value: '30', range_start: max, range_end: min,
margin_top: deviation, margin_value: mean, margin_bottom: deviation, label_position: right,
color: "#B32F37", label: 30 Seconds}]
trend_lines: []
swap_axes: false
show_null_points: true
defaults_version: 1
interpolation: linear
hidden_fields: []
hidden_points_if_no: []
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: 12
rows_font_size: 12
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
listen: {}
row: 89
col: 0
width: 24
height: 11
- title: Runs by Looker Node L30D
name: Runs by Looker Node L30D
model: system__activity
explore: history
type: looker_column
fields: [history.average_runtime, history.dashboard_run_count, node.id, node.hostname,
node.is_master, node.port, node.version]
filters:
history.completed_date: 30 days
sorts: [history.dashboard_run_count desc]
limit: 100
column_limit: 50
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: false
legend_position: center
point_style: circle
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
color_application:
collection_id: bergfreunde
palette_id: bergfreunde-categorical-0
options:
steps: 5
y_axes: [{label: !!null '', orientation: left, series: [{axisId: history.average_runtime,
id: history.average_runtime, name: Average Runtime in Seconds}], showLabels: true,
showValues: true, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
type: linear}, {label: !!null '', orientation: right, series: [{axisId: history.dashboard_run_count,
id: history.dashboard_run_count, name: Dashboard Run Count}], showLabels: true,
showValues: true, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
type: linear}]
series_types:
history.average_runtime: scatter
series_colors:
history.average_runtime: "#222"
history.dashboard_run_count: "#2C72AC"
series_labels: {}
reference_lines: [{reference_type: line, line_value: '30', range_start: max, range_end: min,
margin_top: deviation, margin_value: mean, margin_bottom: deviation, label_position: right,
color: "#B32F37", label: 30 Seconds}]
trend_lines: []
swap_axes: false
show_null_points: true
defaults_version: 1
interpolation: linear
hidden_fields: [node.hostname, node.is_master, node.port]
hidden_points_if_no: []
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: 12
rows_font_size: 12
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
listen: {}
row: 132
col: 0
width: 24
height: 7
- title: Cache vs Database Drill L30D
name: Cache vs Database Drill L30D
model: system__activity
explore: history
type: looker_grid
fields: [dashboard.title, history.average_runtime, history.dashboard_run_count,
query.count, history.result_source]
pivots: [history.result_source]
filters:
history.completed_date: 30 days
history.result_source: -"stale_cache",-EMPTY
sorts: [history.result_source desc, avg_runtime_seconds desc 0]
limit: 100
column_limit: 50
dynamic_fields: [{category: table_calculation, expression: "${history.average_runtime}",
label: AVG Runtime Seconds, value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: avg_runtime_seconds, _type_hint: number}]
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
color_application:
collection_id: bergfreunde
palette_id: bergfreunde-categorical-0
options:
steps: 5
show_sql_query_menu_options: false
column_order: ["$$$_row_numbers_$$$", dashboard.title, query_avg_runtime_seconds,
query_history.dashboard_run_count, query_query.count, cache_avg_runtime_seconds,
cache_history.dashboard_run_count, cache_query.count]
show_totals: true
show_row_totals: true
series_labels:
query.count: Query Count
series_column_widths:
avg_runtime_seconds: 112
series_cell_visualizations:
history.average_runtime:
is_active: false
series_text_format:
query.count:
align: left
history.dashboard_run_count:
align: left
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
legend_position: center
point_style: circle
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
y_axes: [{label: !!null '', orientation: left, series: [{axisId: history.average_runtime,
id: history.average_runtime, name: Average Runtime in Seconds}], showLabels: true,
showValues: true, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
type: linear}, {label: '', orientation: right, series: [{axisId: query.count,
id: query.count, name: Query}], showLabels: true, showValues: true, unpinAxis: false,
tickDensity: default, type: linear}]
series_types: {}
series_colors:
history.average_runtime: "#222"
history.dashboard_run_count: "#2C72AC"
query.count: "#2C72AC"
reference_lines: [{reference_type: line, line_value: '30', range_start: max, range_end: min,
margin_top: deviation, margin_value: mean, margin_bottom: deviation, label_position: right,
color: "#B32F37", label: 30 Seconds}]
trend_lines: []
swap_axes: false
show_null_points: true
defaults_version: 1
interpolation: linear
hidden_fields: [history.average_runtime]
hidden_points_if_no: []
pinned_columns:
"$$$_row_numbers_$$$": left
dashboard.title: left
listen: {}
row: 109
col: 0
width: 24
height: 9
- title: Scheduled Plan Count (Dashboards)
name: Scheduled Plan Count (Dashboards)
model: system__activity
explore: scheduled_plan
type: looker_grid
fields: [dashboard.title, count_of_id_2, count_of_user_id, count_of_address, dashboard.id]
filters:
dashboard.title: "-NULL"
sorts: [count_of_id_2 desc]
limit: 500
dynamic_fields: [{category: table_calculation, expression: "${count_of_id_2}",
label: Schedule Count, value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: schedule_count, _type_hint: number},
{category: table_calculation, expression: "${count_of_user_id}", label: Count
of Users (Scheduler), value_format: !!null '', value_format_name: !!null '',
_kind_hint: measure, table_calculation: count_of_users_scheduler, _type_hint: number},
{category: table_calculation, expression: "${count_of_address}", label: Recipient
Count, value_format: !!null '', value_format_name: !!null '', _kind_hint: measure,
table_calculation: recipient_count, _type_hint: number}, {measure: count_of_id,
based_on: scheduled_job.id, expression: '', label: Count of ID, type: count_distinct,
_kind_hint: measure, _type_hint: number}, {category: measure, expression: '',
label: Count of User ID, based_on: scheduled_plan.user_id, _kind_hint: measure,
measure: count_of_user_id, type: count_distinct, _type_hint: number}, {measure: count_of_address,
based_on: scheduled_plan_destination.address, expression: '', label: Count
of Address, type: count_distinct, _kind_hint: measure, _type_hint: number},
{measure: count_of_id_2, based_on: scheduled_plan.id, expression: '', label: Count
of ID, type: count_distinct, _kind_hint: measure, _type_hint: number}]
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
show_sql_query_menu_options: false
column_order: ["$$$_row_numbers_$$$", dashboard.title, dashboard.id, schedule_count,
count_of_users_scheduler, recipient_count, scheduled_job_stage.avg_runtime]
show_totals: true
show_row_totals: true
series_cell_visualizations:
count_of_id:
is_active: false
palette:
palette_id: 1e4d66b9-f066-4c33-b0b7-cc10b4810688
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
series_text_format:
recipient_count:
align: left
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
defaults_version: 1
series_types: {}
hidden_fields: [count_of_user_id, count_of_address, count_of_id_2, dashboard.id]
y_axes: []
listen: {}
row: 118
col: 0
width: 24
height: 6
- title: Cache vs Database L30D
name: Cache vs Database L30D
model: system__activity
explore: history
type: looker_column
fields: [dashboard.title, history.cache_result_query_count, history.database_result_query_count,
history.query_run_count]
filters:
history.completed_date: 30 days
dashboard.title: "-EMPTY"
sorts: [sort desc]
limit: 500
column_limit: 50
dynamic_fields: [{category: table_calculation, expression: "${history.cache_result_query_count}\n\
\n/\n\n(${history.database_result_query_count}\n+ \n${history.cache_result_query_count})",
label: sort, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
table_calculation: sort, _type_hint: number}]
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: percent
limit_displayed_rows: false
legend_position: center
point_style: circle
show_value_labels: true
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
color_application:
collection_id: bergfreunde
palette_id: bergfreunde-categorical-0
options:
steps: 5
y_axes: [{label: !!null '', orientation: left, series: [{axisId: history.average_runtime,
id: history.average_runtime, name: Average Runtime in Seconds}], showLabels: true,
showValues: true, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
type: linear}, {label: '', orientation: right, series: [{axisId: query.count,
id: query.count, name: Query}], showLabels: true, showValues: true, unpinAxis: false,
tickDensity: default, type: linear}]
hidden_series: [history.dashboard_run_count, query.count]
series_types:
history.average_runtime: scatter
series_colors:
history.average_runtime: "#222"
history.dashboard_run_count: "#2C72AC"
query.count: "#2C72AC"
history.database_result_query_count: "#2C72AC"
history.cache_result_query_count: "#222"
series_labels: {}
reference_lines: [{reference_type: line, line_value: '30', range_start: max, range_end: min,
margin_top: deviation, margin_value: mean, margin_bottom: deviation, label_position: right,
color: "#B32F37", label: 30 Seconds}]
trend_lines: []
swap_axes: false
show_null_points: true
defaults_version: 1
interpolation: linear
hidden_fields: [history.query_run_count, sort]
hidden_points_if_no: []
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: 12
rows_font_size: 12
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
listen: {}
row: 100
col: 0
width: 24
height: 9
- name: Performance and Users
type: text
title_text: Performance and Users
body_text: ''
row: 0
col: 0
width: 24
height: 2
- name: Dashboards and Schedules
type: text
title_text: Dashboards and Schedules
body_text: ''
row: 87
col: 0
width: 24
height: 2
- title: Query Times by Source L30D
name: Query Times by Source L30D
model: system__activity
explore: history
type: looker_bar
fields: [history.issuer_source, history.query_run_count, history.runtime_tiers]
pivots: [history.runtime_tiers]
filters:
history.completed_date: 30 days
history.runtime_tiers: "-Below 0, -Undefined"
history.issuer_source: "-API,-Action Hub,-Other"
sorts: [history.runtime_tiers, history.issuer_source desc]
limit: 500
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: normal
limit_displayed_rows: false
legend_position: center
point_style: none
show_value_labels: true
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
color_application:
collection_id: 5591d8d1-6b49-4f8e-bafa-b874d82f8eb7
palette_id: 57bef7ef-25c4-448e-83df-9c4de399305d
options:
steps: 5
reverse: true
y_axes: []
font_size: '12'
series_types: {}
series_colors: {}
charts_across: 4
defaults_version: 1
value_labels: legend
label_type: labPer
hidden_fields: []
listen: {}
row: 40
col: 0
width: 12
height: 8
- title: New Tile
name: New Tile
model: system__activity
explore: user
type: single_value
fields: [user.count]
filters:
user.is_disabled: 'No'
user_facts.is_looker_employee: 'No'
limit: 500
dynamic_fields: [{category: table_calculation, expression: 'running_total(${user.count})',
label: Total Users, value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: total_users, _type_hint: number, is_disabled: true}]
query_timezone: America/Denver
custom_color_enabled: true
show_single_value_title: true
show_comparison: false
comparison_type: value
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
color_application:
collection_id: bergfreunde
palette_id: bergfreunde-categorical-0
options:
steps: 5
single_value_title: Total Users
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: false
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: true
interpolation: linear
series_colors:
user.count: "#2C72AC"
session.count: "#222"
defaults_version: 1
hidden_fields: []
series_types: {}
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
header_text_alignment: left
header_font_size: 12
rows_font_size: 12
y_axes: []
listen: {}
row: 2
col: 0
width: 5
height: 4
- title: Top Users L30D
name: Top Users L30D
model: system__activity
explore: history
type: looker_grid
fields: [history.dashboard_run_count, user.name, query.count]
filters:
history.completed_month: 30 days
sorts: [query.count desc]
limit: 500
column_limit: 50
query_timezone: America/Denver
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
show_sql_query_menu_options: false
show_totals: true
show_row_totals: true
truncate_header: false
series_cell_visualizations:
history.dashboard_run_count:
is_active: true
palette:
palette_id: 85de97da-2ded-4dec-9dbd-e6a7d36d5825
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
query.count:
is_active: true
custom_color_enabled: true
show_single_value_title: true
show_comparison: false
comparison_type: value
comparison_reverse_colors: false
show_comparison_label: true
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: true
interpolation: linear
defaults_version: 1
hidden_fields: [history.dashboard_run_count]
series_types: {}
y_axes: []
listen: {}
row: 32
col: 12
width: 12
height: 8
- title: Dashboard Runs L30D
name: Dashboard Runs L30D
model: system__activity
explore: history
type: single_value
fields: [history.dashboard_run_count]
filters:
history.completed_month: 30 days
sorts: [history.dashboard_run_count desc]
limit: 500
query_timezone: America/Denver
custom_color_enabled: true
show_single_value_title: true
show_comparison: false
comparison_type: value
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
show_sql_query_menu_options: false
show_totals: true
show_row_totals: true
series_cell_visualizations:
history.dashboard_run_count:
is_active: true
palette:
palette_id: 85de97da-2ded-4dec-9dbd-e6a7d36d5825
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: true
interpolation: linear
defaults_version: 1
hidden_fields: []
series_types: {}
y_axes: []
listen: {}
row: 2
col: 10
width: 5
height: 4
- title: Query Runs L30D
name: Query Runs L30D
model: system__activity
explore: history
type: single_value
fields: [history.query_run_count]
filters:
history.completed_month: 30 days
limit: 500
dynamic_fields: [{category: table_calculation, expression: "${history.query_run_count}",
label: 'Query Runs ', value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: query_runs, _type_hint: number}]
query_timezone: America/Denver
custom_color_enabled: true
show_single_value_title: true
show_comparison: false
comparison_type: value
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
color_application:
collection_id: bergfreunde_bw
palette_id: bergfreunde_bw-categorical-0
options:
steps: 5
custom_color: "#000000"
conditional_formatting: []
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: false
legend_position: center
series_types: {}
point_style: circle
series_colors:
history.query_run_count: "#222"
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: true
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
show_sql_query_menu_options: false
show_totals: true
show_row_totals: true
series_cell_visualizations:
history.dashboard_run_count:
is_active: true
palette:
palette_id: 85de97da-2ded-4dec-9dbd-e6a7d36d5825
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
interpolation: linear
defaults_version: 1
hidden_fields: [history.query_run_count]
map_plot_mode: points
heatmap_gridlines: false
heatmap_gridlines_empty: false
heatmap_opacity: 0.5
show_region_field: true
draw_map_labels_above_data: true
map_tile_provider: light
map_position: fit_data
map_scale_indicator: 'off'
map_pannable: true
map_zoomable: true
map_marker_type: circle
map_marker_icon_name: default
map_marker_radius_mode: proportional_value
map_marker_units: meters
map_marker_proportional_scale_type: linear
map_marker_color_mode: fixed
show_legend: true
quantize_map_value_colors: false
reverse_map_value_colors: false
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
y_axes: []
listen: {}
row: 2
col: 15
width: 5
height: 4
- title: Runtime
name: Runtime
model: system__activity
explore: history
type: single_value
fields: [history.average_runtime]
filters:
history.completed_date: 30 days
limit: 500
dynamic_fields: [{category: table_calculation, expression: "${history.average_runtime}",
label: avg, value_format: !!null '', value_format_name: decimal_1, _kind_hint: measure,
table_calculation: avg, _type_hint: number}]
query_timezone: America/Denver
custom_color_enabled: true
show_single_value_title: true
show_comparison: false
comparison_type: value
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
color_application:
collection_id: bergfreunde_2
palette_id: bergfreunde_2-categorical-0
options:
steps: 5
single_value_title: Average Runtime Seconds L30D
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: normal
limit_displayed_rows: false
legend_position: center
point_style: none
show_value_labels: true
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
font_size: '12'
series_types: {}
series_colors: {}
charts_across: 4
defaults_version: 1
value_labels: legend
label_type: labPer
hidden_fields: [history.average_runtime]
y_axes: []
listen: {}
row: 2
col: 20
width: 4
height: 4
- title: 'Query Runs: Cache vs Database L3M'
name: 'Query Runs: Cache vs Database L3M'
model: system__activity
explore: history
type: looker_column
fields: [history.average_runtime, history.dashboard_run_count, query.count, history.result_source,
history.completed_week]
pivots: [history.result_source]
fill_fields: [history.completed_week]
filters:
history.result_source: -"stale_cache",-EMPTY
history.completed_month: 3 months
sorts: [history.result_source desc, history.completed_week desc]
limit: 100
column_limit: 50
dynamic_fields: [{category: table_calculation, expression: "${history.average_runtime}",
label: AVG Runtime Seconds, value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: avg_runtime_seconds, _type_hint: number}]
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: normal
limit_displayed_rows: false
legend_position: center
point_style: circle
show_value_labels: true
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
color_application:
collection_id: bergfreunde
palette_id: bergfreunde-categorical-0
options:
steps: 5
y_axes: [{label: !!null '', orientation: left, series: [{axisId: history.average_runtime,
id: history.average_runtime, name: Average Runtime in Seconds}], showLabels: true,
showValues: true, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
type: linear}, {label: '', orientation: right, series: [{axisId: query.count,
id: query.count, name: Query}], showLabels: true, showValues: true, unpinAxis: false,
tickDensity: default, type: linear}]
series_types: {}
series_colors:
history.average_runtime: "#222"
history.dashboard_run_count: "#2C72AC"
query.count: "#2C72AC"
query - query.count: "#222"
cache - query.count: "#2C72AC"
series_labels:
query.count: Query Count
query - query.count: Results from Database
cache - query.count: Results from Cache
reference_lines: []
trend_lines: []
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
show_sql_query_menu_options: false
column_order: ["$$$_row_numbers_$$$", dashboard.title, query_avg_runtime_seconds,
query_history.dashboard_run_count, query_query.count, cache_avg_runtime_seconds,
cache_history.dashboard_run_count, cache_query.count]
show_totals: true
show_row_totals: true
series_column_widths:
avg_runtime_seconds: 112
series_cell_visualizations:
history.average_runtime:
is_active: false
series_text_format:
query.count:
align: left
history.dashboard_run_count:
align: left
swap_axes: false
show_null_points: true
defaults_version: 1
interpolation: linear
hidden_fields: [history.average_runtime, avg_runtime_seconds, history.dashboard_run_count]
hidden_points_if_no: []
pinned_columns:
"$$$_row_numbers_$$$": left
dashboard.title: left
listen: {}
row: 14
col: 0
width: 24
height: 9
- name: Query Runs vs Runtime L3M
title: Query Runs vs Runtime L3M
merged_queries:
- model: system__activity
explore: user
type: table
fields: [user.count, user.created_week]
fill_fields: [user.created_week]
filters:
user.is_disabled: 'No'
user.created_month: 3 months
limit: 500
dynamic_fields: [{category: table_calculation, expression: 'running_total(${user.count})',
label: Total Users, value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: total_users, _type_hint: number,
is_disabled: true}]
join_fields: []
- model: system__activity
explore: history
type: table
fields: [history.dashboard_run_count, history.average_runtime, history.completed_week]
fill_fields: [history.completed_week]
filters:
history.completed_month: 3 months
limit: 500
join_fields:
- field_name: history.completed_week
source_field_name: user.created_week
color_application:
collection_id: bergfreunde
palette_id: bergfreunde-categorical-0
options:
steps: 5
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
y_axes: [{label: '', orientation: left, series: [{axisId: user.count, id: user.count,
name: Users Added}, {axisId: history.dashboard_run_count, id: history.dashboard_run_count,
name: Dashboard Run Count}], showLabels: true, showValues: true, unpinAxis: false,
tickDensity: default, type: linear}, {label: !!null '', orientation: right,
series: [{axisId: average_runtime_seconds, id: average_runtime_seconds, name: 'Average
Runtime Seconds '}, {axisId: history.average_runtime, id: history.average_runtime,
name: Average Runtime in Seconds}], showLabels: true, showValues: true,
unpinAxis: false, tickDensity: default, type: linear}]
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: false
legend_position: center
series_types:
user.count: scatter
point_style: none
series_colors:
total_users: "#222"
history.dashboard_run_count: "#2C72AC"
series_labels:
user.count: Users Added
series_point_styles:
user.count: triangle
show_value_labels: true
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: false
interpolation: linear
type: looker_line
hidden_fields: [history.average_runtime]
sorts: [user.created_week desc]
column_limit: 50
dynamic_fields: [{category: table_calculation, expression: "${history.average_runtime}",
label: 'Average Runtime Seconds ', value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: average_runtime_seconds, _type_hint: number}]
row: 6
col: 0
width: 24
height: 8
- title: DashBoard Count
name: DashBoard Count
model: system__activity
explore: dashboard
type: single_value
fields: [dashboard.count, dashboard.count_last_30_days]
filters:
dashboard.moved_to_trash: 'No'
limit: 500
column_limit: 50
dynamic_fields: [{table_calculation: total_dashboards, label: Total Dashboards,
expression: 'sum(${dashboard.count})', value_format: !!null '', value_format_name: !!null '',
_kind_hint: measure, _type_hint: number, is_disabled: true}, {table_calculation: last_30_days,
label: Last 30 days, expression: "sum(\n if(diff_days(${dashboard.created_date},\
\ now()) <= 30, ${dashboard.count},0))", value_format: !!null '', value_format_name: !!null '',
_kind_hint: measure, _type_hint: number, is_disabled: true}, {measure: in_last_30_days,
based_on: dashboard.id, type: count_distinct, label: In Last 30 Days, value_format: !!null '',
value_format_name: !!null '', _kind_hint: measure, _type_hint: number, filter_expression: 'diff_days(${dashboard.created_date},
now()) <= 30'}]
custom_color_enabled: false
show_single_value_title: true
show_comparison: false
comparison_type: change
comparison_reverse_colors: false
show_comparison_label: true
enable_conditional_formatting: false
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
custom_color: forestgreen
single_value_title: Dashboard Count
comparison_label: Last 30 Days
series_types: {}
hidden_fields: []
note_state: collapsed
note_display: hover
note_text: Total Non-Deleted Dashboards
defaults_version: 1
y_axes: []
listen: {}
row: 2
col: 5
width: 5
height: 4
- title: Unengaged Users
name: Unengaged Users
model: system__activity
explore: user
type: looker_grid
fields: [user.id, user.name, user.created_date, user_facts.last_ui_login_date,
history.most_recent_query_date, scheduled_plan.count, user_facts.last_ui_login_credential_type]
filters:
user_facts.last_ui_login_date: before 90 days ago
user.is_disabled: 'No'
user_facts.is_looker_employee: 'No'
sorts: [user_facts.last_ui_login_date]
limit: 100
column_limit: 50
dynamic_fields: [{table_calculation: no_query_login, label: 'No-Query Login?',
expression: "${history.most_recent_query_date} < ${user_facts.last_ui_login_date}",
value_format: !!null '', value_format_name: !!null '', _kind_hint: measure,
_type_hint: yesno}, {table_calculation: days_since_last_login, label: Days
Since Last Login, expression: 'diff_days(${user_facts.last_ui_login_date},
trunc_days(now()))', value_format: !!null '', value_format_name: !!null '',
_kind_hint: dimension, _type_hint: number}]
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: true
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
color_application:
collection_id: aed851c8-b22d-4b01-8fff-4b02b91fe78d
palette_id: c36094e3-d04d-4aa4-8ec7-bc9af9f851f4
show_sql_query_menu_options: false
show_totals: true
show_row_totals: true
series_labels:
user_facts.last_ui_login_date: Last Login
user_facts.last_api_login_date: Last API Login Date
user.name: Name
user.created_date: Created Date
history.most_recent_query_date: Last Query
scheduled_plan.count: Count of Scheduled Plans
series_cell_visualizations:
days_since_last_login:
is_active: true
palette:
palette_id: 2da48dd9-f8f5-45cc-81a6-74037767d59b
collection_id: aed851c8-b22d-4b01-8fff-4b02b91fe78d
conditional_formatting: [{type: along a scale..., value: !!null '', background_color: "#81BE56",
font_color: !!null '', color_application: {collection_id: aed851c8-b22d-4b01-8fff-4b02b91fe78d,
palette_id: e26878fa-802e-47d9-9478-62fb4307f763, options: {steps: 32, constraints: {
min: {type: number, value: 10}, mid: {type: middle}, max: {type: number,
value: 200}}, reverse: true, stepped: false}}, bold: false, italic: false,
strikethrough: false, fields: [days_since_last_login]}]
truncate_column_names: false
hidden_fields: [user.id, no_query_login, user_facts.last_ui_login_date, user_facts.last_ui_login_credential_type,
user.created_date, scheduled_plan.count, history.most_recent_query_date]
note_state: collapsed
note_display: hover
note_text: Users who have not authenticated into Looker in the last 90 days.
defaults_version: 1
series_types: {}
y_axes: []
listen: {}
row: 40
col: 12
width: 12
height: 8
- title: Queue Time for Execution
name: Queue Time for Execution
model: system__activity
explore: scheduled_plan
type: looker_grid
fields: [scheduled_job_stage.avg_runtime, scheduled_job.count, dashboard.title]
filters:
scheduled_job_stage.stage: '"enqueue_for_execute"'
scheduled_job.created_date: 30 days ago for 30 days
sorts: [scheduled_job_stage.avg_runtime desc]
limit: 500
column_limit: 50
show_view_names: false
show_row_numbers: false
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: transparent
limit_displayed_rows: false
enable_conditional_formatting: true
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: true
color_application:
collection_id: aed851c8-b22d-4b01-8fff-4b02b91fe78d
palette_id: c36094e3-d04d-4aa4-8ec7-bc9af9f851f4
show_sql_query_menu_options: false
show_totals: true
show_row_totals: true
truncate_header: false
series_labels:
scheduled_job_stage.avg_runtime: Average Time in Queue
scheduled_job.count: Run Count
series_cell_visualizations:
scheduled_job_stage.avg_runtime:
is_active: false
palette:
palette_id: e26878fa-802e-47d9-9478-62fb4307f763
collection_id: aed851c8-b22d-4b01-8fff-4b02b91fe78d
conditional_formatting: [{type: along a scale..., value: !!null '', background_color: "#81BE56",
font_color: !!null '', color_application: {collection_id: aed851c8-b22d-4b01-8fff-4b02b91fe78d,
palette_id: e26878fa-802e-47d9-9478-62fb4307f763, options: {steps: 5, constraints: {
min: {type: minimum}, mid: {type: middle}, max: {type: maximum}}, mirror: true,
reverse: true, stepped: false}}, bold: false, italic: false, strikethrough: false,
fields: [scheduled_job_stage.avg_runtime]}, {type: along a scale..., value: !!null '',
background_color: "#81BE56", font_color: !!null '', color_application: {collection_id: aed851c8-b22d-4b01-8fff-4b02b91fe78d,
custom: {id: 3824bfef-80a2-2fb2-cb03-c0e767fc1658, label: Custom, type: continuous,
stops: [{color: "#FFFFFF", offset: 0}, {color: "#fa461f", offset: 100}]},
options: {steps: 5, constraints: {min: {type: minimum}, mid: {type: middle},
max: {type: maximum}}, mirror: true, reverse: false, stepped: false}},
bold: false, italic: false, strikethrough: false, fields: [scheduled_job.count]}]
truncate_column_names: false
series_types: {}
defaults_version: 1
hidden_fields: []
y_axes: []
listen: {}
row: 32
col: 0
width: 12
height: 8
- title: Query Over 300 Seconds L30D
name: Query Over 300 Seconds L30D
model: system__activity
explore: history
type: looker_grid
fields: [history.issuer_source, history.real_dash_id, history.connection_name,
history.cache, dashboard.title, history.completed_date, history.runtime, history.id]
filters:
history.completed_date: 30 days
history.runtime_tiers: 300 or Above
history.issuer_source: "-API,-Action Hub,-Other"
sorts: [history.completed_date desc]
limit: 500
query_timezone: America/Denver
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: 12
rows_font_size: 12
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: normal
legend_position: center
point_style: none
show_value_labels: true
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
color_application:
collection_id: bergfreunde_2
palette_id: bergfreunde_2-categorical-0
options:
steps: 5
font_size: '12'
series_types: {}
series_colors: {}
charts_across: 4
defaults_version: 1
value_labels: legend
label_type: labPer
hidden_series: []
column_order: ["$$$_row_numbers_$$$", history.id, dashboard.title, history.real_dash_id,
history.completed_date, history.issuer_source, history.connection_name, history.cache,
history.runtime]
series_column_widths:
dashboard.title: 195
history.real_dash_id: 167
history.completed_date: 122
history.issuer_source: 110
history.connection_name: 217
history.cache: 187
history.runtime: 143
history.id: 107
hidden_fields: []
y_axes: []
listen: {}
row: 48
col: 0
width: 24
height: 6
- title: PDT Builds L30D
name: PDT Builds L30D
model: system__activity
explore: pdt_builds
type: looker_grid
fields: [pdt_builds.build_reason, pdt_builds.average_build_time_seconds, pdt_builds.average_build_time_minutes]
fill_fields: [pdt_builds.build_reason]
filters:
pdt_builds.end_date: 30 days
sorts: [pdt_builds.average_build_time_seconds desc]
limit: 500
dynamic_fields: [{category: table_calculation, expression: "${pdt_builds.average_build_time_seconds}",
label: AVG Build Time Seconds, value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: avg_build_time_seconds, _type_hint: number}]
query_timezone: America/Denver
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
show_sql_query_menu_options: false
show_totals: true
show_row_totals: true
series_cell_visualizations:
pdt_builds.average_build_time_seconds:
is_active: true
avg_build_time_seconds:
is_active: true
palette:
palette_id: 471a8295-662d-46fc-bd2d-2d0acd370c1e
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
defaults_version: 1
series_types: {}
hidden_fields: [pdt_builds.average_build_time_seconds, pdt_builds.average_build_time_minutes]
y_axes: []
listen: {}
row: 64
col: 0
width: 12
height: 5
- title: PDT Builds by Result L30D
name: PDT Builds by Result L30D
model: system__activity
explore: pdt_builds
type: looker_grid
fields: [pdt_builds.build_result, count_of_end_time, build_result, sum_of_elapsed_seconds]
filters:
pdt_builds.end_date: 30 days
count_of_end_time: NOT NULL
sorts: [run_count desc]
limit: 500
dynamic_fields: [{measure: count_of_end_time, based_on: pdt_builds.end_time, expression: '',
label: Count of End Time, type: count_distinct, _kind_hint: measure, _type_hint: number},
{category: table_calculation, expression: "${count_of_end_time}", label: Run
Count, value_format: !!null '', value_format_name: !!null '', _kind_hint: measure,
table_calculation: run_count, _type_hint: number}, {category: dimension, expression: 'if(${pdt_builds.build_result}
= "Successful Build", "Success","Failure")', label: Build Result, value_format: !!null '',
value_format_name: !!null '', dimension: build_result, _kind_hint: dimension,
_type_hint: string}, {measure: count_of_elapsed_seconds, based_on: pdt_builds.elapsed_seconds,
expression: '', label: Count of Elapsed Seconds, type: count_distinct, _kind_hint: measure,
_type_hint: number}, {measure: sum_of_elapsed_seconds, based_on: pdt_builds.elapsed_seconds,
expression: '', label: Sum of Elapsed Seconds, type: sum, _kind_hint: measure,
_type_hint: number}, {measure: sum_of_elapsed_minutes, based_on: pdt_builds.elapsed_minutes,
expression: '', label: Sum of Elapsed Minutes, type: sum, _kind_hint: measure,
_type_hint: number}]
query_timezone: America/Denver
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: true
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
color_application:
collection_id: 7c79334a-9912-4ca1-be6a-35756782ae09
palette_id: de0bdb92-9455-489c-afa7-f0e0fdc76078
show_sql_query_menu_options: false
column_order: ["$$$_row_numbers_$$$", pdt_builds.view_name, pdt_builds.build_result,
pdt_builds.start_date]
show_totals: true
show_row_totals: true
series_labels:
count_of_elapsed_seconds: Run Seconds
sum_of_elapsed_seconds: Run Seconds
sum_of_elapsed_minutes: Run Minutes
series_column_widths:
pdt_builds.view_name: 311
series_cell_visualizations:
count_of_end_time:
is_active: false
palette:
palette_id: 1e4d66b9-f066-4c33-b0b7-cc10b4810688
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
run_count:
is_active: false
palette:
palette_id: 9bba0279-71a4-410a-bd57-3afc0dfabaad
collection_id: 7c79334a-9912-4ca1-be6a-35756782ae09
series_text_format:
run_count: {}
count_of_elapsed_seconds:
align: left
sum_of_elapsed_seconds:
align: left
conditional_formatting: []
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: normal
legend_position: center
series_types: {}
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
defaults_version: 1
hidden_fields: [count_of_end_time, build_result]
y_axes: []
listen: {}
row: 64
col: 12
width: 12
height: 5
- title: PDT Build Success vs Failure 30D
name: PDT Build Success vs Failure 30D
model: system__activity
explore: pdt_builds
type: looker_area
fields: [count_of_end_time, build_results, pdt_builds.end_date]
pivots: [build_results]
fill_fields: [pdt_builds.end_date]
filters:
pdt_builds.end_month: 30 days
sorts: [build_results, pdt_builds.end_date desc]
limit: 500
dynamic_fields: [{measure: count_of_end_time, based_on: pdt_builds.end_time, expression: '',
label: Count of End Time, type: count_distinct, _kind_hint: measure, _type_hint: number},
{category: table_calculation, expression: "${count_of_end_time}", label: Run
Count, value_format: !!null '', value_format_name: !!null '', _kind_hint: measure,
table_calculation: run_count, _type_hint: number}, {category: dimension, expression: 'if(${pdt_builds.build_result}
= "Successful Build", "Success","Failure")', label: Build Results, value_format: !!null '',
value_format_name: !!null '', dimension: build_results, _kind_hint: measure,
_type_hint: string}]
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
limit_displayed_rows: false
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
show_null_points: true
interpolation: linear
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
color_application:
collection_id: 7c79334a-9912-4ca1-be6a-35756782ae09
palette_id: de0bdb92-9455-489c-afa7-f0e0fdc76078
y_axes: []
x_axis_zoom: true
y_axis_zoom: true
series_types: {}
series_colors:
Success - run_count: "#068993"
show_sql_query_menu_options: false
column_order: ["$$$_row_numbers_$$$", pdt_builds.view_name, pdt_builds.build_result,
pdt_builds.start_date]
show_totals: true
show_row_totals: true
show_row_numbers: true
transpose: false
truncate_text: true
size_to_fit: true
series_column_widths:
pdt_builds.view_name: 311
series_cell_visualizations:
count_of_end_time:
is_active: false
palette:
palette_id: 1e4d66b9-f066-4c33-b0b7-cc10b4810688
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
table_theme: white
enable_conditional_formatting: true
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting: [{type: along a scale..., value: !!null '', background_color: "#F15922",
font_color: !!null '', color_application: {collection_id: 7c79334a-9912-4ca1-be6a-35756782ae09,
palette_id: 5b289dc9-1446-49e6-ab05-ba239a94b7a9, options: {steps: 5, reverse: false}},
bold: false, italic: false, strikethrough: false, fields: !!null ''}]
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
ordering: none
show_null_labels: false
defaults_version: 1
hide_totals: false
hide_row_totals: false
hidden_fields: [count_of_end_time]
listen: {}
row: 56
col: 0
width: 24
height: 8
- name: PDT Build Monitoring
type: text
title_text: PDT Build Monitoring
body_text: ''
row: 54
col: 0
width: 24
height: 2
- title: PDT Runs by View L30D
name: PDT Runs by View L30D
model: system__activity
explore: pdt_builds
type: looker_column
fields: [pdt_builds.view_name, count_of_end_time, build_results]
pivots: [build_results]
filters:
pdt_builds.end_date: 30 days ago for 30 days
sorts: [build_results, failure desc]
limit: 500
dynamic_fields: [{measure: count_of_end_time, based_on: pdt_builds.end_time, expression: '',
label: Count of End Time, type: count_distinct, _kind_hint: measure, _type_hint: number},
{category: dimension, expression: 'if(${pdt_builds.build_result} = "Successful
Build", "Success","Failure")', label: Build Results, value_format: !!null '',
value_format_name: !!null '', dimension: build_results, _kind_hint: measure,
_type_hint: string}, {category: table_calculation, expression: "coalesce(pivot_where(${build_results}!=\"\
Success\", ${count_of_end_time}),0)\n/\ncoalesce(pivot_where(${build_results}=\"\
Success\", ${count_of_end_time}),0)", label: "%", value_format: !!null '',
value_format_name: percent_0, _kind_hint: supermeasure, table_calculation: calculation,
_type_hint: number, is_disabled: true}, {category: table_calculation, expression: 'coalesce(${count_of_end_time},0)',
label: Run Count, value_format: !!null '', value_format_name: !!null '', _kind_hint: measure,
table_calculation: run_count, _type_hint: number}, {category: table_calculation,
expression: "(pivot_index(${run_count},1))\n/\n(pivot_index(${run_count},1)\n\
+\npivot_index(${run_count},2)\n)", label: "% Failure", value_format: !!null '',
value_format_name: percent_0, _kind_hint: supermeasure, table_calculation: failure,
_type_hint: number}]
query_timezone: America/Denver
x_axis_gridlines: false
y_axis_gridlines: true
show_view_names: false
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: percent
limit_displayed_rows: false
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
series_types: {}
series_colors:
Failure - count_of_end_time: "#B32F37"
Success - count_of_end_time: "#72D16D"
Failure - run_count: "#B32F37"
Success - run_count: "#72D16D"
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: 12
rows_font_size: 12
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
defaults_version: 1
column_order: ["$$$_row_numbers_$$$", pdt_builds.view_name, pdt_builds.build_result,
pdt_builds.start_date]
series_column_widths:
pdt_builds.view_name: 311
hidden_fields: [count_of_end_time, new_calculation, failure]
y_axes: []
listen: {}
row: 77
col: 0
width: 24
height: 10
- title: Current Failing Views L30D
name: Current Failing Views L30D
model: system__activity
explore: pdt_event_log
type: looker_grid
fields: [pdt_builds.view_name, count_of_end_time, build_results, sum_of_elapsed_seconds_2]
pivots: [build_results]
filters:
pdt_builds.end_date: 30 days
build_results: Failure
sorts: [build_results, sum_of_elapsed_seconds_2 desc 0]
limit: 5000
column_limit: 50
total: true
dynamic_fields: [{measure: sum_of_elapsed_seconds, based_on: pdt_builds.elapsed_seconds,
expression: '', label: Sum of Elapsed Seconds, type: sum, _kind_hint: measure,
_type_hint: number}, {measure: count_of_action_data, based_on: pdt_event_log.action_data,
expression: '', label: Count of Action Data, type: count_distinct, _kind_hint: measure,
_type_hint: number}, {measure: count_of_end_time, based_on: pdt_builds.end_time,
expression: '', label: Count of End Time, type: count_distinct, _kind_hint: measure,
_type_hint: number}, {category: dimension, expression: 'if(${pdt_builds.build_result}
= "Successful Build", "Success","Failure")', label: Build Results, value_format: !!null '',
value_format_name: !!null '', dimension: build_results, _kind_hint: measure,
_type_hint: string}, {category: table_calculation, expression: 'pivot_index(${build_results},1)',
label: Successful Builds, value_format: !!null '', value_format_name: !!null '',
_kind_hint: supermeasure, table_calculation: successful_builds, _type_hint: string,
is_disabled: true}, {category: table_calculation, expression: 'pivot_index(${build_results},
1)', label: New Calculation, value_format: !!null '', value_format_name: !!null '',
_kind_hint: supermeasure, table_calculation: new_calculation, _type_hint: string,
is_disabled: true}, {measure: sum_of_elapsed_seconds_2, based_on: pdt_builds.elapsed_seconds,
expression: '', label: Sum of Elapsed Seconds, type: sum, _kind_hint: measure,
_type_hint: number}, {measure: sum_of_elapsed_minutes, based_on: pdt_builds.elapsed_minutes,
expression: '', label: Sum of Elapsed Minutes, type: sum, _kind_hint: measure,
_type_hint: number}]
query_timezone: America/Denver
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
show_sql_query_menu_options: false
pinned_columns:
"$$$_row_numbers_$$$": left
column_order: ["$$$_row_numbers_$$$", pdt_builds.view_name, pdt_event_log.action_data]
show_totals: true
show_row_totals: true
series_labels:
count_of_end_time: Run Count
sum_of_elapsed_seconds_2: Seconds Wasted
series_column_widths:
pdt_event_log.action_data: 2873
pdt_builds.build_result: 133
pdt_builds.elapsed_seconds: 128
pdt_builds.end_time: 148
pdt_event_log.view_name: 188
pdt_event_log.action: 154
pdt_event_log.created_time: 147
pdt_builds.build_reason: 187
pdt_builds.view_name: 406
sum_of_elapsed_seconds: 169
series_cell_visualizations:
count_of_end_time:
is_active: false
palette:
palette_id: 2d9abb49-d953-c441-86f3-46e444d69836
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
custom_colors:
- "#3be617"
- "#6afa55"
- "#f6ff7c"
- "#f27748"
- "#ff8352"
sum_of_elapsed_seconds_2:
is_active: true
palette:
palette_id: '09bb30be-bc4f-18bf-133c-bf4d6f756d80'
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
custom_colors:
- "#f7fa59"
- "#feb647"
- "#f5924c"
- "#ff6d45"
- "#f24b2e"
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
defaults_version: 1
series_types: {}
series_text_format:
count_of_end_time:
align: left
hidden_fields: []
y_axes: []
listen: {}
row: 69
col: 0
width: 24
height: 8
- name: Other
type: text
title_text: Other
body_text: ''
row: 130
col: 0
width: 24
height: 2
- name: Completed Queries by Explore L30D
title: Completed Queries by Explore L30D
merged_queries:
- model: system__activity
explore: history
type: table
fields: [query.view]
limit: 500
join_fields: []
- model: system__activity
explore: history
type: table
fields: [query.view, history.query_run_count]
filters:
history.completed_month: 30 days ago for 30 days
sorts: [history.query_run_count desc]
limit: 500
join_fields:
- field_name: query.view
source_field_name: query.view
type: looker_column
sorts: [history.query_run_count desc]
column_limit: 50
row: 23
col: 0
width: 24
height: 9
- title: Scheduled Plan Count (Looks)
name: Scheduled Plan Count (Looks)
model: system__activity
explore: scheduled_plan
type: looker_grid
fields: [count_of_id_2, count_of_user_id, count_of_address, look.title]
filters:
look.title: "-NULL"
sorts: [count_of_id_2 desc]
limit: 500
column_limit: 50
dynamic_fields: [{category: table_calculation, expression: "${count_of_id_2}",
label: Schedule Count, value_format: !!null '', value_format_name: decimal_0,
_kind_hint: measure, table_calculation: schedule_count, _type_hint: number},
{category: table_calculation, expression: "${count_of_user_id}", label: Count
of Users (Scheduler), value_format: !!null '', value_format_name: !!null '',
_kind_hint: measure, table_calculation: count_of_users_scheduler, _type_hint: number},
{category: table_calculation, expression: "${count_of_address}", label: Recipient
Count, value_format: !!null '', value_format_name: !!null '', _kind_hint: measure,
table_calculation: recipient_count, _type_hint: number}, {measure: count_of_id,
based_on: scheduled_job.id, expression: '', label: Count of ID, type: count_distinct,
_kind_hint: measure, _type_hint: number}, {category: measure, expression: '',
label: Count of User ID, based_on: scheduled_plan.user_id, _kind_hint: measure,
measure: count_of_user_id, type: count_distinct, _type_hint: number}, {measure: count_of_address,
based_on: scheduled_plan_destination.address, expression: '', label: Count
of Address, type: count_distinct, _kind_hint: measure, _type_hint: number},
{measure: count_of_id_2, based_on: scheduled_plan.id, expression: '', label: Count
of ID, type: count_distinct, _kind_hint: measure, _type_hint: number}]
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: true
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: false
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
show_sql_query_menu_options: false
column_order: ["$$$_row_numbers_$$$", look.title, schedule_count, count_of_users_scheduler,
recipient_count]
show_totals: true
show_row_totals: true
series_cell_visualizations:
count_of_id:
is_active: false
palette:
palette_id: 1e4d66b9-f066-4c33-b0b7-cc10b4810688
collection_id: b43731d5-dc87-4a8e-b807-635bef3948e7
series_text_format:
recipient_count:
align: left
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
defaults_version: 1
series_types: {}
hidden_fields: [count_of_user_id, count_of_address, count_of_id_2]
y_axes: []
listen: {}
row: 124
col: 0
width: 24
height: 6
- title: Dashboard Recommendations
name: Dashboard Recommendations
model: system__activity
explore: dashboard
type: looker_grid
fields: [dashboard_element.high_merge_query_count, dashboard_element.high_query_count,
dashboard_element.low_auto_refresh_interval, dashboard_element.sorted_warnings,
user.name, dashboard_element.combo_warning, dashboard.title, dashboard_element.combo_recommendation]
filters:
dashboard.moved_to_trash: 'No'
dashboard_element.sorted_warnings: ">0"
sorts: [dashboard_element.sorted_warnings desc]
limit: 100
column_limit: 50
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: false
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: true
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
color_application:
collection_id: 5591d8d1-6b49-4f8e-bafa-b874d82f8eb7
palette_id: 18d0c733-1d87-42a9-934f-4ba8ef81d736
show_sql_query_menu_options: false
show_totals: true
show_row_totals: true
series_labels:
dashboard_element.sorted_warnings: Severity
dashboard_element.combo_warning: Warnings
dashboard_element.combo_recommendation: Recommendations
series_column_widths:
dashboard.id: 166
dashboard.title: 225
dashboard_element.sorted_warnings: 65
series_cell_visualizations:
dashboard_element.sorted_warnings:
is_active: false
series_text_format:
dashboard_element.sorted_warnings: {}
dashboard_element.combo_warning:
align: left
dashboard_element.combo_recommendation:
align: left
conditional_formatting: [{type: along a scale..., value: !!null '', background_color: "#3D52B9",
font_color: !!null '', color_application: {collection_id: 5591d8d1-6b49-4f8e-bafa-b874d82f8eb7,
palette_id: 5378478f-6725-4b04-89cc-75fc42da804e, options: {steps: 5, constraints: {
max: {type: number, value: 15}}}}, bold: false, italic: false, strikethrough: false,
fields: [dashboard_element.sorted_warnings]}]
hidden_fields: [user.name, dashboard_element.high_merge_query_count, dashboard_element.high_query_count,
dashboard_element.low_auto_refresh_interval]
defaults_version: 1
listen: {}
row: 139
col: 0
width: 24
height: 8
- title: Explore Recommendations
name: Explore Recommendations
model: system__activity
explore: query_metrics
type: looker_grid
fields: [query.view, query.model, history.connection_name, query_metrics.async_processing_average,
query_metrics.prepare_average, query_metrics.explore_init_average, query_metrics.marshalled_cache_load_average,
query_metrics.model_init_computed_average, query_metrics.acquire_connection_average,
query_metrics.execute_main_query_average, query_metrics.postprocessing_average,
query_metrics.stream_to_cache_average, query_metrics.sorted_warnings, query_metrics.combo_warning,
query_metrics.combo_recommendations]
filters:
query.view: "-EMPTY"
query.model: "-EMPTY"
query_metrics.minimum_query_events: '30'
query_metrics.sorted_warnings: ">0"
query_metrics.combo_recommendations: "-EMPTY"
query_metrics.combo_warning: "%time%"
sorts: [query_metrics.sorted_warnings desc]
limit: 500
column_limit: 50
show_view_names: false
show_row_numbers: true
transpose: false
truncate_text: false
hide_totals: false
hide_row_totals: false
size_to_fit: true
table_theme: white
limit_displayed_rows: false
enable_conditional_formatting: true
header_text_alignment: left
header_font_size: '12'
rows_font_size: '12'
conditional_formatting_include_totals: false
conditional_formatting_include_nulls: false
color_application:
collection_id: 5591d8d1-6b49-4f8e-bafa-b874d82f8eb7
palette_id: 18d0c733-1d87-42a9-934f-4ba8ef81d736
show_sql_query_menu_options: false
show_totals: true
show_row_totals: true
series_labels:
query_metrics.sorted_warnings: Severity
query_metrics.combo_warning: Warnings
query_metrics.combo_recommendations: Recommendations
series_column_widths:
query_metrics.stream_to_cache_average: 75
query.view: 55
query.model: 55
history.connection_name: 55
query_metrics.sorted_warnings: 55
series_cell_visualizations:
query_metrics.async_processing_average:
is_active: true
series_text_format:
query_metrics.combo_warning:
align: left
query_metrics.combo_recommendations:
align: left
conditional_formatting: [{type: along a scale..., value: 0, background_color: "#FC2E31",
font_color: !!null '', color_application: {collection_id: 5591d8d1-6b49-4f8e-bafa-b874d82f8eb7,
palette_id: 5378478f-6725-4b04-89cc-75fc42da804e, options: {steps: 4, constraints: {
min: {type: number, value: 0}, mid: {type: number, value: 1}, max: {
type: number, value: 6}}, stepped: false}}, bold: false, italic: false,
strikethrough: false, fields: !!null ''}]
x_axis_gridlines: false
y_axis_gridlines: true
show_y_axis_labels: true
show_y_axis_ticks: true
y_axis_tick_density: default
y_axis_tick_density_custom: 5
show_x_axis_label: true
show_x_axis_ticks: true
y_axis_scale_mode: linear
x_axis_reversed: false
y_axis_reversed: false
plot_size_by_field: false
trellis: ''
stacking: ''
legend_position: center
point_style: none
show_value_labels: false
label_density: 25
x_axis_scale: auto
y_axis_combined: true
ordering: none
show_null_labels: false
show_totals_labels: false
show_silhouette: false
totals_color: "#808080"
defaults_version: 1
series_types: {}
hidden_fields: [query_metrics.async_processing_average, query_metrics.prepare_average,
query_metrics.explore_init_average, query_metrics.marshalled_cache_load_average,
query_metrics.model_init_computed_average, query_metrics.acquire_connection_average,
query_metrics.execute_main_query_average, query_metrics.postprocessing_average,
query_metrics.stream_to_cache_average]
listen: {}
row: 147
col: 0
width: 24
height: 9