Insights sort by / view by Deals, custom address field

Lon J
Lon J Member Posts: 1
edited July 2023 in Sales CRM #1

I'm trying to build a report that shows how many deals are being created for orders from different states using a custom Deals (address format) field that holds a google verified address. I just need a function that allows us to sort by the "State" or "Zipcode".

I also tried the "Numeric" field with just a raw Zipcode and the limited sorting for this field type wouldn't allow the zipcodes to be displayed in groups.

Answers

  • Kreete K
    Kreete K Pipedrive Team Posts: 355 PIPEDRIVE TEAM
    5 Likes First Anniversary First Answer Name Dropper

    Hi @Lon J

    If you are using our Professional plan or higher, then maybe the best workaround would be to use a Single option field for every State and report based on that field. It is currently not possible to report based on the default State field in address, it would still need to be a custom field.