Analytics datasets

Datasets within Analytics

You can run reports against any of the datasets within analytics by building a custom chart, or you can use the chart library to use pre-built views of these datasets.

Most datasets support a standard set of dimensions. Dimensions (also known as breakdowns or groups) typically include area, site, inspection type, division, parent division, parent inspection type, staff group and date.

1. Inspections

This dataset includes all completed inspections. There is one record for each inspection completed. It does not include draft inspections.

This can be used for calculating number of inspections and inspection scores.

2. Deadlines

A deadline is a scheduled inspection for an area and an inspection type. If the inspection is completed by the designated time, it is marked as "met".

This dataset can be used to report on whether scheduled inspections have been completed.

3. Answers

Each inspection consists of multiple answers. This dataset includes every question that was asked, including where the question was answered N/A or was a non-scoring question.

This can be used to report the average score by question and the response rate (% of N/A) per question.

Where the sets functionality has been used in Tendable (where a question is asked multiple times), this dataset only includes the overall score for the question. 

For example, if a question has 10 sets associated with it and there are 5 'yes' responses and 5 'no' responses, this would be represented as a single answer with a score of 50%. To see these broken down into individual responses, use the 'Sets' dataset.

4. Actions

This dataset includes all actions which have been created in Tendable. It includes not yet written, in progress and completed actions. It does not contain archived actions.

This can be used to report various metrics related to actions, such as the number of outstanding actions, or the number of actions created or completed in a time period.

By default, there are no filters applied on actions, which gives you the flexibility to report on these as required. You should use the custom filter functionality to add filters to actions based on the question that you are trying to answer. 

For example, if you wish to report on outstanding actions add a filter that is linked to the status field on the actions dataset. If you wish to report on actions by time period, add a filter linked to the created or completed time columns in the actions dataset. Note that some charts from the chart library will automatically apply these filters.

5. Issues

Issues are created when a question is answered negatively, and remain open until the question is answered positively per inspection type per area.

This can be used to report the number and nature of issues which are occurring, optionally filtered by status or time period opened.

By default, there are no filters applied to issues. You should use the custom filter functionality to add filters to issues based on your desired output. 

For example, you can filter unresolved issues by filtering on the resolved field. You can filter by issue start date by adding a filter to the issue start date field. Note that some charts from the chart library will automatically apply these filters.

6. Tags

If your organisation uses the tagging functionality, you can report about scores by tag using the tag dataset. This is similar to the answers dataset (see above), except that each answer can be assigned to one or more tags. It only includes scoring questions.

You can use this to calculate the average score per each tag and group tag.

Due to the large amount of processing required to calculate the score per tag, running reports on this dataset can be slow. To receive faster results, we recommend filtering for shorter periods of time.

7. Sets

This dataset gives the individual answers to questions that have been asked using the sets functionality. For example, if a question exists in a category which is asked 20 times, there will be 20 rows contained in the sets dataset - one for each answer (including non-responded).

This can be used to get a breakdown of the number of responses to a question.

This dataset does not include answers to questions which are asked individually (not in a set).