Device count files provide the total number of devices in a region within a given time period and the average dwell for those devices.

Device count files can be requested for any given time period. Depending on the time period requested, the system will generate a single file the entire time period, a single file spanning the entire time period but separated into 1 hour windows, and day files for each 24 hour period starting from your specified start time. Files are in CSV format for easy import into business intelligence software.

For example if your requested export period starts at 2pm on 28/03/2023 and ends on 02/04/2023 the following files would be generated.

Hourly count file

• Event Name: 28-03-2023-14:00 02-04-23-14:00-hour-count.csv

Entire period file

• Event Name: 28-03-2023-14:00 02-04-23-14:00.csv

Day Files

• Event Name: 28-03-2023-14:00 29-03-23-14:00.csv
• Event Name: 29-03-2023-14:00 30-03-23-14:00.csv
• Event Name: 30-03-2023-14:00 31-03-23-14:00.csv
• Event Name: 31-03-2023-14:00 01-04-23-14:00.csv
• Event Name: 01-04-2023-14:00 02-04-23-14:00.csv

The Device Count screen will display all of the files that will be generated for you.

If you have Events created then an Events file will also be generated for you.

Output format

Entire period file and Day files

These files contain the region name, and its type, followed by the device count in that region and the average dwell in seconds

name,type,deviceCount,averageDwell(seconds)

Hourly count file 

Hourly files differ as they also include a ‘from time’ and a ‘to time’ for the hour period and do not include average dwell times

name,type,from,to,deviceCount

The from and to times are in YYY-MM-DDThh:mm:ss format, e.g. 2022-06-20T22:00:00

Events count file

Event count files include the event name, start and times as well as the region information, count and well

event,eventStart,eventEnd,name,type,deviceCount,averageDwell(seconds)

The eventStart and eventEnd times are YYY-MM-DDThh:mm:ss e.g. 2022-06-20T22:00:00