How can I separate addresses into cities and states so I can pull a report for all sites in Maryland as an example?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have a list of addresses that will only display in the full site address to accommodate Google Map.  I need to be able to have a report that can be filtered to City and/or State using the subfields from the Address Field.  

Can this be done? 

Photo of Sheena

Sheena

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 930 Points 500 badge 2x thumb
Yes - the subfields can be used in the filters (and dynamic filters) for the report.

Say the Address field is called [Address].

Then the subfields would be called [Address: City] and [Address: State/Region].

You can use those subfields in the filters (and dynamic filters) - just like other fields.
Photo of Sheena

Sheena

  • 0 Points
Thank you Xavier!  This helps tremendously.
Photo of Xavier Fan

Xavier Fan, Champion

  • 930 Points 500 badge 2x thumb
Great - glad it helped!
Photo of Juan

Juan

  • 480 Points 250 badge 2x thumb
Works