Hello
I wonder if anyone has a way of finding attendance numbers for a specific GEO area within a time period, I can get the constituent numbers from list manager and I have tried this with a list based filter in Tstats but it keeps crashing - does anyone know of another way to pull this data?
Many thanks
Mandy
This should give you an idea at least. Try something like this, in the list manager in manual edit. Just replace ## with appropriate id for the geo area from tr_geo_area system table and adjust the getdate () for the appropriate range.
select distinct a.customer_nofrom V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock) join LVS_NSCAN_ATTENDANCE b(Nolock) on b.customer_no = a.customer_nojoin T_ADDRESS c on b.customer_no = c.customer_no and c.primary_ind = 'Y' join TR_GEO_AREA d on c.geo_area = d.id where b.perf_dt between GETDATE()-7 and GETDATE() and d.id = ## -- past 7 days
Please test it. I only rattled if off quick and did not really check the results in quick test.
Travis
Hi Travis
I'll give this a go.
Thanks very much