"Must provide a field name for parameter" error message

Hi, I’m trying to create a simple parameter to choose between 2 dimensions to breakdown a view. I’ve copied the syntax exactly from the Looker docs, but keep getting an error saying that the “parameter’ needs a field name:

parameter: regiondrilldown {
    type: unquoted
    allowed_value: {value: "Country"}
    allowed_value: {value: "State"}
    allowed_value: {value: "City"}
  }

  dimension: geo_breakdown {
    type: string
    label_from_parameter: regiondrilldown
    sql:
      case
        when {% parameter ${regiondrilldown} %} = 'Country' Then ${country}
        when {% parameter ${regiondrilldown} %} = 'State' then ${state}
        when {% parameter ${regiondrilldown} %} = 'City' then ${city}
      end ;;
  }

Solved Solved
0 6 840
1 ACCEPTED SOLUTION

I usually do parameters this way @nikitanaresh 

parameter: regiondrilldown {
type: unquoted
allowed_value: {value: "country"
label: "Country"}
allowed_value: {value: "state"}
label: "State"}
allowed_value: {value: "city"}
label: "City"}
}

dimension: geo_breakdown {
type: string
label_from_parameter: regiondrilldown
sql:
{% if regiondrilldown._parameter_value == 'country' %} ${country}
{% elsif regiondrilldown._parameter_value == 'state' %} ${state}
{% elsif regiondrilldown._parameter_value == 'city' %} ${city}
{% else %} ${country}
{% endif %};;
}

View solution in original post

6 REPLIES 6
Top Labels in this Space
Top Solution Authors