Hey Guys, new to this platform and exploring how to create visuals. I have a dataset with attributes like suburbs, and I'm interested in grouping specific suburbs together to form regions. For example, within a state, I want to compare different regions in a single chart. Is there a way to do this?

Hi Anthony. To gropup several suburbs into region, the best approach would be to have this mapping in the data so the Region would be another attribute. If you can not do it directly in your database/data source, you could utilize the SQL dataset and use SQL to define new column i.e. with CASE statement.