Kibana - Group by zipcode

I have a classical user index with there address. I wanted to to a visualisation (text, histogram) with the count of each area (aka group zip_code like 75*). I can only have visualization of the count of each unique zip code. I want to regroup 75000 with 75100 with... and have the final count for this area.

Just so I understand this right, you're looking to not use the exact zip code, but want it to be a subset and group on that?

If so, I would recommend using a scripted field, and aggregate on that. You can create the scripted field under Management > Index Patterns

Yes @tylersmalley,

The zip code here is 5 numbers, only the first two are the "department". I want to know how many customers I have in Paris area (75xxx).
The scripted field seems to be the right way to do it. I don't get hoe I will do that yet since the regex seems to be off by default.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.