A zero is a measured value under a stated definition. A blank may represent unavailable data, an excluded record or a value the report does not display. A missing period is a completeness question. Treating all three as zero can create a false trend.
This distinction matters most when the newest month is incomplete. A dashboard comparison can imply that activity collapsed when the actual issue is that the period has not been supplied or accepted.
Ask what the display represents
Check the source field and reporting rule. Is zero present in the accepted source? Is a blank intentionally suppressed? Does the date range extend beyond the latest completed period?
Keep the answer visible to the reviewer. A clean looking chart should not conceal a missing month that changes its interpretation.
Use completed periods for comparable reviews
Select periods with the coverage required by the question. If the latest period is partial, label it as partial and describe which properties or sources are outstanding. Do not compare it with a completed period without explaining the difference.
In a fictional production example, August contains 10,000 units while September has not yet been loaded. A displayed September zero would suggest a 100% decline. The useful conclusion is that September is unavailable, not that production stopped.
Preserve legitimate zeros
Some wells can have a valid zero under the accepted production definition. Some expense categories can have no activity in a completed period. Suppressing every zero would hide meaningful operating conditions.
The correct rule depends on the measure and source. Discuss whether empty rows should be shown, and keep the distinction between a zero value and an absent record intact.
Carry completeness into the summary
Include the last accepted period, population coverage and unresolved gaps with the review. A saved dashboard snapshot needs enough context for a reader to know whether its comparison remains meaningful.
Upstream+ date filters and views let the team focus a review on the relevant scope. The team still needs to establish which periods are complete and what each display state means.
The first question about an unexpected zero is simple: did we measure zero, or do we lack the measure?
Research and references
These sources offer background for the review question. The worked examples and review methods above are Upstream’s practical guidance.
- A Survey of Data Quality Measurement and Monitoring ToolsEhrlinger & Wöß · Frontiers in Big Data · 2022 · Peer-reviewed systematic review · Open access
Further reading on profiling, quality measurement and monitoring.
- Beyond Accuracy: What Data Quality Means to Data ConsumersWang & Strong · Journal of Management Information Systems · 1996 · Peer-reviewed research
Research perspective on evaluating data quality beyond accuracy.
Common questions
Can an empty month be interpreted as a production decline?
Not until its completeness and source state are confirmed. An absent record is not evidence of zero activity.
Should every zero be hidden?
No. A valid zero may be operationally meaningful. Distinguish it from missing or unavailable data.
Put the question to work
Explore the connected workflow for reporting practice or bring your well data question to a working session.