Query Help for Cumulative Visits

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.