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