Question

Creating buckets of new combined categories for a chart.


Hello,

 

I am hoping someone can help me with this. I am not sure if this can be done in a table calculation or creating a new variable. I had originally tried to do this in LookML. And it did not work.

 

I would like to group together some retail stores, for example…

 

I would like to categorize or group JC Penny, Johns shoe shop, Target and Costco as “Channel_Bucket.

 

I had originally tried to do this in lookML using the case when function but it did not work for me unless I did it wrong.

 

 

 

 

 

 

 

For example,

 

dimension: channel_bucket {

  case: {

    when: {

      sql: ${TABLE}.channel = JC Penny, Johns shoe shop, Target, Costco ;;

      label: “Retail Other“

    }

    when: {

      sql: ${TABLE}.channel = Zappos, Backcountry ;;

      label: “Online”

    }

    when: {

      sql: ${TABLE}.channel = Soles, Dillards ;;

      label: “DT”

    }

    when: {

      sql: ${TABLE}.channel = Walmart ;;

label: “Walmart”

  }

    when: {

      sql: ${TABLE}.channel = Amazon;;

     label: “Amazon”

 

    }

  }

}


This topic has been closed for comments