Advanced Reports
Advanced Reports turns form responses into indicator dashboards that update on their own. Every audit, checklist, inspection or survey sent from the app reaches the dashboard within moments, without exporting spreadsheets, copying data or building reports by hand. Managers open the dashboard and see, in one place, the month's result, the trend over the year, the ranking of sites and the points that are below target. Choosing a site, a supervisor or a period recalculates every chart instantly.
Dashboards are built by the people who know the operation, with no programming. Charts are created by choosing fields and calculations on screen: average, sum, count, percentage, comparison with the previous month. A single form can feed one dashboard for operators, another for supervisors and another for executives, each with the indicators that matter to that audience. The result is a single, reliable view of the operation: every area looks at the same numbers, calculated the same way, from the data collected in the field.
Hashdata Advanced Reports is Hashdata's dashboard and analytical reporting module. It automatically receives the responses of integrated forms and lets you:
- Explore collections one by one, with search and filters.
- Create charts: bars, lines, indicator cards, gauges, tables, heat maps and more.
- Build dashboards with several charts, interactive filters, text and links.
- Share and export dashboards as a link, PDF, image or spreadsheet.
How it works
The data travels from the field to the dashboard in six steps:
- Form — questions receive a question name (a short name without accents), which becomes the field name in the reports.
- Integration — the form is enabled for Hashdata Advanced Reports, and each submitted response is automatically copied to a collection base called an index.
- Data source — points to one or more indices and defines which date field controls the chart period.
- Charts — each chart calculates an indicator from the data source fields.
- Dashboard — brings charts, filters, text and links together on a single screen.
- Sharing — the dashboard is made available to the profiles that should see it, and can be exported or sent.
| Step | What it is | Where to configure |
|---|---|---|
| Form | The questions and calculated fields that generate the data. | Form editor and the integration settings screen. |
| Index | The collection base of a form. Each response becomes a record. | Created by the integration. See Prepare the data. |
| Data source | The link between charts and one or more indices. | Data sources. |
| Chart | A calculated indicator (for example, the average compliance per month). | Create charts. |
| Dashboard | The screen with several charts, filters, text and links. | Build dashboards. |
Once the integration is active, every submitted response automatically feeds the dashboards. Nothing needs to be exported, imported or refreshed by hand. Collections made offline enter the reports as soon as the app syncs.
Hashdata Advanced Reports only shows forms enabled for integration. If a form does not appear, check the integration settings.
Accessing Advanced Reports
- In Hashdata's main menu (left sidebar), click the Hashdata Advanced Reports icon.
- Advanced Reports opens in its own area, with its own menu (☰, top left corner).
- In the ☰ menu, the most used items are in the Analytics group:
- Discover — explore collections one by one. See Explore the data.
- Dashboards — open and create dashboards. See Build dashboards.
- Visualize Library — library of saved charts to reuse in several dashboards.
- Data sources are created in ☰ → Stack Management → Data Views. See Data sources.
Access to the module and to each dashboard is defined by profile. If you don't see the icon or a dashboard you should see, contact your account administrator.
Screen terms
The Advanced Reports interface uses English names. This documentation uses the following terms, always alongside the name shown on screen:
| On screen | In this documentation | What it is |
|---|---|---|
| Discover | Explore | Screen to view collections one by one, with search and filters. |
| Dashboard | Dashboard | Screen with several charts, filters, text and links. |
| Visualization / Panel | Chart | Each block of the dashboard: chart, card, table, text. |
| Data view | Data source | The link between charts and one or more indices. |
| Index | Index (collection base) | Where the responses of an integrated form are stored. |
| Field | Field | A question, calculated field or collection data. |
| Document / Record | Record (collection) | One submitted response. |
| Horizontal axis / Vertical axis | Horizontal axis / vertical axis | The chart dimensions. |
| Breakdown | Breakdown | Splits each bar or line by category. |
| Date histogram | Date grouping | Groups records by hour, day, week, month or year. |
| Top values | Top values | Groups by the most frequent (or highest-scoring) values of a field. |
| Count of records | Count of records | Number of collections. |
| Reference line | Reference line (target) | A fixed line over the chart, such as a target or a limit. |
| Controls | Controls (dashboard filters) | Selection lists at the top of the dashboard, such as Site and Region. |
| Calendar icon | Time picker | Defines the date range analyzed. |
| Add filter | Filter (pill) | A filter by field, shown as a pill below the search bar. |
| Share / Export | Share / export | Link, PDF, image and spreadsheet. |
When to use it
Use Advanced Reports when the question is about the set of collections: how much, how many, how it evolved, who is above or below target. For other needs, other features are better suited:
| Need | Recommended feature |
|---|---|
| Consolidated indicators, trends, rankings and comparisons | An Advanced Reports dashboard |
| Check one specific collection, with all its answers | Explore (Discover) or the form's own responses |
| React immediately to a response (notify, block, request approval) | Workflow and Automations |
| Handle a nonconformity with an owner and a deadline | Action Plan |
| Send collections to another system | REST API integration |
The dashboard shows how the operation behaves over time. Automation acts on each response as it arrives. A checklist can, for example, trigger a Work Order for every critical failure and, at the same time, feed a dashboard with total failures by equipment and by month.
Your first dashboard
- Prepare the form — standardized question names, calculated fields ready and integration active. See Prepare the data.
- Submit a complete test collection.
- Check the data in Discover: did the fields arrive with the right type (number or text)? See Explore the data.
- Confirm the form's data source, or create one if you are combining several forms. See Data sources.
- Define the indicators — write down, in one sentence, what each chart should answer ("what is the average result per month?").
- Create the dashboard and the charts, starting with the indicator cards. See Create charts and Chart types.
- Add the dashboard filters, from general to specific (Region → Site → Area). See Controls.
- Set the default period and save the dashboard with it. See Save the dashboard.
- Check the numbers against an export of the form.
- Share with the profiles that should see the dashboard. See Share and export.
In this section
| Page | Content |
|---|---|
| Prepare the data | Integration, index name, question names, question types, calculated fields, multiple forms and transposed index. |
| Data sources | Creating data sources, combining indices, time field, field types, labels and formats. |
| Explore the data | Discover: browse collections, build tables, save searches, export and check data. |
| Search, filters and time range | Search bar syntax, filter pills, time picker and the scope of each filter. |
| Create charts | Chart editor, axes, groupings, breakdowns, multiple metrics, target lines and period comparison. |
| Chart types | Bar, line, area, metric cards, gauges, tables, pie, treemap, mosaic, waffle, heat map and tag cloud. |
| Calculations and formulas | Calculation functions, formulas, rates, share of total and variations. |
| Formatting and style | Number formats, titles, labels, legends, axes and color by value. |
| Build dashboards | Creating and organizing dashboards, controls, collapsible sections, text, links and per-chart time range. |
| Share and export | Profile-based access, link, PDF, image, email delivery and data export. |
| Complete examples | Dashboards built from scratch: 5S audit, multiple forms, survey rates, tank levels and defect counts. |
| Common errors and best practices | What you see, the cause and the fix, plus dashboard best practices. |