Common errors and best practices
Most odd numbers in a dashboard have a simple cause: a different field name, a calculation chosen automatically, a time range that isn't what it seems or a forgotten filter. This page lists what usually appears on screen, the reason and the fix, plus the best practices that prevent these cases from the start.
Common errors and fixes
Data and fields
| What you see | Cause | Fix |
|---|---|---|
| The form doesn't appear in Advanced Reports | The form is not enabled for integration. | Enable the Hashdata Advanced Reports integration. See Enable the integration. |
| A collection doesn't appear in the dashboard or in Discover | The collection hasn't synced yet, or is outside the selected time range. | Confirm the sync in the app and widen the time range. |
| A question doesn't appear in the field list | The question has no name, isn't enabled for export or hasn't been answered in any collection. | Review the integration, submit a test collection and reload the page. |
| The same question appears as two fields | The question was renamed after the first collections, or the combined forms use different names. | Standardize the names. To reprocess the history, contact Hashdata support. |
| A section's results appear under another section's name | Question names out of place relative to the questions. | Check the names in form order. See Question name. |
| Average or Sum can't be chosen on a score field | The field arrived as text. | Change the question type to number and submit a new collection. |
| A text field can't be used in Top values | The free-text version of the field was chosen. | Use the .keyword version. |
| Negative or absurd values (weight -80, temperature 400) | Entry error in the collection. | Fix it at the source. To avoid distorting the chart, filter the valid range (for example, weight >= 0). |
| Every defect type has the same count | Transposed index with Count of records. | Use Sum of the value field. See Transposed index. |
| The sum of options is greater than the total collections | Multiple-choice question: each collection counts once for each selected option. | Expected behavior. State in the title that the question is multiple choice. |
| A filter finds nothing | Value spelled differently (case, accents) or a field name with a capital letter. | Copy the exact value from the field summary in Discover. |
Calculations
| What you see | Cause | Fix |
|---|---|---|
| The dashboard value doesn't match the report | The editor chose Median, and the report uses the average. | Change the function to Average. See Average or median. |
| Bars at 300%, 400% or 500% | Percentages added in stacked bars. | Use Unstacked or Line. |
| Percentage shown as 8,500% | Percent format on a value already in 0–100. | Use Number with the % suffix. |
| Percentage shown as 0.85% | % suffix on a value in 0–1. | Use the Percent format. |
| Empty card or "–" | No collections in the time range, or the formula divides by zero. | Check the card's time range and filters. |
| Last value appears empty | The most recent collection doesn't have the field filled in. | Use last_value(field, kql='field : *'). |
| Formula error with a hyphenated field | The hyphen is read as subtraction. | Put the name in single quotes: average('perc-total'). |
| Error in the filter inside the formula | Quotes swapped. | Filter in single quotes, values in double quotes: count(kql='status : "Rejected"'). |
| Site with a single collection ranked first | Ranking ignores the number of collections. | Show the number of collections next to it or widen the time range. |
Charts and dashboards
| What you see | Cause | Fix |
|---|---|---|
| Thin, widely spaced bars after filtering | Date interval set to Auto, recalculated with fewer collections. | Fix the Minimum interval (for example, Month). |
| Chart with two vertical axes by accident | Metrics with different formats. | Use the same Value format or Axis side: Left in all of them. |
| Axis title with "per month" or another addition | Automatic axis title. | Use Axis title → Custom on the axis button. |
| "Other" group in the ranking | Group remaining values as "Other" is on. | Turn it off and increase Number of values. |
| Only 3 or 5 categories appear | Number of values at its default. | Increase the number of values. |
| Empty future months in the chart | This year range, which runs to December 31. | Use Year to date or rounding to the year. |
| "Year to date" doesn't appear in Commonly used | The shortcut is not in your account's list. | Use Last 0 years rounded to the year. See Time range. |
| A chart doesn't change when the dashboard time range changes | Chart with its own time range. | Check ⋯ → Settings → Apply custom time range. |
| A chart doesn't change, or becomes empty, when an option is selected in a control | The chart uses a data source without the control's field. | Standardize the field name across data sources or move those charts to another dashboard. |
| A control list doesn't show every option | Chained controls: the list follows the selections of previous controls. | Expected behavior. Clear the previous controls to see every option. |
| The dashboard opens with another time range | Dashboard saved without Store time with dashboard. | Save again with the option selected. |
| The dashboard opens with an unexpected filter | Filter or control selection active when saving. | Clear the filters and save again. |
| Changing a chart changed another dashboard | The chart is in the library and is used in several dashboards. | Use Unlink from library in the dashboard that should have its own version. |
| Slow dashboard | Many charts, long time ranges or many map points. | Use collapsible sections, shorter default ranges and clustering in maps. |
| Someone can't open the dashboard link | Their profile doesn't have access to the dashboard. | Ask the account administrator for access. |
Best practices
Data
- Prepare the form before the dashboard — standardized question names, correct types and calculated fields ready.
- Define names before collecting — renaming later splits the same question into two fields.
- Calculate complex rules in the form — the dashboard gets simpler and the numbers match the reports.
- Check in Discover — every change to the form deserves a test collection and a check.
Dashboard
- Start with the question — each chart answers a question written in one sentence.
- Top-down hierarchy — indicators at the top, trends in the middle, detail at the bottom.
- 10 to 12 charts per screen — beyond that, use collapsible sections or split the dashboard.
- One dashboard per audience — operators, supervisors and executives need different views.
- Suitable default range — today, 7 days, 30 days or year to date, depending on use, saved with the dashboard.
- Filters from general to specific — Division → Region → Site.
- Supporting text — a text block explaining the target and colors helps readers from other areas.
Charts
- Choose the function on purpose — average, median, sum or count, never the automatic choice without checking.
- Fix the interval in closing charts.
- Context for every number — target, color by value or comparison with the previous period.
- Few series — up to 5 to 7 lines or colors per chart.
- Same scale for the same kind of indicator (percentages from 0 to 100).
Names
- Dashboards: Area – Objective – Audience. Example: "Quality – Nonconformities – Management".
- Charts: what they show, with the unit and, if needed, the time range. Example: "Nonconformities by Line (occurrences) – last 30 days".
- Data sources: the form or set of forms. Example: "Best Practices – All Divisions".
Step-by-step checklist
- Form — question names following the standard, correct types, calculated fields, identification questions (site, region) and integration active.
- Test collection — complete, submitted and synced.
- Discover — check fields, types and option spelling.
- Data source — confirm the form's one or create a new one (several forms, another time field).
- Indicators — list the questions the dashboard should answer and the audience.
- Cards — the main indicators, with format, color by value and, if needed, their own time range.
- Trend and comparison charts — fixed interval, function checked, target line.
- Detail — rankings, colored tables and a saved search for cases requiring action.
- Controls — from general to specific, with readable labels.
- Finishing — titles with units, legends, axes and supporting text.
- Save — with Store time with dashboard and without test filters.
- Check — dashboard totals against a form export, with and without filters.
- Share — make it available to the right profiles and send the link.