Scroll down for frequently asked questions
¶ Overview Excel
In Fixi it is possible to download the notifications to an Excel file. Below is the explanation of all columns in Excel.
The Excel can be downloaded via the blue button to the right of the filters.
Please note that excel does not contain any data from the reporter. This data is anonymized in Excel.
An admin user can optionally download the Excel with data
Most of the columns in Excel speak for themselves. Below we explain the more unclear columns.
¶ Reported with account
In this column it says TRUE or FALSE.
If it says TRUE, the report has been reported with an account
If it says NOT TRUE, the report has not been reported with an account.
¶ Extra field
If the extra field is used in the main category, you will find the value entered by the reporter here. Think, for example, of a number of a container or light tower.
If the extra field is not used, this column remains empty.
¶ First modified time
The first change time column shows the time when the report has had a change that is visible to the reporter.
This includes the following changes:
- Change of status
- Adding a comment
- Assigning the report to a practitioner, with a status change
This does not include:
- Change of description
- Adding a photo
- Adding the subcategory
- Change of main category
- Change of address
- Get notification from the card
- Assign the notification to a practitioner, without a status change
¶ Closed on
The closed on column shows the time when the notification was given a closed status. This can be a status of Completed, Rejected, or Deleted.
¶ Service standard handled
This column shows the service standard set for that category. For example, if it is set that for the category ‘Waste’ there are 5 working days to process the report, then there is a 5 in this column.
If no service standard is set, the column remains empty.
¶ Fixed within service standard handled
This column indicates whether the service standard has been met or not. If the notification is still open, the column remains empty.
Only in a closed state is TRUE or FALSE added to the column.
At WAAR the report is handled within the standard, at NOT WHERE it is handled outside the standard.
¶ Service standard first response
This column shows the service standard set for that category. For example, if it is set that for the category ‘Waste’ a first response must be given within 5 working days, then there is a 5 in this column.
If no service standard is set, the column remains empty.
¶ Response within service standard first response
This column indicates whether the service standard has been met or not. If the notification has not been responded to at all, this column will remain empty.
When responding, TRUE or FALSE is added to the column.
At WAAR there has been a response within the standard, at NOT WHERE there has been a reaction outside the norm.
¶ Application
The application column shows which application made the report. If it says Fixi website, the report was made via the website.
If it says Ionic, the notification has arrived via the app. Via the words IOS and Android you can still see whether the notification was made via an Android device or via an Apple.
¶ Channel
The channel column indicates which channel was used to create the notification.
This can be done via website, app (citizen-ios or citizen-android), handling app (handler-android fo handler-ios), telephone, social media channel, desk, etc.
¶ Item number
If your organization uses the module objects, you will find the number of the selected object here.
If objects are not used within the organization, this column remains empty.
¶ Integration number
If your organization uses a link with an external party (think of Nobralux/Moon or HVC), you will see the number that received the notification from the external party here.
If a link is not used within the organization, this column remains empty.
¶ Review
This column shows the rating that the reporter has given to a completed report.
The rating is on a scale of 1 to 5 with 5 being the highest and 1 being the lowest.
If no review is left, this column remains empty.
Please note, you can only see the review and feedback if you have the rights to do so. Ask the admin user to enable this permission.
¶ Feedback
This column shows the feedback on a review that the reporter has given to a completed report.
The feedback is a written response to the review.
If no rating or feedback is left, this column remains empty.
¶ Frequently asked questions
The frequently asked questions are still under development and will be updated in the coming period.