First cut of full revenue_trends dashboard
diff --git a/revenue_trends.dashboard.lookml b/revenue_trends.dashboard.lookml
new file mode 100644
index 0000000..8db2eef
--- /dev/null
+++ b/revenue_trends.dashboard.lookml
@@ -0,0 +1,1993 @@
+- dashboard: revenue_trends_gcp_core
+ title: Revenue Trends (GCP Core)
+ layout: newspaper
+ preferred_viewer: dashboards-next
+ description: ''
+ elements:
+ - title: Daily Sales Revenue Trends
+ name: Daily Sales Revenue Trends
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_line
+ fields: [revenue.usage_date, revenue.revenue_toggle]
+ fill_fields: [revenue.usage_date]
+ filters:
+ revenue.usage_date: 92 days ago for 90 days
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.service_family: CLOUD
+ sorts: [revenue.usage_date desc]
+ limit: 500
+ query_timezone: America/Los_Angeles
+ 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: true
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ y_axes: [{label: Daily Revenue, orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
+ showLabels: true, showValues: true, valueFormat: "[>1000000000]$0.00,,,\\\
+ B;[>1000000]$0.00,,\\M;$0,\\K", unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
+ type: linear}]
+ label_value_format: "[>1000000000]$0.00,,,\\B;[>1000000]$0.00,,\\M;$0.00,\\K"
+ series_types: {}
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ hidden_fields: []
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ row: 12
+ col: 0
+ width: 24
+ height: 6
+ - title: Monthly Sales Revenue Trends (w/ YoY)
+ name: Monthly Sales Revenue Trends (w/ YoY)
+ model: hdeist-test-model
+ explore: revenue
+ type: looker_line
+ fields: [revenue.comparison_usage_month, revenue.comparison_period, revenue.revenue_toggle]
+ pivots: [revenue.comparison_period]
+ fill_fields: [revenue.comparison_usage_month]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.usage_month: 25 months
+ revenue.comparison_type: YEAR
+ revenue.comparison_date_range: 12 months
+ revenue.comparison_period: Current Period,Prior Period
+ revenue.service_family: CLOUD
+ sorts: [revenue.comparison_period, revenue.comparison_usage_month]
+ limit: 500
+ dynamic_fields: [{category: table_calculation, expression: 'NOT is_null(pivot_where(${revenue.comparison_period}="Current
+ Period", ${revenue.revenue_toggle}))', label: 'Show?', value_format: !!null '',
+ value_format_name: !!null '', _kind_hint: supermeasure, table_calculation: show,
+ _type_hint: yesno}]
+ query_timezone: America/Los_Angeles
+ 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: false
+ 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: true
+ legend_position: center
+ point_style: circle_outline
+ show_value_labels: true
+ label_density: 25
+ x_axis_scale: time
+ y_axis_combined: true
+ show_null_points: false
+ interpolation: linear
+ y_axes: [{label: Monthly Revenue, orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ id: Current Period - revenue.revenue_net_cn, name: This Year}, {axisId: revenue.revenue_net_cn,
+ id: Prior Period - revenue.revenue_net_cn, name: Prior Year}], showLabels: true,
+ showValues: true, valueFormat: "[>1000000000]$0.0,,,\\B;[>1000000]$0.0,,\\\
+ M;$0,\\K", unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
+ type: linear}]
+ limit_displayed_rows_values:
+ show_hide: show
+ first_last: first
+ num_rows: '13'
+ label_value_format: "[>1000000000]$0.00,,,\\B;[>1000000]$0.00,,\\M;$0.00,\\K"
+ series_types: {}
+ series_labels:
+ Current Period - revenue.revenue_net_cn: This Year
+ Prior Period - revenue.revenue_net_cn: Prior Year
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ hidden_fields: []
+ hidden_points_if_no: [show]
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ row: 24
+ col: 0
+ width: 24
+ height: 7
+ - title: YTD
+ name: YTD
+ model: hdeist-test-model
+ explore: revenue
+ type: single_value
+ fields: [revenue.year_to_date, revenue.revenue_toggle]
+ filters:
+ revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ revenue.usage_year: 2 years
+ revenue.year_to_date: "-NULL"
+ revenue.metric_selector: blended
+ sorts: [revenue.year_to_date desc]
+ limit: 500
+ dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
+ label: YoY %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ table_calculation: yoy, _type_hint: number}]
+ query_timezone: America/Los_Angeles
+ custom_color_enabled: true
+ show_single_value_title: true
+ show_comparison: true
+ 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
+ x_axis_gridlines: false
+ y_axis_gridlines: true
+ show_view_names: false
+ y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
+ showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
+ tickDensityCustom: 5, 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: normal
+ limit_displayed_rows: false
+ legend_position: center
+ series_types: {}
+ point_style: none
+ show_value_labels: true
+ label_density: 25
+ x_axis_scale: auto
+ y_axis_combined: true
+ show_null_points: true
+ interpolation: linear
+ ordering: none
+ show_null_labels: false
+ show_totals_labels: false
+ show_silhouette: false
+ totals_color: "#808080"
+ defaults_version: 1
+ hidden_fields: []
+ note_state: collapsed
+ note_display: hover
+ note_text: Based on Sales Revenue
+ listen:
+ SFDC Account ID: revenue.sfdc_account_id
+ Product Group: revenue.product_group
+ GCP Revenue Source: revenue.gcp_revenue_source
+ Billing Account ID: revenue.billing_account_id
+ Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ Region: revenue.region
+ EMEA Geocluster: revenue.geocluster
+ NORTHAM Sector: revenue.sector
+ Sub Region: revenue.sub_region
+ Micro Region: revenue.micro_region
+ NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ row: 7
+ col: 3
+ width: 7
+ height: 3
+ # - title: MTD
+ # name: MTD
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: single_value
+ # fields: [revenue.month_to_date, revenue.revenue_toggle]
+ # filters:
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.month_to_date: "-NULL"
+ # revenue.usage_month: 3 months
+ # revenue.metric_selector: blended
+ # sorts: [revenue.month_to_date desc]
+ # limit: 500
+ # dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
+ # label: MoM %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ # table_calculation: mom, _type_hint: number}]
+ # query_timezone: America/Los_Angeles
+ # custom_color_enabled: true
+ # show_single_value_title: true
+ # show_comparison: true
+ # 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
+ # x_axis_gridlines: false
+ # y_axis_gridlines: true
+ # show_view_names: false
+ # y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ # id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
+ # showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
+ # tickDensityCustom: 5, 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: normal
+ # limit_displayed_rows: false
+ # legend_position: center
+ # series_types: {}
+ # point_style: none
+ # show_value_labels: true
+ # label_density: 25
+ # x_axis_scale: auto
+ # y_axis_combined: true
+ # show_null_points: true
+ # interpolation: linear
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: false
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # defaults_version: 1
+ # hidden_fields: []
+ # note_state: collapsed
+ # note_display: hover
+ # note_text: Based on Sales Revenue
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 7
+ # col: 17
+ # width: 7
+ # height: 3
+ # - title: QTD
+ # name: QTD
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: single_value
+ # fields: [revenue.quarter_to_date, revenue.revenue_toggle]
+ # filters:
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.usage_month: 3 quarters
+ # revenue.quarter_to_date: "-NULL"
+ # revenue.metric_selector: blended
+ # sorts: [revenue.quarter_to_date desc]
+ # limit: 500
+ # dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
+ # label: QoQ %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ # table_calculation: qoq, _type_hint: number}]
+ # query_timezone: America/Los_Angeles
+ # custom_color_enabled: true
+ # show_single_value_title: true
+ # show_comparison: true
+ # 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
+ # x_axis_gridlines: false
+ # y_axis_gridlines: true
+ # show_view_names: false
+ # y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ # id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
+ # showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
+ # tickDensityCustom: 5, 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: normal
+ # limit_displayed_rows: false
+ # legend_position: center
+ # series_types: {}
+ # point_style: none
+ # show_value_labels: true
+ # label_density: 25
+ # x_axis_scale: auto
+ # y_axis_combined: true
+ # show_null_points: true
+ # interpolation: linear
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: false
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # defaults_version: 1
+ # hidden_fields: []
+ # note_state: collapsed
+ # note_display: hover
+ # note_text: Based on Sales Revenue
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 7
+ # col: 10
+ # width: 7
+ # height: 3
+ # - title: Navigation
+ # name: Navigation
+ # model: cloud_sales_bi
+ # explore: pommelhorse_links
+ # type: looker_grid
+ # fields: [pommelhorse_links.link_name]
+ # filters:
+ # pommelhorse_links.category: Revenue Detail
+ # pommelhorse_links.link_size: 1em
+ # sorts: [pommelhorse_links.link_name]
+ # limit: 500
+ # column_limit: 50
+ # query_timezone: America/Los_Angeles
+ # show_view_names: false
+ # show_row_numbers: false
+ # 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: false
+ # header_text_alignment: left
+ # header_font_size: '18'
+ # rows_font_size: '18'
+ # conditional_formatting_include_totals: false
+ # conditional_formatting_include_nulls: false
+ # show_sql_query_menu_options: false
+ # show_totals: true
+ # show_row_totals: true
+ # series_labels:
+ # pommelhorse_links.link_name: Navigation
+ # 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
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: false
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # defaults_version: 1
+ # series_types: {}
+ # hidden_fields: []
+ # y_axes: []
+ # title_hidden: true
+ # listen:
+ # SFDC Account ID: pommelhorse_links.account_id
+ # Sub-Account Name: pommelhorse_links.account_name
+ # Region: pommelhorse_links.region
+ # EMEA Geocluster: pommelhorse_links.geocluster
+ # NORTHAM Sector: pommelhorse_links.sector
+ # Sub Region: pommelhorse_links.sub_region
+ # Micro Region: pommelhorse_links.micro_region
+ # NAL Cluster: pommelhorse_links.nal_cluster
+ # NAL Subcluster: pommelhorse_links.nal_sub_cluster
+ # NAL Name: pommelhorse_links.nal_name
+ # Reporting Account Name: pommelhorse_links.reporting_account_name
+ # row: 0
+ # col: 0
+ # width: 3
+ # height: 12
+ # - title: 'Revenue Walk: List --> Gross'
+ # name: 'Revenue Walk: List --> Gross'
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: looker_waterfall
+ # fields: [revenue.revenue_list, revenue.revenue_gross]
+ # filters:
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.usage_year: 1 years
+ # revenue.service_family: CLOUD
+ # limit: 500
+ # dynamic_fields: [{category: table_calculation, expression: "-1 * (${revenue.revenue_list}-${revenue.revenue_gross})",
+ # label: 'Negotiated Discounts, Fraud & BMODs', value_format: "[>1000000000]$0.00,,,\\\
+ # B;[>1000000]$0.00,,\\M;$0.00,\\K", value_format_name: !!null '', _kind_hint: measure,
+ # table_calculation: negotiated_discounts_fraud_bmods, _type_hint: number},
+ # {category: measure, expression: !!null '', label: Revenue (Gross), value_format: !!null '',
+ # value_format_name: !!null '', based_on: revenue.revenue_gross, _kind_hint: measure,
+ # measure: revenue_gross, type: sum, _type_hint: number}, {category: table_calculation,
+ # expression: "${revenue.revenue_gross}", label: Revenue (Gross), value_format: "[>1000000000]$0.00,,,\\\
+ # B;[>1000000]$0.00,,\\M;$0.00,\\K", value_format_name: !!null '', _kind_hint: measure,
+ # table_calculation: revenue_gross_1, _type_hint: number, is_disabled: true}]
+ # filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
+ # up_color: "#4285F4"
+ # down_color: "#EA4335"
+ # total_color: "#FBBC04"
+ # show_value_labels: true
+ # show_x_axis_ticks: true
+ # show_x_axis_label: true
+ # x_axis_scale: auto
+ # show_y_axis_labels: false
+ # show_y_axis_ticks: true
+ # y_axis_gridlines: true
+ # label_color: ["#000"]
+ # x_axis_gridlines: false
+ # show_view_names: false
+ # y_axis_tick_density: default
+ # y_axis_tick_density_custom: 5
+ # 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
+ # label_density: 25
+ # 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: [revenue.revenue_gross]
+ # y_axes: []
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 33
+ # col: 0
+ # width: 6
+ # height: 16
+ # - name: ''
+ # type: text
+ # title_text: ''
+ # subtitle_text: ''
+ # body_text: |-
+ # <div id="discounts" style="text-align:center;font-size:1.5em">Revenue Walk</div>
+ # <div style="text-align:center;font-size:1em">For more information, visit <a href="http://go/revenue-walk">go/revenue-walk</a></div>
+ # row: 31
+ # col: 0
+ # width: 24
+ # height: 2
+ # - title: Top Gainers
+ # name: Top Gainers
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: looker_grid
+ # fields: [revenue.rolling_window_prior_window, revenue.rolling_window_current_window,
+ # revenue.rolling_window_window_variance, revenue.reporting_account_name]
+ # filters:
+ # revenue.usage_date: 70 days
+ # revenue.rolling_window: "-NULL"
+ # revenue.window_size: '28'
+ # revenue.rolling_window_current_window: ">=0"
+ # revenue.rolling_window_prior_window: ">=0"
+ # revenue.rolling_window_window_variance: ">0"
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.service_family: CLOUD
+ # sorts: [revenue.rolling_window_window_variance desc]
+ # limit: 50
+ # column_limit: 50
+ # dynamic_fields: [{category: table_calculation, expression: "${revenue.rolling_window_window_variance}/${revenue.rolling_window_prior_window}",
+ # label: MoM List, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ # table_calculation: mom_list, _type_hint: number}]
+ # query_timezone: America/Los_Angeles
+ # show_view_names: false
+ # show_row_numbers: false
+ # 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
+ # show_sql_query_menu_options: false
+ # column_order: [revenue.reporting_account_name, revenue.rolling_window_current_window,
+ # revenue.rolling_window_prior_window, revenue.rolling_window_window_variance,
+ # mom]
+ # show_totals: true
+ # show_row_totals: true
+ # series_labels:
+ # revenue.rolling_window_prior_window: 28 Days Before That
+ # revenue.rolling_window_current_window: 28 Days Ago
+ # revenue.rolling_window_window_variance: Sales Revenue Growth $
+ # mom: Sales Revenue Growth %
+ # mom_list: Sales Revenue Growth %
+ # series_column_widths:
+ # revenue.rolling_window: 282
+ # account_meta.customer_name: 298
+ # series_cell_visualizations:
+ # revenue.revenue_net_cn:
+ # is_active: true
+ # palette:
+ # palette_id: 3de02744-c6d0-ba29-2378-81b0f7919624
+ # collection_id: google
+ # custom_colors:
+ # - "#4285F4"
+ # - "#185ABC"
+ # limit_displayed_rows_values:
+ # show_hide: show
+ # first_last: first
+ # num_rows: '2'
+ # header_font_color: "#5F6368"
+ # conditional_formatting: [{type: greater than, value: 0, background_color: '',
+ # font_color: "#137333", color_application: {collection_id: google, palette_id: google-sequential-0},
+ # bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance]},
+ # {type: less than, value: 0, background_color: '', font_color: "#B31412", color_application: {
+ # collection_id: google, palette_id: google-sequential-0}, bold: false, italic: false,
+ # strikethrough: false, fields: [revenue.rolling_window_window_variance]}]
+ # 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
+ # series_types: {}
+ # hidden_fields: [current_month_to_date]
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: false
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # hidden_points_if_no: []
+ # y_axes: []
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 63
+ # col: 0
+ # width: 12
+ # height: 6
+ # - title: Top Decliners
+ # name: Top Decliners
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: looker_grid
+ # fields: [revenue.rolling_window_prior_window, revenue.rolling_window_current_window,
+ # revenue.rolling_window_window_variance, revenue.reporting_account_name]
+ # filters:
+ # revenue.usage_date: 70 days
+ # revenue.rolling_window: "-NULL"
+ # revenue.window_size: '28'
+ # revenue.rolling_window_current_window: ">=0"
+ # revenue.rolling_window_prior_window: ">=0"
+ # revenue.rolling_window_window_variance: "<=0"
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.service_family: CLOUD
+ # sorts: [revenue.rolling_window_window_variance]
+ # limit: 50
+ # column_limit: 50
+ # dynamic_fields: [{table_calculation: mom, label: MoM, expression: "${revenue.rolling_window_window_variance}/${revenue.rolling_window_prior_window}",
+ # value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ # _type_hint: number}]
+ # query_timezone: America/Los_Angeles
+ # show_view_names: false
+ # show_row_numbers: false
+ # 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
+ # show_sql_query_menu_options: false
+ # column_order: [revenue.reporting_account_name, revenue.rolling_window_current_window,
+ # revenue.rolling_window_prior_window, revenue.rolling_window_window_variance,
+ # mom]
+ # show_totals: true
+ # show_row_totals: true
+ # series_labels:
+ # revenue.rolling_window_prior_window: 28 Days Before That
+ # revenue.rolling_window_current_window: 28 Days Ago
+ # revenue.rolling_window_window_variance: Sales Revenue Growth $
+ # mom: Sales Revenue Growth %
+ # series_column_widths:
+ # revenue.rolling_window: 282
+ # account_meta.customer_name: 298
+ # series_cell_visualizations:
+ # revenue.revenue_net_cn:
+ # is_active: true
+ # palette:
+ # palette_id: 3de02744-c6d0-ba29-2378-81b0f7919624
+ # collection_id: google
+ # custom_colors:
+ # - "#4285F4"
+ # - "#185ABC"
+ # limit_displayed_rows_values:
+ # show_hide: show
+ # first_last: first
+ # num_rows: '2'
+ # header_font_color: "#5F6368"
+ # conditional_formatting: [{type: greater than, value: 0, background_color: '',
+ # font_color: "#137333", color_application: {collection_id: google, palette_id: google-sequential-0},
+ # bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance,
+ # mom]}, {type: less than, value: 0, background_color: '', font_color: "#B31412",
+ # color_application: {collection_id: google, palette_id: google-sequential-0},
+ # bold: false, italic: false, strikethrough: false, fields: [revenue.rolling_window_window_variance,
+ # mom]}]
+ # 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
+ # series_types: {}
+ # hidden_fields: [current_month_to_date]
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: false
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # hidden_points_if_no: []
+ # y_axes: []
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 63
+ # col: 12
+ # width: 12
+ # height: 6
+ # - name: " (2)"
+ # type: text
+ # title_text: ''
+ # subtitle_text: ''
+ # body_text: <div style="text-align:center;font-size:1.5em"><a href="#growth"><img
+ # src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/sort/default/24px.svg">Growth</a></div>
+ # row: 10
+ # col: 13
+ # width: 5
+ # height: 2
+ # - name: " (3)"
+ # type: text
+ # title_text: ''
+ # subtitle_text: ''
+ # body_text: <div id="growth" style="text-align:center;font-size:1.5em">Growth (28
+ # days vs. Prior 28 Days)</div>
+ # row: 61
+ # col: 0
+ # width: 24
+ # height: 2
+ # - name: " (4)"
+ # type: text
+ # title_text: ''
+ # subtitle_text: ''
+ # body_text: <div style="text-align:center;font-size:1.5em"><a href="#discounts"><img
+ # src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/local_offer/default/24px.svg">Revenue
+ # Walk</a></div>
+ # row: 10
+ # col: 8
+ # width: 5
+ # height: 2
+ # - title: Weekly Sales Revenue Trends
+ # name: Weekly Sales Revenue Trends
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: looker_line
+ # fields: [revenue.usage_week, revenue.revenue_toggle]
+ # fill_fields: [revenue.usage_week]
+ # filters:
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.usage_week: 52 weeks ago for 52 weeks
+ # revenue.service_family: CLOUD
+ # sorts: [revenue.usage_week desc]
+ # limit: 500
+ # query_timezone: America/Los_Angeles
+ # 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: false
+ # 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: true
+ # label_density: 25
+ # x_axis_scale: auto
+ # y_axis_combined: true
+ # show_null_points: true
+ # interpolation: linear
+ # y_axes: [{label: Weekly Revenue, orientation: left, series: [{axisId: revenue.revenue_toggle,
+ # id: revenue.revenue_toggle, name: Revenue (Toggle-able)}], showLabels: true,
+ # showValues: true, valueFormat: "[>1000000000]$0.00,,,\\B;[>1000000]$0.00,,\\\
+ # M;$0,\\K", unpinAxis: true, tickDensity: default, tickDensityCustom: 5,
+ # type: linear}]
+ # label_value_format: "[>1000000000]$0.00,,,\\B;[>1000000]$0.00,,\\M;$0.00,\\K"
+ # series_types: {}
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: false
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # defaults_version: 1
+ # hidden_fields: []
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 18
+ # col: 0
+ # width: 24
+ # height: 6
+ # - name: " (5)"
+ # type: text
+ # title_text: ''
+ # subtitle_text: ''
+ # body_text: |-
+ # <div style="height:2em;font-size:1.5em;text-align:center"><a href="http://go/bhi-bug" target="_blank"><img src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/bug_report/default/24px.svg
+ # ">File a Bug</a></div>
+ # row: 10
+ # col: 3
+ # width: 5
+ # height: 2
+ # - name: " (6)"
+ # type: text
+ # title_text: ''
+ # subtitle_text: ''
+ # body_text: |-
+ # <div style="text-align:center;font-size:1.2em">
+ # Missing the old <a href="https://data.corp.google.com/sites/q1yjy0md0d87/insights__trends/">Account360</a>?
+ # </div>
+ # row: 10
+ # col: 18
+ # width: 6
+ # height: 2
+ # - title: 'Revenue Walk: Gross --> Invoice'
+ # name: 'Revenue Walk: Gross --> Invoice'
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: looker_waterfall
+ # fields: [revenue.revenue_invoice, revenue.invoice_revenue_components_gross, revenue.invoice_revenue_components_ft,
+ # revenue.invoice_revenue_components_sud, revenue.invoice_revenue_components_cud,
+ # revenue.invoice_revenue_components_promo, revenue.invoice_revenue_components_reseller_credit,
+ # revenue.invoice_revenue_components_cross_pa_credits_addback]
+ # filters:
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.usage_year: 1 years
+ # revenue.service_family: CLOUD
+ # limit: 500
+ # dynamic_fields: [{category: table_calculation, expression: "-1 * (${revenue.revenue_gross}+(\n\
+ # \ ${revenue.revenue_promo}+${revenue.revenue_ft}+${revenue.revenue_ft}+${revenue.revenue_reseller}+${revenue.revenue_cud}+${revenue.revenue_sud}+${revenue.revenue_cross_pa_credits}\n\
+ # ) - ${revenue.revenue_invoice})", label: Discounts (Other), value_format: "$0.00,,\\\
+ # M", value_format_name: !!null '', _kind_hint: measure, table_calculation: discounts_other,
+ # _type_hint: number, is_disabled: true}]
+ # filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
+ # up_color: "#4285F4"
+ # down_color: "#EA4335"
+ # total_color: "#FBBC04"
+ # show_value_labels: true
+ # show_x_axis_ticks: true
+ # show_x_axis_label: true
+ # x_axis_scale: auto
+ # show_y_axis_labels: false
+ # show_y_axis_ticks: true
+ # y_axis_gridlines: true
+ # label_color: ["#000"]
+ # x_axis_gridlines: false
+ # show_view_names: false
+ # y_axis_tick_density: default
+ # y_axis_tick_density_custom: 5
+ # 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
+ # label_density: 25
+ # 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: [revenue.revenue_invoice]
+ # y_axes: []
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 33
+ # col: 6
+ # width: 18
+ # height: 8
+ # - title: 'Revenue Walk: Gross --> Sales'
+ # name: 'Revenue Walk: Gross --> Sales'
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: looker_waterfall
+ # fields: [revenue.revenue_net_cn, revenue.sales_revenue_components_gross, revenue.sales_revenue_components_ft,
+ # revenue.sales_revenue_components_sud, revenue.sales_revenue_components_cud,
+ # revenue.sales_revenue_components_promo, revenue.sales_revenue_components_reseller_credit,
+ # revenue.sales_revenue_components_cross_pa_credits_addback, revenue.sales_revenue_components_isv_deduction,
+ # revenue.sales_revenue_components_partner_margin_addback]
+ # filters:
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.usage_year: 1 years
+ # revenue.service_family: CLOUD
+ # limit: 500
+ # dynamic_fields: [{category: measure, expression: !!null '', label: Revenue (Gross),
+ # value_format: !!null '', value_format_name: !!null '', based_on: revenue.revenue_gross,
+ # _kind_hint: measure, measure: revenue_gross, type: sum, _type_hint: number},
+ # {category: measure, expression: '${revenue.segment}="Corporate" OR ${revenue.region}="PUBLIC
+ # SECTOR"', label: Corp & GPS Partner Margin, value_format: !!null '', value_format_name: !!null '',
+ # based_on: revenue.revenue_reseller, filter_expression: '${revenue.segment}="Corporate"
+ # OR ${revenue.region}="PUBLIC SECTOR"', _kind_hint: measure, measure: corp_gps_partner_margin,
+ # type: sum, _type_hint: number, filters: {}}]
+ # filter_expression: "${revenue.usage_date} <= ${max_date.max_date_minus_2_date}"
+ # up_color: "#4285F4"
+ # down_color: "#EA4335"
+ # total_color: "#FBBC04"
+ # show_value_labels: true
+ # show_x_axis_ticks: true
+ # show_x_axis_label: true
+ # x_axis_scale: auto
+ # show_y_axis_labels: false
+ # show_y_axis_ticks: true
+ # y_axis_gridlines: true
+ # label_color: ["#000"]
+ # x_axis_gridlines: false
+ # show_view_names: false
+ # y_axis_tick_density: default
+ # y_axis_tick_density_custom: 5
+ # 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
+ # label_density: 25
+ # 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: [revenue.revenue_net_cn]
+ # y_axes: []
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 41
+ # col: 6
+ # width: 18
+ # height: 8
+ # - title: List, Gross & Sales Revenue Comparison (Weekly)
+ # name: List, Gross & Sales Revenue Comparison (Weekly)
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: looker_line
+ # fields: [revenue.revenue_net_cn, revenue.revenue_list, revenue.usage_week, revenue.revenue_gross,
+ # revenue.revenue_cud, revenue.revenue_promo, revenue.revenue_bmod]
+ # filters:
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.service_family: CLOUD
+ # revenue.usage_month: 12 months
+ # sorts: [revenue.usage_week desc]
+ # limit: 500
+ # x_axis_gridlines: false
+ # y_axis_gridlines: true
+ # show_view_names: false
+ # show_y_axis_labels: false
+ # show_y_axis_ticks: true
+ # y_axis_tick_density: default
+ # y_axis_tick_density_custom: 5
+ # show_x_axis_label: false
+ # 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: true
+ # label_density: 25
+ # x_axis_scale: auto
+ # y_axis_combined: true
+ # show_null_points: true
+ # interpolation: linear
+ # y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ # id: revenue.revenue_net_cn, name: Revenue (Sales)}, {axisId: revenue.revenue_list,
+ # id: revenue.revenue_list, name: "[go/listrev] Revenue (List)"}, {axisId: revenue.revenue_gross,
+ # id: revenue.revenue_gross, name: Revenue (Gross)}, {axisId: revenue.revenue_cud,
+ # id: revenue.revenue_cud, name: Revenue (Committed Usage Discount)}, {
+ # axisId: revenue.revenue_promo, id: revenue.revenue_promo, name: Revenue
+ # (Promo)}, {axisId: revenue.revenue_bmod, id: revenue.revenue_bmod, name: Revenue
+ # (Billing Modifications)}], showLabels: false, showValues: true, minValue: !!null '',
+ # valueFormat: "[>=1000000000]$0.0,,,\\B;[>1000000]$0.0,,\\M;$0.0,\\K", unpinAxis: true,
+ # tickDensity: default, tickDensityCustom: 5, type: linear}]
+ # hidden_series: []
+ # label_value_format: "[>1000000000]$0.00,,,\\B;[>1000000]$0.0,,\\M;$0.0,\\K"
+ # series_types: {}
+ # label_color: []
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: true
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # up_color: "#4285F4"
+ # down_color: "#EA4335"
+ # total_color: "#FBBC04"
+ # defaults_version: 1
+ # hidden_fields: []
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 49
+ # col: 0
+ # width: 24
+ # height: 12
+ # - title: Most Recent Revenue Data
+ # name: Most Recent Revenue Data
+ # model: cloud_sales_bi
+ # explore: revenue
+ # type: single_value
+ # fields: [revenue.usage_date, revenue.revenue_net_cn]
+ # fill_fields: [revenue.usage_date]
+ # filters:
+ # revenue.product_line: "-Looker,-Looker Data Platform SaaS"
+ # revenue.service_family: CLOUD
+ # revenue.usage_date: 30 days
+ # sorts: [revenue.usage_date desc]
+ # limit: 500
+ # dynamic_fields: [{category: table_calculation, expression: "(${revenue.revenue_toggle}-offset(${revenue.revenue_toggle},1))/offset(${revenue.revenue_toggle},1)",
+ # label: YoY %, value_format: !!null '', value_format_name: percent_0, _kind_hint: measure,
+ # table_calculation: yoy, _type_hint: number, is_disabled: true}, {category: table_calculation,
+ # expression: "${revenue.revenue_net_cn} > 0.5 * median(${revenue.revenue_net_cn})",
+ # label: 'Is valid row?', value_format: "$0.00,\\K", value_format_name: !!null '',
+ # _kind_hint: measure, table_calculation: is_valid_row, _type_hint: yesno}]
+ # query_timezone: America/Los_Angeles
+ # custom_color_enabled: true
+ # 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
+ # x_axis_gridlines: false
+ # y_axis_gridlines: true
+ # show_view_names: false
+ # y_axes: [{label: '', orientation: left, series: [{axisId: revenue.revenue_net_cn,
+ # id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}],
+ # showLabels: true, showValues: true, unpinAxis: true, tickDensity: default,
+ # tickDensityCustom: 5, 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: normal
+ # limit_displayed_rows: false
+ # legend_position: center
+ # series_types: {}
+ # point_style: none
+ # show_value_labels: true
+ # label_density: 25
+ # x_axis_scale: auto
+ # y_axis_combined: true
+ # show_null_points: true
+ # interpolation: linear
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: false
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # defaults_version: 1
+ # hidden_fields: [revenue.revenue_net_cn]
+ # hidden_points_if_no: [is_valid_row]
+ # note_state: collapsed
+ # note_display: hover
+ # note_text: Most recent date with complete revenue numbers
+ # listen:
+ # SFDC Account ID: revenue.sfdc_account_id
+ # Product Group: revenue.product_group
+ # GCP Revenue Source: revenue.gcp_revenue_source
+ # Billing Account ID: revenue.billing_account_id
+ # Logical Product (L3): revenue.logical_product_l3
+ # SKU ID: revenue.sku_id
+ # Sub-Account Name: vector_customers.account_name
+ # Is Data Analytics? (Yes / No): revenue.is_data_analytics
+ # Revenue Granularity: revenue.revenue_granularity
+ # Region: revenue.region
+ # EMEA Geocluster: revenue.geocluster
+ # NORTHAM Sector: revenue.sector
+ # Sub Region: revenue.sub_region
+ # Micro Region: revenue.micro_region
+ # NAL Cluster: revenue.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: revenue.nal_name
+ # Reporting Account Name: revenue.reporting_account_name
+ # Segment: revenue.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 4
+ # col: 3
+ # width: 7
+ # height: 3
+ # - title: QTD (GCP Core + Looker + Apigee)
+ # name: QTD (GCP Core + Looker + Apigee)
+ # model: cloud_sales_bi
+ # explore: gcp_forecast_quotas_transformed
+ # type: single_value
+ # fields: [gcp_forecast_quotas_transformed.revenue_net_cn]
+ # filters:
+ # gcp_forecast_quotas_transformed.calendar_quarter: this quarter
+ # limit: 500
+ # column_limit: 50
+ # 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: true
+ # conditional_formatting_include_totals: false
+ # conditional_formatting_include_nulls: false
+ # show_view_names: false
+ # show_row_numbers: false
+ # transpose: false
+ # truncate_text: false
+ # hide_totals: false
+ # hide_row_totals: false
+ # size_to_fit: true
+ # table_theme: white
+ # limit_displayed_rows: false
+ # header_text_alignment: center
+ # header_font_size: '12'
+ # rows_font_size: '17'
+ # show_sql_query_menu_options: false
+ # column_order: [gcp_forecast_quotas_transformed.quota_revenue, gcp_forecast_quotas_transformed.revenue_net_cn,
+ # gcp_forecast_quotas_transformed.total_called_revenue_forecast, gcp_forecast_quotas_transformed.total_called_revenue_forecast_wow,
+ # gcp_forecast_quotas_transformed.forecast_vs_quota_called_revenue, gcp_forecast_quotas_transformed.total_modeled_revenue_forecast,
+ # gcp_forecast_quotas_transformed.total_modeled_revenue_forecast_wow, gcp_forecast_quotas_transformed.bi_forecast_vs_called_forecast_revenue]
+ # show_totals: true
+ # show_row_totals: true
+ # series_labels:
+ # gcp_forecast_quotas_transformed.forecast_vs_quota_called_revenue: Called Forecast
+ # vs. Quota
+ # revenue.revenue_net_cn: Sales Revenue Actuals
+ # gcp_forecast_quotas_transformed.quota_revenue: Quota
+ # gcp_forecast_quotas_transformed.total_called_revenue_forecast: Called Forecast
+ # gcp_account_forecast_nal_rollup.total_modeled_revenue_forecast: BI Forecast
+ # gcp_forecast_quotas_transformed.bi_forecast_vs_called_forecast_revenue: Override
+ # gcp_account_forecast_nal_rollup.total_modeled_revenue_forecast_wow: BI Forecast
+ # WoW
+ # gcp_forecast_quotas_transformed.total_called_revenue_forecast_wow: Called Forecast
+ # WoW
+ # gcp_forecast_quotas_transformed.total_modeled_revenue_forecast: BI Forecast
+ # gcp_forecast_quotas_transformed.total_modeled_revenue_forecast_wow: BI Forecast
+ # WoW
+ # gcp_forecast_quotas_transformed.revenue_net_cn: Actuals
+ # series_cell_visualizations:
+ # revenue.revenue_net_cn:
+ # is_active: false
+ # series_text_format:
+ # gcp_forecast_quotas_transformed.total_called_revenue_forecast:
+ # align: center
+ # gcp_forecast_quotas_transformed.forecast_vs_quota_called_revenue:
+ # align: center
+ # gcp_account_forecast_nal_rollup.total_modeled_revenue_forecast:
+ # align: center
+ # gcp_forecast_quotas_transformed.bi_forecast_vs_called_forecast_revenue:
+ # align: center
+ # called_forecast_wow:
+ # align: center
+ # bi_forecast_wow:
+ # align: center
+ # gcp_forecast_quotas_transformed.quota_revenue:
+ # align: center
+ # revenue.revenue_net_cn:
+ # align: center
+ # header_font_color: "#E8EAED"
+ # header_background_color: "#4285F4"
+ # conditional_formatting: [{type: less than, value: 0, background_color: '', font_color: "#EA4335",
+ # color_application: {collection_id: google, palette_id: google-diverging-0,
+ # options: {constraints: {min: {type: minimum}, mid: {type: number, value: 0},
+ # max: {type: maximum}}, mirror: true, reverse: false, stepped: false}},
+ # bold: false, italic: false, strikethrough: false, fields: []}, {type: greater
+ # than, value: 0, background_color: '', font_color: "#34A853", color_application: {
+ # collection_id: google, palette_id: google-diverging-0, options: {constraints: {
+ # min: {type: minimum}, mid: {type: number, value: 0}, max: {type: maximum}},
+ # mirror: true, reverse: false, stepped: false}}, bold: false, italic: false,
+ # strikethrough: false, fields: []}]
+ # 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: circle_outline
+ # show_value_labels: true
+ # label_density: 25
+ # x_axis_scale: auto
+ # y_axis_combined: true
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: true
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # y_axes: [{label: '', orientation: bottom, series: [{axisId: revenue.revenue_net_cn,
+ # id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}, {
+ # axisId: gcp_forecast_quotas_transformed.quota_revenue, id: gcp_forecast_quotas_transformed.quota_revenue,
+ # name: Quota}, {axisId: forecast, id: forecast, name: Forecast}], showLabels: true,
+ # showValues: false, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
+ # type: linear}]
+ # series_types: {}
+ # series_colors:
+ # forecast: "#EA4335"
+ # gcp_forecast_quotas_transformed.quota_revenue: "#FBBC04"
+ # defaults_version: 1
+ # hidden_fields: []
+ # listen:
+ # Region: gcp_forecast_quotas_transformed.region
+ # EMEA Geocluster: gcp_forecast_quotas_transformed.geocluster
+ # NORTHAM Sector: gcp_forecast_quotas_transformed.sector
+ # Sub Region: gcp_forecast_quotas_transformed.sub_region
+ # Micro Region: gcp_forecast_quotas_transformed.micro_region
+ # NAL Cluster: gcp_forecast_quotas_transformed.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: gcp_forecast_quotas_transformed.nal_name
+ # Reporting Account Name: gcp_forecast_quotas_transformed.reporting_account_name
+ # Segment: vector_customers.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 0
+ # col: 10
+ # width: 7
+ # height: 4
+ # - name: " (7)"
+ # type: text
+ # title_text: ''
+ # subtitle_text: ''
+ # body_text: <div style="font-size:2em;text-align:center">All other tiles represent
+ # <b>GCP Core only</b> and do not include Looker or Apigee Revenue.</div>
+ # row: 4
+ # col: 10
+ # width: 14
+ # height: 3
+ # - name: " (8)"
+ # type: text
+ # title_text: ''
+ # subtitle_text: ''
+ # body_text: |-
+ # <div style="font-size:1.5em"><img style="float:left" height=100 src="https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/west/default/24px.svg">
+ # These tiles represent <b>GCP Core + Looker + Apigee</b> and match values on <a href="http://go/bhi">go/bhi</a>.</div>
+ # row: 0
+ # col: 17
+ # width: 7
+ # height: 4
+ # - title: YTD (GCP Core + Looker + Apigee)
+ # name: YTD (GCP Core + Looker + Apigee)
+ # model: cloud_sales_bi
+ # explore: gcp_forecast_quotas_transformed
+ # type: single_value
+ # fields: [gcp_forecast_quotas_transformed.revenue_net_cn]
+ # filters:
+ # gcp_forecast_quotas_transformed.calendar_quarter: this year
+ # limit: 500
+ # column_limit: 50
+ # 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: true
+ # conditional_formatting_include_totals: false
+ # conditional_formatting_include_nulls: false
+ # show_view_names: false
+ # show_row_numbers: false
+ # transpose: false
+ # truncate_text: false
+ # hide_totals: false
+ # hide_row_totals: false
+ # size_to_fit: true
+ # table_theme: white
+ # limit_displayed_rows: false
+ # header_text_alignment: center
+ # header_font_size: '12'
+ # rows_font_size: '17'
+ # show_sql_query_menu_options: false
+ # column_order: [gcp_forecast_quotas_transformed.quota_revenue, gcp_forecast_quotas_transformed.revenue_net_cn,
+ # gcp_forecast_quotas_transformed.total_called_revenue_forecast, gcp_forecast_quotas_transformed.total_called_revenue_forecast_wow,
+ # gcp_forecast_quotas_transformed.forecast_vs_quota_called_revenue, gcp_forecast_quotas_transformed.total_modeled_revenue_forecast,
+ # gcp_forecast_quotas_transformed.total_modeled_revenue_forecast_wow, gcp_forecast_quotas_transformed.bi_forecast_vs_called_forecast_revenue]
+ # show_totals: true
+ # show_row_totals: true
+ # series_labels:
+ # gcp_forecast_quotas_transformed.forecast_vs_quota_called_revenue: Called Forecast
+ # vs. Quota
+ # revenue.revenue_net_cn: Sales Revenue Actuals
+ # gcp_forecast_quotas_transformed.quota_revenue: Quota
+ # gcp_forecast_quotas_transformed.total_called_revenue_forecast: Called Forecast
+ # gcp_account_forecast_nal_rollup.total_modeled_revenue_forecast: BI Forecast
+ # gcp_forecast_quotas_transformed.bi_forecast_vs_called_forecast_revenue: Override
+ # gcp_account_forecast_nal_rollup.total_modeled_revenue_forecast_wow: BI Forecast
+ # WoW
+ # gcp_forecast_quotas_transformed.total_called_revenue_forecast_wow: Called Forecast
+ # WoW
+ # gcp_forecast_quotas_transformed.total_modeled_revenue_forecast: BI Forecast
+ # gcp_forecast_quotas_transformed.total_modeled_revenue_forecast_wow: BI Forecast
+ # WoW
+ # gcp_forecast_quotas_transformed.revenue_net_cn: Actuals
+ # series_cell_visualizations:
+ # revenue.revenue_net_cn:
+ # is_active: false
+ # series_text_format:
+ # gcp_forecast_quotas_transformed.total_called_revenue_forecast:
+ # align: center
+ # gcp_forecast_quotas_transformed.forecast_vs_quota_called_revenue:
+ # align: center
+ # gcp_account_forecast_nal_rollup.total_modeled_revenue_forecast:
+ # align: center
+ # gcp_forecast_quotas_transformed.bi_forecast_vs_called_forecast_revenue:
+ # align: center
+ # called_forecast_wow:
+ # align: center
+ # bi_forecast_wow:
+ # align: center
+ # gcp_forecast_quotas_transformed.quota_revenue:
+ # align: center
+ # revenue.revenue_net_cn:
+ # align: center
+ # header_font_color: "#E8EAED"
+ # header_background_color: "#4285F4"
+ # conditional_formatting: [{type: less than, value: 0, background_color: '', font_color: "#EA4335",
+ # color_application: {collection_id: google, palette_id: google-diverging-0,
+ # options: {constraints: {min: {type: minimum}, mid: {type: number, value: 0},
+ # max: {type: maximum}}, mirror: true, reverse: false, stepped: false}},
+ # bold: false, italic: false, strikethrough: false, fields: []}, {type: greater
+ # than, value: 0, background_color: '', font_color: "#34A853", color_application: {
+ # collection_id: google, palette_id: google-diverging-0, options: {constraints: {
+ # min: {type: minimum}, mid: {type: number, value: 0}, max: {type: maximum}},
+ # mirror: true, reverse: false, stepped: false}}, bold: false, italic: false,
+ # strikethrough: false, fields: []}]
+ # 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: circle_outline
+ # show_value_labels: true
+ # label_density: 25
+ # x_axis_scale: auto
+ # y_axis_combined: true
+ # ordering: none
+ # show_null_labels: false
+ # show_totals_labels: true
+ # show_silhouette: false
+ # totals_color: "#808080"
+ # y_axes: [{label: '', orientation: bottom, series: [{axisId: revenue.revenue_net_cn,
+ # id: revenue.revenue_net_cn, name: 'Revenue (Net, Channel Neutral)'}, {
+ # axisId: gcp_forecast_quotas_transformed.quota_revenue, id: gcp_forecast_quotas_transformed.quota_revenue,
+ # name: Quota}, {axisId: forecast, id: forecast, name: Forecast}], showLabels: true,
+ # showValues: false, unpinAxis: false, tickDensity: default, tickDensityCustom: 5,
+ # type: linear}]
+ # series_types: {}
+ # series_colors:
+ # forecast: "#EA4335"
+ # gcp_forecast_quotas_transformed.quota_revenue: "#FBBC04"
+ # defaults_version: 1
+ # hidden_fields: []
+ # listen:
+ # Region: gcp_forecast_quotas_transformed.region
+ # EMEA Geocluster: gcp_forecast_quotas_transformed.geocluster
+ # NORTHAM Sector: gcp_forecast_quotas_transformed.sector
+ # Sub Region: gcp_forecast_quotas_transformed.sub_region
+ # Micro Region: gcp_forecast_quotas_transformed.micro_region
+ # NAL Cluster: gcp_forecast_quotas_transformed.nal_cluster
+ # NAL Subcluster: vector_customers.nal_sub_cluster
+ # NAL Name: gcp_forecast_quotas_transformed.nal_name
+ # Reporting Account Name: gcp_forecast_quotas_transformed.reporting_account_name
+ # Segment: vector_customers.segment
+ # Digital Native vs. Traditional: vector_customers.is_digital_native
+ # Is ISV? (Yes / No): vector_customers.is_isv
+ # row: 0
+ # col: 3
+ # width: 7
+ # height: 4
+
+
+
+
+
+
+
+
+
+ filters:
+ - name: Region
+ title: Region
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: dropdown_menu
+ display: inline
+ options:
+ - NORTHAM
+ - EMEA
+ - LATAM
+ - APAC
+ - JAPAN
+ - PUBLIC SECTOR
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.region
+ - name: EMEA Geocluster
+ title: EMEA Geocluster
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: dropdown_menu
+ display: inline
+ options:
+ - Industry
+ - North
+ - South
+ - UK/IE
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.geocluster
+ - name: NORTHAM Sector
+ title: NORTHAM Sector
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: dropdown_menu
+ display: inline
+ options:
+ - GEO
+ - VERTICAL
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.sector
+ - name: Sub Region
+ title: Sub Region
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: dropdown_menu
+ display: inline
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: [Region]
+ field: revenue.sub_region
+ - name: Micro Region
+ title: Micro Region
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: dropdown_menu
+ display: inline
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.micro_region
+ - name: NAL Cluster
+ title: NAL Cluster
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: dropdown_menu
+ display: inline
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.nal_cluster
+ # - name: NAL Subcluster
+ # title: NAL Subcluster
+ # type: field_filter
+ # default_value: ''
+ # allow_multiple_values: true
+ # required: false
+ # ui_config:
+ # type: tag_list
+ # display: popover
+ # options: []
+ # model: hdeist-test-model
+ # explore: revenue
+ # listens_to_filters: []
+ # field: vector_customers.nal_sub_cluster
+ - name: NAL Name
+ title: NAL Name
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: advanced
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.nal_name
+ # - name: Reporting Account Name
+ # title: Reporting Account Name
+ # type: field_filter
+ # default_value: ''
+ # allow_multiple_values: true
+ # required: false
+ # ui_config:
+ # type: tag_list
+ # display: popover
+ # options: []
+ # model: hdeist-test-model
+ # explore: vector_customers
+ # listens_to_filters: []
+ # field: vector_customers.reporting_account_name
+ # - name: Sub-Account Name
+ # title: Sub-Account Name
+ # type: field_filter
+ # default_value: ''
+ # allow_multiple_values: true
+ # required: false
+ # ui_config:
+ # type: tag_list
+ # display: popover
+ # options: []
+ # model: cloud_sales_bi
+ # explore: revenue
+ # listens_to_filters: [Reporting Account Name]
+ # field: vector_customers.account_name
+ - name: SFDC Account ID
+ title: SFDC Account ID
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: advanced
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: [Reporting Account Name]
+ field: revenue.sfdc_account_id
+ - name: Billing Account ID
+ title: Billing Account ID
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: advanced
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: [Reporting Account Name]
+ field: revenue.billing_account_id
+ - name: Product Group
+ title: Product Group
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: tag_list
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.product_group
+ - name: Logical Product (L3)
+ title: Logical Product (L3)
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: advanced
+ display: popover
+ options: []
+ model: hdeist-test-model
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.logical_product_l3
+ - name: Is Data Analytics? (Yes / No)
+ title: Is Data Analytics? (Yes / No)
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: checkboxes
+ display: popover
+ options: []
+ model: cloud_sales_bi
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.is_data_analytics
+ - name: GCP Revenue Source
+ title: GCP Revenue Source
+ type: field_filter
+ default_value: ''
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: checkboxes
+ display: popover
+ options: []
+ model: cloud_sales_bi
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.gcp_revenue_source
+ - name: Segment
+ title: Segment
+ type: field_filter
+ default_value: "-Scaled"
+ allow_multiple_values: true
+ required: false
+ ui_config:
+ type: advanced
+ display: popover
+ options:
+ - Corporate
+ - Enterprise
+ - Select
+ model: cloud_sales_bi
+ explore: revenue
+ listens_to_filters: []
+ field: revenue.segment
+ # - name: Digital Native vs. Traditional
+ # title: Digital Native vs. Traditional
+ # type: field_filter
+ # default_value: ''
+ # allow_multiple_values: true
+ # required: false
+ # ui_config:
+ # type: button_group
+ # display: inline
+ # options: []
+ # model: cloud_sales_bi
+ # explore: revenue
+ # listens_to_filters: []
+ # field: vector_customers.is_digital_native
+ # - name: SKU ID
+ # title: SKU ID
+ # type: field_filter
+ # default_value: ''
+ # allow_multiple_values: true
+ # required: false
+ # ui_config:
+ # type: advanced
+ # display: popover
+ # options: []
+ # model: cloud_sales_bi
+ # explore: revenue
+ # listens_to_filters: []
+ # field: revenue.sku_id
+ # - name: Revenue Granularity
+ # title: Revenue Granularity
+ # type: field_filter
+ # default_value: Non-Split
+ # allow_multiple_values: true
+ # required: false
+ # ui_config:
+ # type: dropdown_menu
+ # display: inline
+ # options: []
+ # model: hdeist-test-model
+ # explore: revenue
+ # listens_to_filters: []
+ # field: revenue.revenue_granularity
+ # - name: Is ISV? (Yes / No)
+ # title: Is ISV? (Yes / No)
+ # type: field_filter
+ # default_value: ''
+ # allow_multiple_values: true
+ # required: false
+ # ui_config:
+ # type: advanced
+ # display: inline
+ # options: []
+ # model: cloud_sales_bi
+ # explore: vector_customers
+ # listens_to_filters: []
+ # field: vector_customers.is_isv
diff --git a/test_dashboard.dashboard.lookml b/test_dashboard.dashboard.lookml
index 7afdb2c..644eedd 100644
--- a/test_dashboard.dashboard.lookml
+++ b/test_dashboard.dashboard.lookml
@@ -1,5 +1,5 @@
- dashboard: test_dashboard
- title: Revenue Trends (GCP Core)
+ title: Test Dashboard (revenue trends subset)
layout: newspaper
preferred_viewer: dashboards-next
tile_size: 100
