Explore the data
Discover is the magnifying glass of Advanced Reports. In it, collections appear one by one, with all their answers, and can be searched, filtered and organized in columns. It is the place to answer specific questions ("which Site A audits scored below 60 this month?"), check whether a collection arrived and understand how each field was recorded before building a chart.
Before any dashboard, spend a few minutes in Discover. It shows which fields exist, their types, which values appear most often and whether the data for the period is complete. It is also the first place to look when a number in the dashboard seems odd.
Open Discover
- Open ☰ → Analytics → Discover.
- In the top left corner, choose the data source.
- In the time picker (calendar icon), choose a range that covers the collections you want to see, for example Last 30 days or Last 1 year.
Screen layout
| Area | Where it is | What it does |
|---|---|---|
| Data source selector | Top left corner | Chooses which forms the collections come from. |
| Search bar | Top | Filters collections by an expression. See Search bar. |
| Filters | Below the search bar | Field filters shown as pills. See Filters. |
| Time picker | Right of the search bar | Defines the date range. See Time range. |
| Field list | Left column | All fields of the data source, with name search and type icon. |
| Histogram | Above the table | Number of collections over the period. Clicking and dragging over it narrows the range. |
| Records table | Center | One row per collection, newest first. |
Find a field and see its values
- In the field list, type part of the name in the search (for example,
perc). - Click the field name. A summary appears with the most frequent values in the period's collections and the share of each.
- Next to each value, the + and − icons create a filter to show only that value or to exclude it.
- The Visualize button opens the chart editor with a chart ready for that field.
The field summary shows how options were recorded: "No" or "no", "Rejected" or "Reject". Copy the value exactly as it appears to use in filters and formulas.
View a complete collection
- In the table, click the expand icon (arrow or double arrow) at the start of the row.
- A side panel shows all fields of that collection, in two tabs:
- Table — one field per row, with name and value.
- JSON — the complete record, in the format it is stored.
- For each field, icons let you filter by that value, exclude it or add the field as a table column.
Build a column table
By default, the table shows a summary of each collection. To see only the fields you need:
- In the field list, hover over the field and click + (Add field as column).
- Repeat for the other fields.
- Drag the headers to change the column order.
- Click a header to sort (for example, by score, lowest first).
- To remove a column, use the header menu.
Save a search
A saved search keeps the data source, search bar, filters, columns and sorting.
- Click Save at the top.
- Give it a descriptive name, for example "Audits below target – detail".
- Click Save.
A saved search can be reopened in Discover and added to a dashboard as a collections table, which follows the dashboard filters and time range. See Add content to the dashboard.
Export collections as CSV
- Build the search with the desired columns, filters and time range.
- Save the search.
- Click Share (or Export) and choose the CSV export.
- When the file is ready, a notification offers the download.
The file contains the table columns. If no column was chosen, it contains every field.
Exports with many collections are generated in the background and may take a few moments. Limit the time range and columns to what you need to generate the file faster.
Check field types
Before building charts, check in the field list that each field has the expected type:
- Scores, points, percentages, temperatures and weights should appear with # (number).
- Site, region, shift, owner and status should appear as text (k or t).
- Dates entered in the form should appear with the calendar icon.
A numeric field that appears as text cannot be summed or averaged. In that case, review the question type in the form. See How each question type reaches the reports.
Use Discover to check data
When a dashboard number seems wrong, Discover shows at which step the difference lies:
| In Discover, with the chart's data source, time range and filters | Meaning | What to do |
|---|---|---|
| The collection doesn't appear | The collection didn't reach the index | Check that the app synced, that the form is integrated and that the time range includes the collection date. |
| The collection appears, but without the field | The question wasn't answered, has no name or isn't enabled for export | Review the question in the integration. |
| The field appears with another name | The question was renamed after earlier collections | See Question name. |
| The field appears as text instead of number | The question type isn't numeric | Adjust the question type in the form. |
| The collection appears with the correct field | The difference is in the chart | Review the calculation, the chart filters and the chart's own time range, if any. |
Many "missing collections" are simply outside the selected range. Before investigating, widen the range (for example, Last 1 year) and remove the filters. Then narrow it down until you find the point where the collection disappears.
In a dashboard chart's menu (⋯), the Explore in Discover option opens Discover with that chart's data source, time range and filters already applied.