Query Help for Cumulative Visits

Jennifer ParksStrack

I want to pull a report of constituents who visited in the last 2 years, but I'd like to see a total of how many times they visited. Is there a way to pull that into the report? I am still new to Altru and Queries. Thanks!

Debbie McKenzie

Hi Jennifer,

There is a "Total Number of Visits" Smart Field you can use in your query. Smart Fields live in the Administration Tab under "Data."  Click on Smart Fiields and then on the "Total Number of Vistits".  Then edit the parameters (under tasks, upper left on your screen) to pull just the last 2 years. Once you've edited the parameters you will need to "Start process".  Once the process is complete, go back to your query and add in the Total Number of Visits to your query.


You'll find Smart Fields are most useful.

Jennifer ParksStrack

This was super helpful, thank you!