topic Site Visits during a Time Period? in App Development

Site Visits during a Time Period?

Mon, 09 Oct 2017 17:31:59 GMT

Hi!

I have two database tables: one that holds visits to websites and another which contains a schedule of classes. I need to join the two tables so I can track the websites visited during a class period.

The website visits table has a time field for when the student visited the site. The Schedule table has a start and end time for each class period.

Any ideas on how I can accomplish this?

Re: Site Visits during a Time Period?

kuczynska — Wed, 11 Oct 2017 10:30:17 GMT

Hi,

You should probably consider using intervalmatch() to associate times from website tables and start/end times of class.

Have a look here - this pdf explains very well on how this could be done in QV; don't see a reason why this wouldn't work in Sense.

intevalMatch.pdf

BTW - there is a good Help article also in Sense on intervalmatch function use in the load script.