create pommelhorse_links
diff --git a/explores/pommelhorse_links.view.lkml b/explores/pommelhorse_links.view.lkml
new file mode 100644
index 0000000..83a4700
--- /dev/null
+++ b/explores/pommelhorse_links.view.lkml
@@ -0,0 +1,8 @@
+include: "../views/pommelhorse_links.view.lkml"
+# Last Updated: April 16, 2021
+# Created by: hillz@
+# Purpose: This is used to create sidebar menus whose links update based on dashboard filters
+explore: pommelhorse_links {
+ description: "This is used to create sidebar menus whose links update based on dashboard filters."
+ hidden: yes
+}
diff --git a/views/pommelhorse_links.view.lkml b/views/pommelhorse_links.view.lkml
new file mode 100644
index 0000000..be8e2ae
--- /dev/null
+++ b/views/pommelhorse_links.view.lkml
@@ -0,0 +1,398 @@
+
+view: pommelhorse_links {
+ derived_table: {
+ sql:
+ WITH link_list AS (
+ -- Add a link for each dashboard you want to url to with the link_name as you want it to display
+ -- Pommel Horse Links
+ (SELECT "Billing Account Usage" AS link_name, "/dashboards-next/24" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Customer Usage Monthly FY" AS link_name, "/dashboards-next/21" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Account Overview" AS link_name, "/dashboards-next/18" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Customer Usage Quarterly Lookback" AS link_name, "/dashboards-next/22" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Product Usage Daily & Weekly" AS link_name, "/dashboards-next/19" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Product Usage Monthly" AS link_name, "/dashboards-next/20" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "SUD & CUD" AS link_name, "/dashboards-next/23" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Product Usage Daily & Weekly" AS link_name, "/dashboards-next/19" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Top Products Used" AS link_name, "/dashboards-next/26" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Product Usage Daily & Weekly" AS link_name, "/dashboards-next/19" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Week-over-Week (WOW), Month-over-Month (MOM)" AS link_name, "/dashboards-next/25" as url, NULL as icon, "Pommelhorse" AS category, TRUE as add_filter)
+ -- Executive Links
+ UNION ALL
+ (SELECT "Home" as link_name, "/dashboards-next/69" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "Executive" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline Health" as link_name, "/dashboards-next/90" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/sort/v13/24px.svg" as icon, "Executive" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Sales Revenue Forecast" as link_name, "/dashboards-next/91" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/payments/v12/24px.svg" as icon, "Executive" AS category, TRUE as add_filter)
+ -- Main BHI and Module Reporting Links
+ UNION ALL
+ (SELECT "Home" as link_name, "/dashboards-next/83" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "FSM" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Help" as link_name, "http://go/bhi-help" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/info/default/24px.svg" as icon, "FSM" AS category, FALSE as add_filter)
+
+ UNION ALL
+ (SELECT "Pipeline Health" as link_name, "/dashboards-next/136" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/sort/v13/24px.svg" as icon, "FSM" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Sales Revenue Trends" as link_name, "/dashboards-next/82" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/trending_up/v18/24px.svg" as icon, "FSM" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Account Lookup" as link_name, "/dashboards-next/100" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/data_loss_prevention/default/24px.svg" as icon, "FSM Detail" AS category, FALSE as add_filter)
+ UNION ALL
+ (SELECT "Product Trends" as link_name, "/dashboards-next/137" as url, "https://fonts.gstatic.com/s/i/monolineiconsoutlined/wb_cloudy/v2/48px.svg" as icon, "FSM Detail" AS category, TRUE as add_filter)
+ -- BHI Details Links
+ UNION ALL
+ (SELECT "Partner Attach" as link_name, "/dashboards-next/218" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/people/v22/24px.svg" as icon, "FSM Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Partner BHI" as link_name, "/dashboards-next/151" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/trending_up/v18/24px.svg" as icon, "FSM Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "New Logo & Greenfield" as link_name, "/dashboards-next/103" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/fiber_new/v13/24px.svg" as icon, "FSM Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Commit & Consumption" as link_name, "/dashboards-next/116" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/checkbook/default/24px.svg" as icon, "FSM Detail" AS category, TRUE as add_filter)
+ -- Revenue Module Detail Links
+ UNION ALL
+ (SELECT "BHI Home" as link_name, "/dashboards-next/83" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "Revenue Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Help" as link_name, "http://go/bhi-help" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/info/default/24px.svg" as icon, "Revenue Detail" AS category, FALSE as add_filter)
+ UNION ALL
+ (SELECT "Sales Revenue Trends" as link_name, "/dashboards-next/82" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/trending_up/v18/24px.svg" as icon, "Revenue Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pommelhorse Home" AS link_name, "/dashboards-next/260" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/bedroom_baby/default/24px.svg" as icon, "Revenue Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Sales Revenue Forecast" as link_name, "/dashboards-next/60" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/payments/v12/24px.svg" as icon, "Revenue Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Commit & Consumption" as link_name, "/dashboards-next/116" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/checkbook/default/24px.svg" as icon, "Revenue Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Account Types Trends" as link_name, "/dashboards-next/138" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/category/default/24px.svg" as icon, "Revenue Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Product Trends" as link_name, "/dashboards-next/137" as url, "https://fonts.gstatic.com/s/i/monolineiconsoutlined/wb_cloudy/v2/48px.svg" as icon, "Revenue Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Velocity" as link_name, "/dashboards-next/81" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/speed/v12/24px.svg" as icon, "Revenue Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Account Lookup" as link_name, "/dashboards-next/100" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/data_loss_prevention/default/24px.svg" as icon, "Revenue Detail" AS category, FALSE as add_filter)
+ -- Pipeline Module Detail Links
+ UNION ALL
+ (SELECT "BHI Home" as link_name, "/dashboards-next/83" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "Pipeline Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Help" as link_name, "http://go/bhi-help" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/info/default/24px.svg" as icon, "Pipeline Detail" AS category, FALSE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline Health" as link_name, "/dashboards-next/136" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/sort/v13/24px.svg" as icon, "Pipeline Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Bookings Forecast" as link_name, "/dashboards-next/129" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/event_upcoming/default/24px.svg" as icon, "Pipeline Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline Insights/Trends" as link_name, "/dashboards-next/52" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/insights/default/24px.svg" as icon, "Pipeline Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline Creation" as link_name, "/dashboards-next/127" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/add_circle/default/24px.svg" as icon, "Pipeline Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline Deep Dive" as link_name, "/dashboards-next/71" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/zoom_in/default/24px.svg" as icon, "Pipeline Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Slippage" as link_name, "/dashboards-next/65" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/trending_down/v17/24px.svg" as icon, "Pipeline Detail" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Account Lookup" as link_name, "/dashboards-next/100" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/data_loss_prevention/default/24px.svg" as icon, "Pipeline Detail" AS category, FALSE as add_filter)
+ -- Pipeline Council
+ UNION ALL
+ (SELECT "Pipeline Council - GCP Commit" as link_name, "/dashboards-next/160" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/filter_drama/default/24px.svg" as icon, "Pipeline Council" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline Council - GWS New" as link_name, "/dashboards-next/203" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/description/default/24px.svg" as icon, "Pipeline Council" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline Council - GCP Standard" as link_name, "/dashboards-next/488" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/apps/default/24px.svg" as icon, "Pipeline Council" as category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline Council - Scorecard" as link_name, "/dashboards-next/504" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/dashboard/default/24px.svg" as icon, "Pipeline Council" as category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "BHI - Pipeline Health" as link_name, "/dashboards-next/136" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/sort/v13/24px.svg" as icon, "Pipeline Council" AS category, TRUE as add_filter)
+ -- Pommel Horse V2 Links
+ UNION ALL
+ (SELECT "BHI Home" as link_name, "/dashboards-next/83" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "pommelhorse_v2" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pommelhorse Home" AS link_name, "/dashboards-next/260" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/bedroom_baby/default/24px.svg" as icon, "pommelhorse_v2" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Daily Account Spend" AS link_name, "/dashboards-next/266" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/calendar_today/default/24px.svg" as icon, "pommelhorse_v2" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Monthly Account Spend" AS link_name, "/dashboards-next/268" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/calendar_view_month/default/24px.svg" as icon, "pommelhorse_v2" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Product Usage Monthly" AS link_name, "/dashboards-next/283" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/shopping_cart/default/24px.svg" as icon, "pommelhorse_v2" AS category, TRUE as add_filter)
+ -- Partner Dashboard Links
+ UNION ALL
+ (SELECT "BHI Home" as link_name, "/dashboards-next/83" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "Partner" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Partner BHI" as link_name, "/dashboards-next/151" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/trending_up/v18/24px.svg" as icon, "Partner" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Partner Sourced Pipeline" as link_name, "/dashboards-next/199" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/people/v22/24px.svg" as icon, "Partner" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Partner Attached Pipeline" as link_name, "/dashboards-next/218" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/sort/v13/24px.svg" as icon, "Partner" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Partner Certification" as link_name, "/dashboards-next/229" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/zoom_in/default/24px.svg" as icon, "Partner" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Partner MBO" as link_name, "/dashboards-next/476" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/verified/default/24px.svg" as icon, "Partner" AS category, TRUE as add_filter)
+ -- BAP reporting (Apigee, Cloud Armor, Anthos Mesh Services)
+ UNION ALL
+ (SELECT "BAP Home" as link_name, "/dashboards-next/384" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "BAP" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "BAP Revenue" as link_name, "/dashboards-next/324" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/insights/default/24px.svg" as icon, "BAP" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "BAP Pipeline" as link_name, "/dashboards-next/383" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/sort/v13/24px.svg" as icon, "BAP" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "BAP Bookings" as link_name, "/dashboards-next/445" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/checkbook/default/24px.svg" as icon, "BAP" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "BAP Pipeline Hygiene" as link_name, "/dashboards-next/400" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/trending_down/v17/24px.svg" as icon, "BAP" AS category, TRUE as add_filter)
+ -- Vector Forecasting
+ UNION ALL
+ (SELECT "GCP Forecast Call" as link_name, "/dashboards-next/293" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/cloud/v12/24px.svg" as icon, "Vector Forecast" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Workspace Forecast Call" as link_name, "/dashboards-next/412" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/description/v12/24px.svg" as icon, "Vector Forecast" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "D&A Forecast Call" as link_name, "/dashboards-next/446" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/analytics/default/24px.svg" as icon, "Vector Forecast" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "BHI Home" as link_name, "/dashboards-next/83" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "Vector Forecast" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "GCP Sales Revenue Insights" as link_name, "/dashboards-next/60" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/payments/v12/24px.svg" as icon, "Vector Forecast" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "GCP Bookings Insights" as link_name, "/dashboards-next/129" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/event_upcoming/default/24px.svg" as icon, "Vector Forecast" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "D&A Insights" as link_name, "/dashboards-next/331" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/insights/default/24px.svg" as icon, "Vector Forecast" AS category, TRUE as add_filter)
+ -- Win Loss
+ UNION ALL
+ (SELECT "GCP Win Loss" as link_name, "/dashboards-next/549" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/home/v15/24px.svg" as icon, "Win Loss" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Win Loss Use Cases" as link_name, "/dashboards-next/550" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/trending_up/default/24px.svg" as icon, "Win Loss" AS category, TRUE as add_filter)
+ UNION ALL
+ --SMB GWS AM
+ (SELECT "Close Won" as link_name, "/dashboards-next/409" as url, "https://fonts.gstatic.com/s/i/googlematerialicons/payments/v12/24px.svg" as icon, "SMB GWS AM" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Pipeline" as link_name, "/dashboards-next/411" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/description/default/24px.svg" as icon, "SMB GWS AM" AS category, TRUE as add_filter)
+ UNION ALL
+ (SELECT "Manager Summary" as link_name, "/dashboards-next/572" as url, "https://fonts.gstatic.com/s/i/short-term/release/googlesymbols/dashboard/default/24px.svg" as icon, "SMB GWS AM" AS category, TRUE as add_filter)
+ )
+ SELECT *
+ , ROW_NUMBER() OVER () as order_by
+ FROM link_list
+ ;;
+ }
+ #### PRIMARY KEY ####
+ dimension: pk {
+ hidden: yes
+ sql: concat(${link_name}, ${url});;
+ }
+ #### DIMENSIONS #####
+ dimension: add_filter {
+ hidden: yes
+ type: yesno
+ sql: ${TABLE}.add_filter ;;
+ }
+ dimension: category {
+ sql: ${TABLE}.category ;;
+ type: string
+ }
+ dimension: filter_string {
+ sql:
+ {% assign account_id_url = account_id._parameter_value | url_encode %}
+ {% assign account_name_url = account_name._parameter_value | url_encode %}
+ {% assign billing_account_id_url = billing_account_id._parameter_value | url_encode %}
+ {% assign geocluster_url = geocluster._parameter_value | url_encode %}
+ {% assign micro_region_url = micro_region._parameter_value | url_encode %}
+ {% assign nal_cluster_url = nal_cluster._parameter_value | url_encode %}
+ {% assign nal_sub_cluster_url = nal_sub_cluster._parameter_value | url_encode %}
+ {% assign nal_name_url = nal_name._parameter_value | url_encode %}
+ {% assign region_url = region._parameter_value | url_encode %}
+ {% assign reporting_account_name_url = reporting_account_name._parameter_value | url_encode %}
+ {% assign sector_url = sector._parameter_value | url_encode %}
+ {% assign sub_region_url = sub_region._parameter_value | url_encode %}
+ {% if region_granularity._parameter_value.size > 3 %}
+ {% assign region_granularity_url = region_granularity._parameter_value | replace: "_", "%5E_" %}
+ {% elsif nal_cluster._parameter_value.size > 3 %}
+ {% assign region_granularity_url = "nal%5E_name" %}
+ {% elsif nal_sub_cluster._parameter_value.size > 3 %}
+ {% assign region_granularity_url = "nal%5E_name" %}
+ {% elsif micro_region._parameter_value.size > 3 %}
+ {% assign region_granularity_url = "nal%5E_cluster" %}
+ {% elsif sub_region._parameter_value.size > 3 %}
+ {% assign region_granularity_url = "micro%5E_region" %}
+ {% elsif region._parameter_value.size > 3 and region._parameter_value == "EMEA" %}
+ {% assign region_granularity_url = "geocluster" %}
+ {% elsif region._parameter_value.size > 3 and region._parameter_value == "NORTHAM" %}
+ {% assign region_granularity_url = "sector" %}
+ {% elsif region._parameter_value.size > 3 or sector._parameter_value.size > 3 or geocluster._parameter_value.size > 3 %}
+ {% assign region_granularity_url = "sub%5E_region" %}
+ {% else %}
+ {% assign region_granularity_url = "region" %}
+ {% endif %}
+ REPLACE(
+ '?Region+Granularity={{ region_granularity_url }}&Reporting+Account+Name={{ reporting_account_name_url }}&NAL+Cluster={{ nal_cluster_url }}&NAL+Subcluster={{ nal_sub_cluster_url }}&SFDC+Account+ID={{ account_id_url }}&Micro+Region={{ micro_region_url }}&Sub+Region={{ sub_region_url }}&Region={{ region_url }}&Billing+Account+ID={{ billing_account_id_url }}&Account+Name={{ account_name_url }}&NAL+Name={{ nal_name_url }}&NORTHAM+Sector={{ sector_url }}&EMEA+Geocluster={{ geocluster_url }}'
+ , "%27"
+ , ""
+ );;
+ }
+ dimension: icon_url {
+ hidden: yes
+ sql: ${TABLE}.icon ;;
+ type: string
+ }
+ dimension: link_name {
+ group_label: "Links"
+ label: "Link with Image"
+ description: "A link to a dashboard with appropriate filters applied and an icon"
+ order_by_field: order_by
+ sql: ${TABLE}.link_name ;;
+ type: string
+ html: <div style="font-size:{{ link_size._parameter_value }}"><a href="{{ url_filtered._value }}" target="_blank"><img style="height:{{ link_size._parameter_value }};"src="{{ icon_url._value }}"> {{ rendered_value }}</a></div> ;;
+ }
+ dimension: link_name_no_image {
+ group_label: "Links"
+ label: "Link without Image"
+ description: "A link to a dashboard with appropriate filters applied and no icon"
+ order_by_field: order_by
+ sql: ${link_name} ;;
+ type: string
+ html: <div style="font-size:{{ link_size._parameter_value }}"><a href="{{ url_filtered._value }}" target="_blank">{{ rendered_value }}</a></div> ;;
+ }
+ dimension: order_by {
+ hidden: yes
+ description: "Ordering of links based on the order they were entered into the Pommel Horse table."
+ type: number
+ sql: ${TABLE}.order_by ;;
+ }
+ dimension: url {
+ hidden: yes
+ sql: ${TABLE}.url ;;
+ type: string
+ }
+ dimension: url_filtered {
+ label: "URL"
+ sql: IF(${add_filter}, CONCAT(${url}, ${filter_string}), ${url}) ;;
+ type: string
+ }
+ #### PARAMETERS #####
+ parameter: account_id {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+ parameter: account_name {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+ parameter: billing_account_id {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+ parameter: geocluster {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+ parameter: link_size {
+ type: unquoted
+ description: "Change the font size of the link"
+ default_value: "1em"
+ allowed_value: {
+ label: "Large"
+ value: "1.5em"
+ }
+ allowed_value: {
+ label: "Medium"
+ value: "1em"
+ }
+ allowed_value: {
+ label: "Small"
+ value: "0.5em"
+ }
+ }
+ parameter: micro_region {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+ parameter: nal_cluster {
+ view_label: "Filters"
+ label: "NAL Cluster"
+ type: string
+ default_value: ""
+ }
+ parameter: nal_name {
+ view_label: "Filters"
+ label: "NAL Name"
+ type: string
+ default_value: ""
+ }
+ parameter: nal_sub_cluster {
+ view_label: "Filters"
+ label: "NAL Subcluster"
+ type: string
+ default_value: ""
+ }
+ parameter: region {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+ 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 Subcluster"
+ value: "nal_sub_cluster"
+ }
+ allowed_value: {
+ label: "NAL Name"
+ value: "nal_name"
+ }
+ allowed_value: {
+ label: "NAL ID"
+ value: "nal_id"
+ }
+ allowed_value: {
+ label: "Reporting Account Name"
+ value: "reporting_account_name"
+ }
+ }
+ parameter: reporting_account_name {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+ parameter: sector {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+ parameter: sub_region {
+ view_label: "Filters"
+ type: string
+ default_value: ""
+ }
+}
