Past data shows real done dates, future data shows estimated done dates. Having a clear line in between would help understand the graph better.
Thanks!
Edit:
A better solution would be to allow “Today” in annotation editor.
This is definitely helpful (at least in my experience) in allowing the viewer/consumer of a report to visually decide where to look in the shortest amount of time possible, reducing false readings/decisions, and there increasing adoption and consumption of reports across an organisation to make decisions.
Reference points/lines/bands
I usually call them references (milestones), since they are basically usually-constant-and-global reference points on the axis of a time or numerical series. And depending on the reporting tool they can be represented as points on an axis, a line across it, or even a shaded (low opacity) band across the axis if the reference is a range.
But for example Google Analytics calls them annotations, which are points along the axis. Tableau calls them reference lines and bands, since annotations are something else in Tableau.
Examples
Here are some of my examples from past uses, all of which are meant as a visual aid to the person reading the reports.
Time series
- Today: separate past vs. forecast or planned data.
- Period Boundary: start and/or end of quarter, fiscal year, or other periods.
- Important Events: e.g. launch, incident, acquisition, management change, world events.
Number/Currency/Percentage
- Critical Threshold: buffer or non-zero cut-off between good/bad, pass/fail, e.g. a line at value 15 for “event start delay” to indicate that meetings that starts with more 15 minutes of delay are the problem, and not the rest.
- Upper/Lower Limit: acceptable range boundaries e.g. target temperature range in manufacturing or variance limits in budgets.
- Target/Goal Value: e.g. 20% profit margin.
- Compliance Limit: benchmark, regulatory or contractual (e.g. SLA) thresholds.
- External Benchmark: external comparative points shared across datasets, for example industry, market numbers.
I think most of this is already possible!
I’m honestly playing more and more with reports right now than I usually do, but check this out:
Setting annotations on specific dates is possible (although not from a database, its hardcoded into the report)
And annotations on the Y axis also seem to be possible, but I haven’t gotten to using them use them yet. But I think it’s in line with what you’re asking for!
1 Like
Wow, thanks. I always search the docs; I must have completely forgotten to do so when I could not find the annotations in the reports. 
Now, I see. So, in effect, you would want a formula that returns now or today in the dialog box below, to make the time series annotations dynamic/formula-based?
Exactly right!