Skip to main content

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:

  1. Form — questions receive a question name (a short name without accents), which becomes the field name in the reports.
  2. Integration — the form is enabled for Hashdata Advanced Reports, and each submitted response is automatically copied to a collection base called an index.
  3. Data source — points to one or more indices and defines which date field controls the chart period.
  4. Charts — each chart calculates an indicator from the data source fields.
  5. Dashboard — brings charts, filters, text and links together on a single screen.
  6. Sharing — the dashboard is made available to the profiles that should see it, and can be exported or sent.
StepWhat it isWhere to configure
FormThe questions and calculated fields that generate the data.Form editor and the integration settings screen.
IndexThe collection base of a form. Each response becomes a record.Created by the integration. See Prepare the data.
Data sourceThe link between charts and one or more indices.Data sources.
ChartA calculated indicator (for example, the average compliance per month).Create charts.
DashboardThe screen with several charts, filters, text and links.Build dashboards.
Real-time updates

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.

Only integrated forms appear

Hashdata Advanced Reports only shows forms enabled for integration. If a form does not appear, check the integration settings.


Accessing Advanced Reports​

  1. In Hashdata's main menu (left sidebar), click the Hashdata Advanced Reports icon.
  2. Advanced Reports opens in its own area, with its own menu (☰, top left corner).
  3. 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.
  4. 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 screenIn this documentationWhat it is
DiscoverExploreScreen to view collections one by one, with search and filters.
DashboardDashboardScreen with several charts, filters, text and links.
Visualization / PanelChartEach block of the dashboard: chart, card, table, text.
Data viewData sourceThe link between charts and one or more indices.
IndexIndex (collection base)Where the responses of an integrated form are stored.
FieldFieldA question, calculated field or collection data.
Document / RecordRecord (collection)One submitted response.
Horizontal axis / Vertical axisHorizontal axis / vertical axisThe chart dimensions.
BreakdownBreakdownSplits each bar or line by category.
Date histogramDate groupingGroups records by hour, day, week, month or year.
Top valuesTop valuesGroups by the most frequent (or highest-scoring) values of a field.
Count of recordsCount of recordsNumber of collections.
Reference lineReference line (target)A fixed line over the chart, such as a target or a limit.
ControlsControls (dashboard filters)Selection lists at the top of the dashboard, such as Site and Region.
Calendar iconTime pickerDefines the date range analyzed.
Add filterFilter (pill)A filter by field, shown as a pill below the search bar.
Share / ExportShare / exportLink, 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:

NeedRecommended feature
Consolidated indicators, trends, rankings and comparisonsAn Advanced Reports dashboard
Check one specific collection, with all its answersExplore (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 deadlineAction Plan
Send collections to another systemREST API integration
Dashboards and automation work together

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​

  1. Prepare the form — standardized question names, calculated fields ready and integration active. See Prepare the data.
  2. Submit a complete test collection.
  3. Check the data in Discover: did the fields arrive with the right type (number or text)? See Explore the data.
  4. Confirm the form's data source, or create one if you are combining several forms. See Data sources.
  5. Define the indicators — write down, in one sentence, what each chart should answer ("what is the average result per month?").
  6. Create the dashboard and the charts, starting with the indicator cards. See Create charts and Chart types.
  7. Add the dashboard filters, from general to specific (Region → Site → Area). See Controls.
  8. Set the default period and save the dashboard with it. See Save the dashboard.
  9. Check the numbers against an export of the form.
  10. Share with the profiles that should see the dashboard. See Share and export.

In this section​

PageContent
Prepare the dataIntegration, index name, question names, question types, calculated fields, multiple forms and transposed index.
Data sourcesCreating data sources, combining indices, time field, field types, labels and formats.
Explore the dataDiscover: browse collections, build tables, save searches, export and check data.
Search, filters and time rangeSearch bar syntax, filter pills, time picker and the scope of each filter.
Create chartsChart editor, axes, groupings, breakdowns, multiple metrics, target lines and period comparison.
Chart typesBar, line, area, metric cards, gauges, tables, pie, treemap, mosaic, waffle, heat map and tag cloud.
Calculations and formulasCalculation functions, formulas, rates, share of total and variations.
Formatting and styleNumber formats, titles, labels, legends, axes and color by value.
Build dashboardsCreating and organizing dashboards, controls, collapsible sections, text, links and per-chart time range.
Share and exportProfile-based access, link, PDF, image, email delivery and data export.
Complete examplesDashboards built from scratch: 5S audit, multiple forms, survey rates, tank levels and defect counts.
Common errors and best practicesWhat you see, the cause and the fix, plus dashboard best practices.