Polygon and Count by - Geometric Map

[gabriel_k]

I am currently working on a dataset within Dataiku that contains a record of various accidents, with each row representing a unique incident and including a range of information, such as the geographical location of each accident represented by polygons of departments. I've encountered a challenge when trying to visualize this data on a geometric map within the tool.

My goal is to display the number of accidents per department, ideally by counting the unique identifiers (IDs) for each accident. However, I've run into a snag – the geometric map tool doesn't seem to allow the use of custom aggregation or a count of records. Whenever I attempt to apply these functions, I receive an error message indicating "cannot use XXX."

Is there an alternative method to visualize the number of accidents by department on the map without having to create a separate dataset with a 'group by' operation? I would like to maintain the ability to filter based on other criteria within the same dataset, and creating a separate aggregated dataset could limit this functionality.

Any suggestions or workarounds that would allow me to achieve this within Dataiku's visualization capabilities would be greatly appreciated.

[Marine · Accepted solution]

Hello Gabriel, 

Currently, the geometry maps don't support aggregations. The simplest workaround would be to use an administrative map that supports the aggregation "count distinct". If you choose the administrative level "department", it should display the desired outcome. 

Does it make sense? 

 

[gabriel_k]

Thank you for your prompt reply and the solution provided. It "make sense" in a way 🙂 .Using  the administrative map should suffice for my need.