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: "" + } +}