manifest.lkml

constant: CONNECTION_NAME {
  value: "cortex"
  export: override_required
}

constant: GCP_PROJECT_ID {
  value: "GCP Project ID"
  export: override_required
}

constant: REPORTING_DATASET {
  value: "Reporting Dataset Name"
  export: override_required
}

#########################################################
# LABEL: View
#{
# Defines view labels which impact Explore readability.

constant: label_view_for_filters {
  value: "🔍 Filters"
}

constant: label_view_for_dashboard_navigation {
  value: "🛠 Dashboard Navigation"
}

#} end constants for view labels

#########################################################
# LINK
#{
# The set of constants with the link_ prefix support the building of url links whether tied to a
# field's link property or designed to display in a single value visualization.
#
# There are constants defined to support defining styles, mapping Explore fields to dashboard filters,
# capturing and parsing urls plus generating filter strings and a new url path.
#
# Liquid has a parameter called {{link}}. This parameter is most useful
# on measures because it actually contains the full URL (including pivots) of
# where the user clicked in the data/visualization pane.
#
# Using a dummy measure called link_generator, these constants will capture the full url
# when a user clicks on a measure in an Explore or Dashboard. They will parse full url
# to get the applied filters and then build a new url link to desired target:
#   - a drill modal with table or visualization
#   - an Explore page with a new visualization
#   - another Dashboard


#########################################################
# LINK_STYLE
#{
# Defines different display styles for a url link.

#--> link_style_dashboard_navigation
#{
# Defines the multiple styles available for dashboard links:
#     buttons, tabs or plain
# These options should match the allowed values in parameter_navigation_style
# found in template_dashboard_navigation_ext and any extension of this template.
#
# Generates liquid variables for click_style and non_click_style.
# These styles will be applied when displaying the dashboard urls in a single value visualization.
# See the html property of the dimension template_dashboard_navigation_ext.navigation_links.
#}
constant: link_style_dashboard_navigation {
  value: "{% assign nav_style = parameter_navigation_style._parameter_value %}
  {% case nav_style %}
    {% when 'buttons' %}
      {% assign core_style = 'border-collapse: separate; border-radius: 6px; border: 2px solid #dcdcdc; margin-left: 5px; margin-bottom: 5px; padding: 6px 10px; line-height: 1.5; user-select: none; font-size: 12px; font-style: tahoma; text-align: center; text-decoration: none; letter-spacing: 0px; white-space: normal; float: left;' %}
      {% assign non_click_style = core_style | append: 'background-color: #FFFFFF; color: #000000; font-weight: normal;' %}
      {% assign click_style = core_style | append: 'background-color: #dbe8fb; color: #000000; font-weight: medium;' %}
      {% assign div_style = 'text-align: center; display: inline-block; height: 40px;' %}
      {% assign span_style = 'font-size: 16px; padding: 6px 10px 0 10px; height: 40px;' %}
    {% when 'tabs' %}
      {% assign core_style = 'font-color: #4285F4; padding: 5px 10px; border-style: solid; border-radius: 5px 5px 0 0; float: left; line-height: 20px;'%}
      {% assign non_click_style = core_style | append: 'border-width: 1px; border-color: #D3D3D3;' %}
      {% assign click_style = core_style | append: 'border-width: 3px; border-color: #808080 #808080 #F5F5F5 #808080; font-weight: bold; background-color: #F5F5F5;' %}
      {% assign div_style = 'border-bottom: solid 2px #808080; padding: 4px 10px 0px 10px; height: 38px;' %}
      {% assign span_style = 'font-size: 16px; padding: 6px 10px 0 10px; height: 38px;' %}
    {% when 'plain' %}
      {% assign non_click_style = 'color: #0059D6; padding: 5px 15px; float: left; line-height: 40px;' %}
      {% assign click_style = non_click_style | append: 'font-weight:bold;font-size: 12px;' %}
      {% assign div_style = 'float: left;' %}
      {% assign span_style = 'font-size: 10px; display: table; margin:0 auto;' %}
  {% endcase %}"
}

#} end constants for link style

#########################################################
# LINK_MAP
#{
#
# Map explore fields to filters (begin with link_map_youtube_)
# or map detail set to be used in Explore links
# or map dashboard ids to names and filter sets (begin with link_map_youtube_dash_bindings_)
#
# The constants with the link_map_ prefix are used to map fields in an Explore/view to either:
# 1. dashboard filter names
# 2. fields in a different Explore
#
# To define the mapping:
# - Use | between field and filter
# - Use || between each mapped pair
# - When the link property also includes the liquid variable use_qualified_filter_names set to false, specifying the view name is optional.
#   This is particularly useful when dealing with multiple Explores containing common fields that require mapping to dashboard filters.
# - Example mapping syntax:
#       value: "invoice_date|date||business_unit_name|business_unit"
#    In this example, any filters for invoice_date will be passed to the dashboard filter named date.
#    Any filters for field business_unit_name will be passed to the dashboard filter named business unit.
# - Additional mapping pairs can be appended to these constants when defining the link property.
# - Example measure which opens a dashboard using the constant
#   link_map_sales_orders_to_order_details to define the source_to_destination_filters_mapping:
#       measure: total_impressions {
#           link: {
#             label: "YouTube Performance Details"
#             icon_url: "/favicon.ico"
#             url: "
#                @{link_build_variable_defaults}
#               {% assign link = link_generator._link %}
#               {% assign use_qualified_filter_names = false %}
#               {% assign source_to_destination_filters_mapping =       '@{link_map_ad_group_insights_to_performance_details}'%}
#               {% assign model = _model._name %}
#               {% assign target_dashboard = _model._name | append: '::youtube_5_detailed_performance' %}
#               @{link_build_dashboard_url}
#               "
#             }
#         }

#--> link_map_youtube_detail_set
#{
# Defines the drill_fields to use based on the active view calling the link.
# Will be passed to the link_build_explore_url constant.
#}
constant: link_map_youtube_detail_set {
  value: "{%- assign active_view = _view._name -%}
  {%- if active_view == 'line_item_insights' -%}
      {%- assign drill_fields = 'line_item_insights.advertiser,
        line_item_insights.campaign,
        line_item_insights.insertion_order,
        line_item_insights.line_item,
        line_item_insights.total_impressions,
        line_item_insights.cpm,
        line_item_insights.trueview_vr,
        line_item_insights.cpv,
        line_item_insights.total_trueview_views,
        line_item_insights.total_clicks,
        line_item_insights.cpc,
        line_item_insights.ctr,
        line_item_insights.total_spend' -%}
  {%- elsif active_view == 'ad_group_insights_by_ad_format' -%}
      {%- assign drill_fields = 'ad_group_insights_by_ad_format.youtube_ad_format,
            ad_group_insights_by_ad_format.advertiser,
            ad_group_insights_by_ad_format.campaign,
            ad_group_insights_by_ad_format.insertion_order,
            ad_group_insights_by_ad_format.line_item,
            ad_group_insights_by_ad_format.total_impressions,
            ad_group_insights_by_ad_format.cpm,
            ad_group_insights_by_ad_format.trueview_vr,
            ad_group_insights_by_ad_format.cpv,
            ad_group_insights_by_ad_format.total_trueview_views,
            ad_group_insights_by_ad_format.total_clicks,
            ad_group_insights_by_ad_format.cpc,
            ad_group_insights_by_ad_format.ctr,
            ad_group_insights_by_ad_format.total_spend
        ' -%}
  {%- elsif active_view == 'ad_group_insights_by_age_gender' -%}
      {%- assign drill_fields = 'ad_group_insights_by_age_gender.gender,
            ad_group_insights_by_age_gender.youtube_age,
            ad_group_insights_by_age_gender.advertiser,
            ad_group_insights_by_age_gender.campaign,
            ad_group_insights_by_age_gender.insertion_order,
            ad_group_insights_by_age_gender.line_item,
            ad_group_insights_by_age_gender.total_impressions,
            ad_group_insights_by_age_gender.cpm,
            ad_group_insights_by_age_gender.trueview_vr,
            ad_group_insights_by_age_gender.cpv,
            ad_group_insights_by_age_gender.total_trueview_views,
            ad_group_insights_by_age_gender.total_clicks,
            ad_group_insights_by_age_gender.cpc,
            ad_group_insights_by_age_gender.ctr,
            ad_group_insights_by_age_gender.total_spend' -%}
  {%- elsif active_view == 'ad_group_insights_by_audience' -%}
      {%- assign drill_fields = 'ad_group_insights_by_audience.youtube_audience_segment, ad_group_insights_by_audience.youtube_audience_segment_type,
        ad_group_insights_by_audience.advertiser,
        ad_group_insights_by_audience.campaign,
        ad_group_insights_by_audience.insertion_order,
        ad_group_insights_by_audience.line_item,
        ad_group_insights_by_audience.total_impressions,
        ad_group_insights_by_audience.cpm,
        ad_group_insights_by_audience.trueview_vr,
        ad_group_insights_by_audience.cpv,
        ad_group_insights_by_audience.total_trueview_views,
        ad_group_insights_by_audience.total_clicks,
        ad_group_insights_by_audience.cpc,
        ad_group_insights_by_audience.ctr,
        ad_group_insights_by_audience.total_spend' -%}
  {%- endif -%}"
}

#--> link_map_youtube_dash_bindings_*
#{ For the dash_bindings dimension defined in the youtube_dashboard_navigation_ext.view
#  these constants provided the dashboard name/id, link text and numeric filters to be passed between dashboards in
#  separated by '|'. For example:
#   id | link text | filter set
#   youtube_1_overview|Overview|1,2,3
#
#  Note, if using User-defined dashboards instead of LookML dashboards, replace the first value with numeric
#  dashboard id or dashboard slug
#
#       dashboard name                    link text               filters used
#       ---------------                   --------------------    ----------
#       youtube_1_overview                  Overview                1,2,3
#       youtube_2_campaign_line_items       Campaign Line Items     1,2,3
#       youtube_3_audience_type             Audience Type           1,2,3
#       youtube_4_ad_format                 Ad Format               1,2,3
#       youtube_5_detailed_performance      Detailed Performance    1,2,3
#
#       - example syntax:
#           "youtube_1_overview|Overview|1,2,3||youtube_2_campaign_line_items|Campaign Line Items|1,2,3||youtube_3_audience_type|Audience Type|1,2,3"
#}
constant: link_map_youtube_dash_bindings_overview {
  value: "youtube_1_overview|Overview|1,2,3"
}

constant: link_map_youtube_dash_bindings_campaign_line_items {
  value: "youtube_2_campaign_line_items|Campaign Line Items|1,2,3"
}

constant: link_map_youtube_dash_bindings_audience_type {
  value: "youtube_3_audience_type|Audience Type|1,2,3"
}

constant: link_map_youtube_dash_bindings_ad_format {
  value: "youtube_4_ad_format|Ad Format|1,2,3"
}

constant: link_map_youtube_dash_bindings_detailed_performance {
  value: "youtube_5_detailed_performance|Detailed Performance|1,2,3"
}

#--> link_map_clean_target_dashboard
#{ Takes input of liquid variable target_dashboard and checks if it is a string.
# If numeric, do nothing.
# If string, for names with '::' (full LookML dashboard reference) or
# names of 22-character length without '_' (slug id) do nothing
# else treat append model name for proper url reference of LookML dashboards:
#   model name::lookml dashboard name
# Outputs an updated target_dashboard liquid variable for LookML dashboards.
#}

constant: link_map_clean_target_dashboard {
  value: "{% assign check_target_type = target_dashboard | plus: 0 %}
  {% if check_target_type == 0 %}
  {% assign name_size = target_dashboard | size %}
  {% comment %} For names with '::' or length of 22 characters without '_', keep the name as is. {% endcomment %}
  {% comment %} Otherwise, add the model name and '::' to ensure proper reference to the LookML dashboard. {% endcomment %}
  {% if target_dashboard contains '::' %}
  {% elsif name_size == 22 %}
  {% if target_dashboard contains '_' %}
  {% assign target_dashboard = _model._name | append: '::' | append: target_dashboard %}
  {% endif %}
  {% else %}
  {% assign target_dashboard = _model._name | append: '::' | append: target_dashboard %}
  {% endif %}
  {% endif %}"
}


#--> link_map_filters_from_navigation_dash_bindings
#{
# - Generates liquid variable source_to_destination_filters_mapping used in building a dashboard url.
# - For dashboard navigation defined using an extension of template_dashboard_navigation_ext,
#   the LookML developer uses the dash_bindings and map_filter_numbers_to_dashboard_filter_names dimensions
#   to map filters 1 to N to filters of one or more dashboards.
# - This constant reads the value of this dimension and the dash_bindings dimension to
#   generate the liquid variable source_to_destination_filters_mapping in the required syntax.
# - See template_dashboard_navigation_ext.navigation_links dimension for example of how this constant is used.
#}
constant: link_map_filters_from_navigation_dash_bindings {
  value: "{% assign source_to_destination_filters_mapping = ''%}

  <!-- Capture model_name and view_name (if needed to qualify field name) -->
      {% assign model_name = _model._name %}
      {% if use_qualified_filter_names == true %}
        {% assign view_name = _view._name | append: '.' %}
      {%else%}
        {% assign view_name = '' %}
      {%endif%}

  <!-- Create nav_items array from dash_bindings and dash_map from map_filter_numbers_to_dashboard_filter_names. -->
      {% assign nav_items = dash_bindings._value | split: '||' %}
      {% assign dash_map = map_filter_numbers_to_dashboard_filter_names._value | split: '||' %}

  <!-- Begin loop through the array of dashboards. -->
  <!-- Note this for loop ends outside of this constant in the navigation_links html property -->
    {% for nav_item in nav_items %}
        {% assign nav_parts = nav_item | split: '|' %}
        {% assign dash_label = nav_parts[1] %}

  <!-- Assign target_dashboard name and ensure any LookML dashboard names provided follow proper naming syntax. -->
      {% assign target_dashboard = nav_parts[0] %}
       @{link_map_clean_target_dashboard}

  <!-- Create source_to_destination_filters_mapping variable by looping through the mapped pairs -->
      {% assign dash_filter_set = nav_parts[2] | split: ',' %}
      {% for dash_filter in dash_filter_set %}
          {% for map_item in dash_map %}
            {% assign map_item_key = map_item | split:'|' | first %}
            {% if dash_filter == map_item_key %}
              {% assign map_item_value = map_item | split:'|' | last %}
              {% assign filter_name = view_name | append: 'filter' | append: dash_filter | append: '|' | append: map_item_value | append: '||' %}
              {% assign source_to_destination_filters_mapping = source_to_destination_filters_mapping | append: filter_name  %}
            {% endif %}
          {% endfor %}
      {% endfor %}"
}

#} end constants for link maps

#########################################################
# LINK_VIS: Set config properties
#{
# Constants with the link_vis prefix define configuration values for
# common visualization types and patterns. When defining a field's link property,
# use one of these constants to pass the desired viz configuration to the url.
#
# Each of these generates a liquid variable called {{vis_config}} and you can
# append additional parameters to this as needed once you add the constant to the
# link property.
#
# Every link_vis_ constant requires the liquid variable drill_fields as a minimum input.
# Additionally, some functions may require other inputs.
#
# Example measure that opens a drill modal with a line chart for sales by month
# with the reference to link_vis_line_chart_1_date_1_measure.
#
#   measure: total_sales_amount_target_currency_formatted {
#     link: {
#           label: "Show Sales by Month"
#           url: "@{link_build_variable_defaults}
#                   {% assign link = link_generator._link %}
#                   {% assign view_header = _explore._name | append: '.' %}
#                   {% assign view_detail = _view._name | append: '.' %}
#                   {% assign measure = 'total_sales_amount_target_currency' | prepend: view_detail %}
#                   {% assign date_dimension = 'ordered_month' | prepend: view_header %}
#                   {% assign drill_fields =  date_dimension | append: ',' | append: measure %}
#                 @{link_vis_line_chart_1_date_1_measure}
#                 @{link_build_explore_url}"
#           }
#       }

constant: link_vis_table {
  value: "{% assign vis_config = '{\"type\":\"looker_grid\"}' | url_encode | prepend: '&vis_config=' %}"
}

#--> link_viz_table_no_cell_visualization
# Creates table and cell visualization for measures is disabled
constant: link_vis_table_no_cell_visualization {
  value: "{% assign vis_config = '{\"type\":\"looker_grid\",\"series_cell_visualizations\":{}}' | url_encode | prepend: '&vis_config=' %}"
}

#--> link_vis_table_assign_cell_visualization
# Creates table with developer-provided cell visualization in the form of:
# {% assign cell_visualization = '\"line_item_insights.total_impressions\":{\"is_active\":true},\"line_item_insights.total_clicks\":{\"is_active\":true}' %}
constant: link_vis_table_assign_cell_visualization {
  value: "{% assign vis_config = '{\"type\":\"looker_grid\",\"series_cell_visualizations\":{' | append: cell_visualization | append: '}}' | url_encode | prepend: '&vis_config=' %}"
}

constant: link_vis_column {
  value: "{% assign vis_config = '{\"type\":\"looker_column\"}' | url_encode | prepend: '&vis_config=' %}"
}

constant: link_vis_bar {
  value: "{% assign vis_config = '{\"type\":\"looker_bar\"}' | url_encode | prepend: '&vis_config=' %}"
}

constant: link_vis_area {
  value: "{% assign vis_config = '{\"type\":\"looker_area\"}' | url_encode | prepend: '&vis_config=' %}"
}

constant: link_vis_line {
  value: "{% assign vis_config = '{\"type\":\"looker_line\"}' | url_encode | prepend: '&vis_config=' %}"
}

constant: link_vis_map {
  value: "{% assign vis_config = '{\"type\":\"looker_map\"}' | url_encode | prepend: '&vis_config=' %}"
}

constant: link_vis_pie {
  value: "{% assign vis_config = '{\"type\":\"looker_pie\"}' | url_encode | prepend: '&vis_config=' %}"
}

constant: link_vis_single {
  value: "{% assign vis_config = '{\"type\":\"single_value\"}' | url_encode | prepend: '&vis_config=' %}"
}

#--> link_vis_line_chart_1_date_1_measure
# Creates a line chart for a given measure. The liquid variable measure must be defined before calling the constant.
# For example:
#   {% assign measure = sales_orders__lines.total_sales_amount_target_currency %}
#   @{link_vis_line_chart_1_date_1_measure}
constant: link_vis_line_chart_1_date_1_measure {
  value: "{% assign vis_config = '{\"point_style\":\"circle\",\"series_colors\":{\"' | append: measure | append: '\":\"#468FAF\"},\"type\":\"looker_line\"}' | url_encode | prepend: '&vis_config=' %}"
}

#} end constants for link vis

#########################################################
# LINK_BUILD: Steps building link url
#{
# The constants with the link_build_ prefix take a specific step or action in creating
# a final URL. Steps like defining defaults, extracting context, matching
# filters to destination, etc...

#-->link_build_variable_defaults
#{
# Set default values for liquid variables used to build the url.
# Always add this constant to the link property first to establish the defaults.
# Then you can customize any of these as needed.
#}
constant: link_build_variable_defaults {
  value: "
  {% comment %} Default Parameters for Explores Only {% endcomment %}
  {% comment %} Customizable by LookML Developer {% endcomment %}
  {% assign drill_fields = '' %}
  {% assign pivots = '' %}
  {% assign subtotals = '' %}
  {% assign sorts = '' %}
  {% assign limit = '500' %}
  {% assign column_limit = '50' %}
  {% assign total = '' %}
  {% assign row_total = '' %}
  {% assign query_timezone = '' %}
  {% assign dynamic_fields = '' %}
  {% assign use_different_explore = false %}
  {% assign target_model = '' %}
  {% assign target_explore = '' %}
  {% assign cell_visualization = '' %}

  {% comment %} Default visualization config parameter {% endcomment %}
  @{link_vis_table}

  {% comment %} Default parameters for either Explore or Dashboard {% endcomment %}
  {% comment %} Customizable by LookML Developer {% endcomment %}
  {% assign use_default_filters_to_override = false %}
  {% assign default_filters = '' %}
  {% assign use_qualified_filter_names = true %}
  {% assign use_url_variable = false %}

  {% comment %} Variables to be built in other link_build_ constants {% endcomment %}
  {% assign source_to_destination_filters_mapping = '' %}
  {% assign target_content_filters = '' %}
  "
}

#-->link_build_context
#{
# Extracts the context from the URL captured when the business user clicks on the measure's link in either an Explore or dashboard.
#
# Requires the link variable to be included in the link url property:
#     {% assign link = link_generator._link %}
#
# Is called from either:
#   link_build_dashboard_url
#   link_build_explore_url
#
# This constant loops through array link_query_parameters and generates these liquid variables if found:
#   filters_array
#   dynamic_fields
#   query_timezone
#}
constant: link_build_context {
  value: "
  {% assign filters_array_source = '' %}
  {% for parameter in link_query_parameters %}
    {% assign parameter_key = parameter | split:'=' | first %}
    {% assign parameter_value = parameter | split:'=' | last %}
    {% assign parameter_test = parameter_key | slice: 0,2 %}
    {% if parameter_test == 'f[' %}
      {% comment %} Link contains multiple parameters, need to test if filter {% endcomment %}
      {% if parameter_key != parameter_value %}
        {% comment %} Tests if the filter value is is filled in, if not it skips  {% endcomment %}
        {% assign parameter_key_size = parameter_key | size %}
        {% assign slice_start = 2 %}
        {% assign slice_end = parameter_key_size | minus: slice_start | minus: 1 %}
        {% assign parameter_key = parameter_key | slice: slice_start, slice_end %}
        {% assign parameter_clean = parameter_key | append:'|' |append: parameter_value %}
        {% assign filters_array_source =  filters_array_source | append: parameter_clean | append: ',' %}
      {% endif %}
      {% elsif parameter_key == 'dynamic_fields' %}
        {% assign dynamic_fields = parameter_value %}
      {% elsif parameter_key == 'query_timezone' %}
        {% assign query_timezone = parameter_value %}
    {% endif %}
  {% endfor %}
  {% assign size = filters_array_source | size | minus: 1 | at_least: 0 %}
  {% assign filters_array_source = filters_array_source | slice: 0, size %}
  "
}

#-->link_build_match_filters_to_destination
#{
# Builds the filters_array_destination variable with the destination filter names and the source filter values.
# Requires these inputs:
#   1. source_to_destination_filters_mapping variable from a measure's link property.
#      The mapping indicates how a source field maps to a dashboard filter or a field in a different Explore.
#      The mapping pairs are defined in the form of:
#         view_name.field_name|destination filter1||view_name.field_name2|destination filter2
#      See constant link_map_sales_invoices_to_invoice_details for an example mapping.
#   2. filters_array_source generated with constant link_build_context
#
# Is called from either:
#   link_build_dashboard_url
#   link_build_explore_url

# Loops through each destination filter and checks to see if the field named in the source to
# destination mapping has filter values captured.
#
# For example, a destination dashboard has 3 filters: date, business_name and country and these are mapped
# to Explore fields:
#   sales_orders.ordered_date|date||
#   sales_orders.business_org_name|business_name||
#   sales_orders.country_name|country
#
# The filters_array_source variable captured two filters with these values:
#     sales_orders.ordered_date = last 1 year
#     sales_orders.country_name = USA
#
# The filters_array_destination variable is defined as:
#         date|last 1 year,country|USA
#}
constant: link_build_match_filters_to_destination {
  value: "
  {% assign source_to_destination_filters_mapping = source_to_destination_filters_mapping | split: '||' %}
  {% assign filters_array_source = filters_array_source | split: ',' %}
  {% assign filters_array_destination = '' %}

  {% for source_filter in filters_array_source %}
    {% assign source_filter_key = source_filter | split:'|' | first %}
    {% if use_qualified_filter_names == false %}
        {% comment %} Ignore view name and return field names only {% endcomment %}
        {% assign source_filter_key = source_filter_key | split: '.' | last %}
    {% endif %}
    {% assign source_filter_value = source_filter | split:'|' | last %}

    {% for destination_filter in source_to_destination_filters_mapping %}
      {% comment %} This will loop through the value pairs to determine if there is a match to the destination {% endcomment %}
        {% assign destination_filter_key = destination_filter | split:'|' | first %}
        {% assign destination_filter_value = destination_filter | split:'|' | last %}
        {% if source_filter_key == destination_filter_key %}
          {% assign parameter_clean = destination_filter_value | append:'|' | append: source_filter_value %}
          {% assign filters_array_destination =  filters_array_destination | append: parameter_clean | append:',' %}
        {% endif %}
    {% endfor %}
  {% endfor %}
  {% assign size = filters_array_destination | size | minus: 1 | at_least: 0 %}
  {% assign filters_array_destination = filters_array_destination | slice: 0, size %}
  "
}

#-->link_build_filter_string
#{
# Creates the liquid variable filter_string as url-encoded string formatted for Explore or dashboard.
#
# Requires filters_array_destination from constant link_build_match_filters_to_destination.
#
# Is called from:
#     link_build_dashboard_url
#     link_build_explore_url
#}
constant: link_build_filter_string {
  value: "
  {% assign filter_string = '' %}
  {% assign filters_array_destination = filters_array_destination | split: ',' %}
  {% for filter in filters_array_destination %}
    {% if filter contains 'EMPTY' %}
    {%else%}
      {% if filter != blank %}
        {% assign filter_key = filter | split:'|' | first %}
        {% assign filter_value = filter | split:'|' | last %}
        {% if content == '/explore/' %}
          {% assign filter_compile = 'f[' | append: filter_key | append:']=' | append: filter_value %}
        {% else %}
          {% assign filter_value = filter_value | encode_url %}
          {% assign filter_compile = filter_key | append:'=' | append: filter_value %}
        {% endif %}
        {% assign filter_string = filter_string | append: filter_compile | append:'&' %}
      {% endif %}
    {% endif %}
  {% endfor %}
  {% assign size = filter_string | size | minus: 1 | at_least: 0 %}
  {% assign filter_string = filter_string | slice: 0, size %}
  "
}

#-->link_build_default_filter_string
#{
# Creates the liquid variable default_filter_string as url-encoded string formatted for an Explore or dashboard.
#
# Requires input of default_filters defined by LookML developer in the link property
#
# Is called by these link_ constants if default_filters is not blank:
#     link_build_dashboard_url
#     link_build_explore_url
#}
constant: link_build_default_filter_string {
  value: "
  {% assign default_filter_string = '' %}
  {% assign default_filters = default_filters | split: ',' %}
  {% for filter in default_filters %}
    {% assign filter_key = filter | split:'=' | first %}
    {% assign filter_value = filter | split:'=' | last %}
    {% if content == '/explore/' %}
      {% assign filter_compile = 'f[' | append: filter_key | append:']=' | append: filter_value %}
    {% else %}
      {% assign filter_value = filter_value | encode_url %}
      {% assign filter_compile = filter_key | append:'=' | append: filter_value %}
    {% endif %}
    {% assign default_filter_string = default_filter_string | append: filter_compile | append:'&' %}
  {% endfor %}
  {% assign size = default_filter_string | size | minus: 1 | at_least: 0 %}
  {% assign default_filter_string = default_filter_string | slice: 0, size %}
  "
}

#-->link_build_dashboard_url
#{
# Generates the final dashboard url and returns either:
#     a. the url opened in the frontend UI when use_url_variable == false (which is the default)
#     b. a liquid variable named dashboard_url which can be referenced in a field's html property when use_url_variable == true
#
# See navigation_links dimension in template_dashboard_navigation_ext for an example of using the dashboard_url variable.
#
# Requires these to be added to a measure's link property::
#   - @{link_build_variable_defaults}
#   - the link variable to be included in the measure's link url property:
#            {% assign link = link_generator._link %}
#   - name of target_dashboard:
#       {% assign model = _model._name %}
#       {% assign target_dashboard = _model._name | append: '::youtube_5_detailed performance' %}
#   - @{link_build_dashboard_url}
#
# Optional Inputs (see link_build_variable_defaults for default values) :
#   - filters_mapping
#   - use_qualified_filter_names
#   - default_filters
#   - use_default_filters_to_override
#   - use_url_variable

# Steps Taken:
#   1. Assigns values to these liquid variables:
#         content is set to '/dashboards/'
#         link_path as derived from {{link}} which the LookML Developer adds when setting the field's link property
#         link_query_parameters
#   2. Calls link_build_context
#   3. Calls link_build_match_filters_to_destination
#   4. Calls link_build_filter_string
#   5. If default_filters is not blank calls link_build_default_filter_string
#   6. Builds target_content_filter based on value for use_default_filters_to_override
#   7. If use_url_variable == false returns url that opens a dashboard in UI
#      else returns a liquid variable called dashboard_url which can be referenced in a field's html property.
#}
constant: link_build_dashboard_url {
  value: "
  {% assign content = '/dashboards/' %}
  {% assign link_query = link | split: '?' | last %}
  {% assign link_query_parameters = link_query | split: '&' %}

  @{link_build_context}
  @{link_build_match_filters_to_destination}
  @{link_build_filter_string}

  {% if default_filters != '' %}
  @{link_build_default_filter_string}
  {% endif %}

  {% if use_default_filters_to_override == true and default_filters != '' %}
    {% assign target_content_filters = default_filter_string | append:'&' | append: filter_string %}
  {% elsif use_default_filters_to_override == false and default_filters != '' %}
    {% assign target_content_filters = filter_string | append:'&' | append: default_filter_string %}
  {% else %}
    {% assign target_content_filters = filter_string %}
  {% endif %}

  {% comment %} Builds final link to be presented as either a url in frontend or a liquid variable {% endcomment %}
  {% assign dashboard_url = content | append: target_dashboard | append: '?' | append: target_content_filters %}
  {% if use_url_variable == false %}
    {{ dashboard_url }}
  {% endif %}
  "
}

#-->link_build_explore_link_variable
#{ Generates the liquid variable explore_link by appending
#  each of these liquid variables when not blank:
#    liquid variable                 source
#    ---------------                 -----------
#    content                         set to 'explore' in link_build_explore_url
#    target_model, target_explore    default '' or when use_different_explore==true set by LookML Developer
#                                    else derived in link_build_explore_url based on captured link value
#    drill_fields                    default '' or set by LookML Developer
#    target_content_filters          default '' or compiled in link_build_explore_url from filter_string (see link_build_filter_string)
#                                    and default_filter_string (see link_build_default_filter_string)
#    vis_config                      default link_vis_table or set by LookML Developer with any of the link_vis_ constants or a custom value
#    pivots                          default '' or set to specific fields by LookML Developer
#    subtotals                       default '' or set to specific fields by LookML Developer
#    sorts                           default '' or set to specific fields by LookML Developer
#    limit                           row limit default of 500 or set by LookML Developer
#    column_limit                    row limit default of 50 or set by LookML Developer
#    total                           column total default '' or set to 'on' by LookML Developer
#    row_total                       default '' or set to 'right' by LookML Developer
#    query_timezone                  default '' or set by LookML Developer
#    dynamic_fields                  default '' or set by LookML Developer
#
#}
constant: link_build_explore_link_variable {
  value: "
  {% assign explore_link = '' %}

  {% if content != '' %}
    {% assign explore_link = explore_link | append: content %}
  {% endif %}
  {% if target_model != '' %}
   {% assign explore_link = explore_link | append: target_model | append: '/' %}
  {% endif %}
  {% if target_explore != '' %}
   {% assign explore_link = explore_link | append: target_explore | append: '?'  %}
  {% endif %}
  {% if drill_fields != '' %}
    {% assign explore_link = explore_link | append: drill_fields %}
  {% endif %}
  {% if target_content_filters != '' %}
    {% assign explore_link = explore_link | append: target_content_filters %}
  {% endif %}
  {% if vis_config != '' %}
    {% assign explore_link = explore_link | append: vis_config %}
  {% endif %}
  {% if pivots != '' %}
    {% assign pivots = '&pivots=' |append: pivots %}
    {% assign explore_link = explore_link | append: pivots %}
  {% endif %}

  {% if subtotals != '' %}
    {% assign subtotals = '&subtotals=' |append: subtotals %}
    {% assign explore_link = explore_link | append: subtotals %}
  {% endif %}

  {% if sorts != '' %}
    {% assign sorts = '&sorts=' |append: sorts %}
    {% assign explore_link = explore_link | append: sorts %}
  {% endif %}

  {% if limit != '' %}
    {% assign limit = '&limit=' |append: limit %}
    {% assign explore_link = explore_link | append: limit %}
  {% endif %}

  {% if column_limit != '' %}
    {% assign column_limit = '&column_limit=' |append: column_limit %}
    {% assign explore_link = explore_link | append: column_limit %}
  {% endif %}

  {% if total != '' %}
    {% assign total = '&total=' |append: total %}
    {% assign explore_link = explore_link | append: total %}
  {% endif %}

  {% if row_total != '' %}
    {% assign row_total = '&row_total=' |append: row_total %}
    {% assign explore_link = explore_link | append: row_total %}
  {% endif %}

  {% if query_timezone != '' %}
    {% assign query_timezone = '&query_timezone=' |append: query_timezone %}
    {% assign explore_link = explore_link | append: query_timezone %}
  {% endif %}

  {% if dynamic_fields != '' %}
    {% assign dynamic_fields = '&dynamic_fields=' |append: dynamic_fields %}
    {% assign explore_link = explore_link | append: dynamic_fields %}
  {% endif %}
  "
}

#-->link_build_explore_url
#{
# Generates an Explore url and returns it as either:
#   a. the Explore url opened as a drill modal in the frontend UI when use_url_variable == false (which is the default)
#   b. a liquid variable named explore_link which can be referenced in a field's html property when use_url_variable == true
#
# Requires these to be added to a measure's link property::
#     - @{link_build_variable_defaults}
#     - the link variable to be included in the measure's link url property:
#             {% assign link = link_generator._link %}
#     - one or more drill_fields:
#         {% assign drill_fields = sales_orders.ordered_date,sales_orders__lines.tootal_sales_amount_target_currency %}
#     - settings for vis_config. Pass as one of the look_vis_ constants or define directly.
#         @{link_vis_line_chart_1_date_1_measure}
#         OR
#         {% assign vis_config = '{\"type\":\"looker_grid\",\"series_cell_visualizations\":{}}' | url_encode | prepend: '&vis_config=' %}
#     - @{link_build_explore_url}
#
# Optional Inputs (see link_build_variable_defaults for default values) :
#   use_different_explore
#   target_model
#   target_explore
#   filters_mapping
#   use_qualified_filter_names
#   default_filters
#   use_default_filters_to_override
#   use_url_variable
#   pivots
#   subtotals
#   sorts
#   limit
#   column_limit
#   total
#   row_total
#   query_timezone
#   dynamic_fields
#
# Steps Taken:
#   1. Assigns values to these liquid variables:
#         content is set to explore
#         link_path as derived from {{link}} which the LookML Developer adds when setting the field's link property
#         link_query_parameters
#         drill_fields
#         target_model and target_explore if use_different_explore == false
#   2. Calls link_build_context
#   3. If use_different_explore == true calls link_build_match_filters_to_destination else assigns
#      filters_array_destination to match filters_array_source
#   4. Calls link_build_filter_string
#   5. If default_filters is not blank calls link_build_default_filter_string
#   6. Assigns value to target_content_filter based on true or false value for use_default_filters_to_override
#   7. Calls link_build_explore_link_variable
#   8. If use_url_variable == false returns final Explore url which opens a drill modal
#      else returns a liquid variable called explore_link which can be referenced in a field's html property.
#}
constant: link_build_explore_url {
  value: "
  {% assign content = '/explore/' %}
  {% assign link_path =  link | split: '?' | first %}
  {% assign link_path =  link_path | split: '/'  %}
  {% assign link_query = link | split: '?' | last %}
  {% assign link_query_parameters = link_query | split: '&' %}
  {% assign drill_fields = drill_fields | prepend:'fields='%}

  {% if use_different_explore == false %}
    {% assign target_model = link_path[1] %}
    {% assign target_explore = link_path[2] %}
  {% endif %}

  @{link_build_context}

  {% if use_different_explore %}
     @{link_build_match_filters_to_destination}
  {% else %}
      {% assign filters_array_destination = filters_array_source %}
  {% endif %}

  @{link_build_filter_string}

  {% if default_filters != '' %}
    @{link_build_default_filter_string}
  {% endif %}

  {% if use_default_filters_to_override == true and default_filters != '' %}
    {% assign target_content_filters = filter_string | append:'&' | append: default_filter_string | prepend:'&' %}
  {% elsif use_default_filters_to_override == false and default_filters != '' %}
    {% assign target_content_filters = default_filter_string | append:'&' | append: filter_string | prepend:'&' %}
  {% else %}
    {% assign target_content_filters = filter_string | prepend:'&' %}
  {% endif %}

  {% comment %} Builds final link to be presented in frontend {% endcomment %}
   @{link_build_explore_link_variable}
  {% if use_url_variable == false %}
    {{explore_link}}
  {% endif %}
  "
}

#-->link_build_explore_youtube_line_item_drill
#{
# Generates a table of line item details for DV360 KPIs with these characteristics:
#   - sorted in descending order for the KPI initiating the drill
#   - with cell visualization for the KPI initiating the drill
#   - set of dimensions returned varies depending on the Explore initiating the drill
#}
constant: link_build_explore_youtube_line_item_drill {
  value: "@{link_build_variable_defaults}
          {% assign link = link_generator._link %}
          {% assign active_field = _field._name | remove: '_formatted' %}
          @{link_map_youtube_detail_set}
          {% assign cell_visualization = '\"' | append: active_field | append: '\":{\"is_active\":true}' %}
          {% assign sorts = active_field | append: '+desc' %}
          {% assign total = 'on' %}
          @{link_vis_table_assign_cell_visualization}
          @{link_build_explore_url}"
}

#} end constants for link build

#} end constants for links