How can I label my column string values differently in Looker?

I have a column with few name values which are string basically and I need to just rename them so that it shows differently in the dashboard which I am preparing using LookML. The scenario is as follows--

This is what I have( the names are as follows- Jon, Smit, mary, beth):

 dimension: names {
    type: string
    sql: ${TABLE}.names ;;
  }

This is what I tried:

 dimension: names{
  type: string
  case: {
      when: {
        sql: ${TABLE}.name = 'Jon' ;;
        label: "John"
      }
    when: {
        sql: ${TABLE}.name = 'Smit' ;;
        label: "Smith"
      }
    when: {
        sql: ${TABLE}.name = 'mary' ;;
        label: "Mary"
      }
  when: {
        sql: ${TABLE}.name = 'beth' ;;
        label: "Beth"
      }

but it seems like it did not work as I am using this field as a filter in a dashboard and it is breaking everything. Can anyone suggest what I might be doing wrong here?

0 0 1,663
0 REPLIES 0
Top Labels in this Space
Top Solution Authors