label_from_parameter

Stay organized with collections Save and categorize content based on your preferences.

Usage

view: view_name {
  dimension: field_name {
    label_from_parameter: parameter_name
  }
}
Hierarchy
label_from_parameter
Possible Field Types
Dimension, Measure

Accepts
A parameter name

Definition

The label_from_parameter parameter lets you change how a field name appears in a visualization, based on the value of a parameter.

In the following example we create a parameter called item_to_add_up that lets a user choose the database column to sum. A corresponding measure called dynamic_sum performs the calculation, and it takes on the name of the parameter value because we've used label_from_parameter: item_to_add_up

parameter: item_to_add_up {
  type: unquoted
  allowed_value: {
    label: "Total Sale Price"
    value: "sale_price"
  }
  allowed_value: {
    label: "Total Cost"
    value: "cost"
  }
  allowed_value: {
    label: "Total Profit"
    value: "profit"
  }
}

measure: dynamic_sum {
  type: sum
  sql: ${TABLE}.{% parameter item_to_add_up %} ;;
  label_from_parameter: item_to_add_up
  value_format_name: "usd"
}

In Looker the appearance would be: