Question

Grouping Zip Code Dimensions with Custom Fields

  • 6 January 2022
  • 2 replies
  • 17 views

Hello all!

We’ve recently began using the Custom Fields labs feature. One of the quirks we’ve run into is the inability to group Zip Code type dimensions.

We have no trouble creating the Custom Dimension to group by Zip Code, and the modals work just fine. But when it comes time to actually run the query, we get this error:

Initially, I thought that Zip Code dimensions just may not be supported in Custom Dimensions (similar to how they’re not able to be referenced in Custom Filters or Table Calculations), but reviewing the Looker docs tells me otherwise.

The docs specifically indicate that Zip Codes are supported in the Group custom fields. (the green “ZC” badge in the screenshot below)

Has anyone else run into this problem?


2 replies

Userlevel 6
Badge +1

Can you show us sample data table and the code for your custom dimension? I will run something similar on my end to see if it’s a bug

Can you show us sample data table and the code for your custom dimension? I will run something similar on my end to see if it’s a bug

Here’s a quick gif of creating a similar custom dimension. I used the native “Group” option as opposed to defining one with code, because zip codes type fields do not return in the code input for custom dimensions or table calculations.

 

Reply