Content:
Basic requirement for the export
Advanced analytics subscription (contact Sales if you wish a demo)
Sensors for each workspace to be analysed (Room, Desk, Huddle)
Where does the data come from
The data for the export comes from the Sensors. We analyse only occupancy-data on working days between the working hours (These can be changed in the building details). Data outside this period is currently not taken into account. We calculate the usage of a workspace per day, if the sensor has times without occupation which are less than 15' we calculate it as occupied for the hole period. (e.g. usage between 8:00 until 9:00 and from 9:10 to 10:00 the usage for this period is 2h / if the break is from 9:00 to 9:20 the usage would be 1h 40')
How to export the data
Navigate to the Export section in the Portal (you need to Workspace-Manager or Admin to have access):
Select the month you would like to export (Only one month at the time possible)
Click to Export, your browser will download the .CSV file to your download folder
What is in the export
If you open the .csv you will get a list of all the spaces with some details from Column G on you will get a number for every day in this month.
Workspace ID = ROOMZ unique ID of the workspace
WorkspaceName = the name from the workspace (set in myOrganisation on the Portal)
WorkspaceType = What is this workspace, could be: ROOM; Desk or Huddle
WorkspaceTag = Tags set to the workspace
BuildingName = The name of the builiding (set in myOrganisation on the Portal)
FloorName = The name of the floor (set in myOrganisation on the Portal)
Date ex. 1.4.2024 = you will see here the number of hours a workspace is used (rounded to two decimal places)
If the field is empty: we do not have correct sensor data for this day
Could be because of a Network issue, the sensor will buffer the information and set it with the next communication. The calculation will be done later
If the field is a 0: the Workspace was not used in this day.