Insights sort by / view by Deals, custom address field

Lon J
Lon J Member Posts: 1 VERIFIED MEMBER
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.

Tagged:

Answers

  • Kreete K
    Kreete K Pipedrive Team Posts: 354 PIPEDRIVE TEAM
    Fourth Anniversary 100 Comments 25 Likes 5 Answers
    #2

    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.

This discussion has been closed.

Categories