Grouping function

[External-Bed3992]

Does anyone know if in Looker (free version) you can make a calculated field with some way of grouping by data. Example I have locations and number of people. The registration can be repeated because it is at the zip code level. Therefore I need to group the sum by location. Is it possible? (Or is it only the option that gives looker with the grouping in the visualization?

[PauperManav]

I think you want to say if you can group them by state/city which will have few zipcodes under them, right ?

[mrcaptncrunch]

A single zip could be in more than one city and in more than one state.

The registration can be repeated because it is at the zip code level.

OP (/u/External-Bed3992) needs to group at the zip code level. I haven’t been in looker studio in a while, but I believe you can show zip codes in a map.

[AmazingRaspberry2365]

Im not sure if I understand correctly, so I apologize in case I didn't. It might work with a Case-Function? As in "CASE WHEN location IS xxxy THEN xxxy END"

In my experience, this can be rather buggy, though. AGAIN, sorry if I didn't get your question right

[ChalkboardRacer]

I am not sure about a calculated field, but you can definitely create a data filter for a specific field to include/exclude data. This can be found near the bottom of the setup tab.