Task by Task · Free local practice
Stop an AI trend chart from connecting missing months
Fictional monthly series; native calculated graphic. This example runs locally; files selected here stay in browser memory.
Keep a gap different from zero
- January 12
- February observed 0
- March unavailable; April 18; May 16
Ask AI to preserve absent observations and explain any connecting line. A missing month is not evidence of zero requests.
Take the technique to your next job
Chart this supplied monthly dataset in chronological order.
Unit: [actual unit]. A blank means [source meaning]; zero is a valid
observed value. Show missing periods explicitly and break the line
at unavailable observations. Do not replace blanks with zero, join
across them or interpolate unless I explicitly request a labelled model.
Explain observed values and limits without inventing missing months,
causes or a continuous trend. Include the source table and actual file/source.