Add region.view and revenue_granularity
diff --git a/revenue_trends.dashboard.lookml b/revenue_trends.dashboard.lookml index 8db2eef..62132f7 100644 --- a/revenue_trends.dashboard.lookml +++ b/revenue_trends.dashboard.lookml
@@ -1900,7 +1900,7 @@ type: checkboxes display: popover options: [] - model: cloud_sales_bi + model: hdeist-test-model explore: revenue listens_to_filters: [] field: revenue.is_data_analytics @@ -1914,7 +1914,7 @@ type: checkboxes display: popover options: [] - model: cloud_sales_bi + model: hdeist-test-model explore: revenue listens_to_filters: [] field: revenue.gcp_revenue_source @@ -1931,7 +1931,7 @@ - Corporate - Enterprise - Select - model: cloud_sales_bi + model: hdeist-test-model explore: revenue listens_to_filters: [] field: revenue.segment
diff --git a/views/region.view.lkml b/views/region.view.lkml new file mode 100644 index 0000000..0562fd1 --- /dev/null +++ b/views/region.view.lkml
@@ -0,0 +1,190 @@ +view: region { + extension: required + #### DIMENSIONS #### + dimension: geocluster { + view_label: "Account" + group_label: "Region" + label: "EMEA Geocluster" + description: "EMEA grouping between Region and Sub-Region that includes: North, South, UK/IE, and Industry" + type: string + sql: IF(${region} = "EMEA", + CASE + WHEN ${sub_region} IN ('Germany', 'CEE', 'Alps', 'Nordics') + THEN "North" + WHEN ${sub_region} IN ('ISRAEL', 'Italy', 'France', 'MEA', 'Benelux', 'Iberia') + THEN "South" + WHEN ${sub_region} LIKE "UK/IE%" + THEN "UK/IE" + WHEN ${sub_region} IN ('Telco Dir', 'Retail & CPG', 'Banking Dir', 'Life Sciences Dir') + THEN "Industry" + WHEN ${sub_region} IN ('EMEA - PS') + THEN 'Public Sector' + END + , NULL);; + drill_fields: [sub_region, micro_region, nal_cluster, nal_name, nal_id] + suggestions: ["North", "South", "UK/IE", "Industry", "Public Sector"] + } + dimension: micro_region { + view_label: "Account" + group_label: "Region" + description: "e.g. Bay Area, NewEngland, Emerging, Benelux, Italy" + sql: ${TABLE}.micro_region ;; + drill_fields: [nal_cluster, nal_name, nal_id] + suggest_explore: vector_customers_suggestions + suggest_dimension: vector_customers_suggestions.micro_region + } + dimension: nal_cluster { + view_label: "Account" + group_label: "Region" + label: "NAL Cluster" + description: "First level rollup for a group of NALs (e.g. NA Corp Digit.)" + sql: ${TABLE}.nal_cluster ;; + drill_fields: [nal_name, nal_id] + suggest_explore: vector_customers_suggestions + suggest_dimension: vector_customers_suggestions.nal_cluster + } + dimension: nal_id { + view_label: "Account" + label: "NAL ID" + group_label: "Region" + description: "Int64 unique identifier for a NAL" + type: number + sql: ${TABLE}.nal_id ;; + drill_fields: [reporting_account_name] + suggest_explore: vector_customers_suggestions + suggest_dimension: vector_customers_suggestions.nal_id + } + dimension: nal_name { + view_label: "Account" + label: "NAL Name" + group_label: "Region" + description: "Nal name (e.g. DACH PS ENT Gov (ricardonunez))" + sql: ${TABLE}.nal_name ;; + drill_fields: [reporting_account_name] + suggest_explore: vector_customers_suggestions + suggest_dimension: vector_customers_suggestions.nal_name + } + dimension: region { + view_label: "Account" + group_label: "Region" + description: "Sales region (e.g. NORTHAM, EMEA, JAPAN, APAC, LATAM)" + sql: ${TABLE}.region ;; + drill_fields: [geocluster, sector, sub_region, micro_region, nal_cluster, nal_name, nal_id] + order_by_field: region_order + suggest_explore: vector_customers_suggestions + suggest_dimension: vector_customers_suggestions.region + } + dimension: region_order { + hidden: yes + type: number + view_label: "Account" + description: "Account Segment from Vector" + sql: CASE + WHEN ${region} = "NORTHAM" THEN 1 + WHEN ${region} = "EMEA" THEN 2 + WHEN ${region} = "LATAM" THEN 3 + WHEN ${region} = "APAC" THEN 4 + WHEN ${region} = "JAPAN" THEN 5 + WHEN ${region} = "PUBLIC SECTOR" THEN 6 + WHEN ${region} = "EDU FA" THEN 7 + WHEN ${region} = "SCALED" THEN 8 + ELSE 9 + END + ;; + } + dimension: region_toggle { + view_label: "Account" + group_label: "Region" + label: "Region (Toggle-able)" + description: "USE ONLY FOR DASHBOARDING. This is a region dimension that can be toggled with a dashboard filter using the Region Granularity parameter. Choose from Region, Sub-Region, Micro-Region, NAL Cluster, NAL ID, or Reporting Account Name. Default is NAL Name." + label_from_parameter: region_granularity + sql: {% if region_granularity._parameter_value == "region" %} + ${region} + {% elsif region_granularity._parameter_value == "geocluster" %} + ${geocluster} + {% elsif region_granularity._parameter_value == "sector" %} + ${sector} + {% elsif region_granularity._parameter_value == "sub_region" %} + ${sub_region} + {% elsif region_granularity._parameter_value == "micro_region" %} + ${micro_region} + {% elsif region_granularity._parameter_value == "nal_cluster" %} + ${nal_cluster} + {% elsif region_granularity._parameter_value == "nal_name" %} + ${nal_name} + {% elsif region_granularity._parameter_value == "nal_id" %} + ${nal_id} + {% endif %} + ;; + drill_fields: [region, geocluster, sector, sub_region, micro_region, nal_cluster, nal_name, nal_id, commit_curve.leg] + } + dimension: sector { + view_label: "Account" + group_label: "Region" + label: "NORTHAM Sector" + description: "NORTHAM grouping between Region and Sub-Region that includes: GEO and VERTICAL" + type: string + sql: IF(${region} = "NORTHAM", + CASE + WHEN ${sub_region} IN ("Corp", "Central", "US West", "US SouthCentral", "US NorthCentral", "US East", "Canada") + THEN "GEO" + WHEN ${sub_region} IN ("US TMEG", "US Retail", "US HCLS", "US FS") + THEN "VERTICAL" + WHEN ${nal_name} LIKE "AMER Geo%" + THEN "GEO" + WHEN ${nal_name} LIKE "AMER Vertical%" + THEN "VERTICAL" + END + , NULL) ;; + drill_fields: [sub_region, micro_region, nal_cluster, nal_name, nal_id] + suggestions: ["GEO", "VERTICAL"] + } + dimension: sub_region { + view_label: "Account" + group_label: "Region" + description: "Sales sub-region (e.g. US West, North Asia, UK/IE)" + sql: ${TABLE}.sub_region ;; + drill_fields: [micro_region, nal_cluster, nal_name, nal_id] + suggest_explore: vector_customers_suggestions + suggest_dimension: vector_customers_suggestions.sub_region + } + ##### PARAMETERS ##### + parameter: region_granularity { + type: unquoted + view_label: "Account" + description: "A parameter that should be used with the region_toggle dimension to change the granularity at which region is shown. Choose from Region, EMEA Geocluster, NORTHAM Sector, Sub-Region, Micro-Region, NAL Cluster, NAL ID." + default_value: "nal_name" + allowed_value: { + label: "Region" + value: "region" + } + allowed_value: { + label: "EMEA Geocluster" + value: "geocluster" + } + allowed_value: { + label: "NORTHAM Sector" + value: "sector" + } + allowed_value: { + label: "Sub Region" + value: "sub_region" + } + allowed_value: { + label: "Micro Region" + value: "micro_region" + } + allowed_value: { + label: "NAL Cluster" + value: "nal_cluster" + } + allowed_value: { + label: "NAL Name" + value: "nal_name" + } + allowed_value: { + label: "NAL ID" + value: "nal_id" + } + } +}
diff --git a/views/revenue/revenue.view.lkml b/views/revenue/revenue.view.lkml index ccf848d..2c038a3 100644 --- a/views/revenue/revenue.view.lkml +++ b/views/revenue/revenue.view.lkml
@@ -10,4 +10,16 @@ extends: [account_from_revenue, comparisons_from_revenue, revenue_from_revenue, to_date_fields, rolling_window] sql_table_name: `concord-test.stagingservice_gcc.gcc_revenue_partitioned_view`;; + ##### PARAMETERS ##### + parameter: revenue_granularity { + view_label: "Pre- or Post-Split" + description: "Allows the user to toggle between split revenue and non-split revenue. Default value is Split" + allowed_value: { + value: "Split" + } + allowed_value: { + value: "Non-Split" + } + default_value: "Non-Split" + } }