
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 }}">&ensp;{{ 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: ""
  }
}