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