Snapshot vs. time series 2.0
About this app
Rebuild 2.0 (preview): the slide says “A ahead” — opening the look-back morphs the bars into lines and the trend verdict flips. Prior month vs. same month last year, crossings, stock vs. flow.
Level and trend
A snapshot shows a value at one point in time, typically a slide with two bars for “today”. A time series shows how the number got there. Level and trend are different pieces of information: whoever leads today may have been losing ground for months. With seasonal data, month-on-month comparisons mislead; the same month last year is the fair benchmark. Growth rates depend on their base (base effect). And a stock such as subscribers can hit a record while the flow, new sign-ups per month, collapses.
What the app shows
Four simulated scenarios, each with two series over 48 months: trend reversal, seasonality, base effect and stock vs. flow. The top card shows the values, as two bars when the window is “now only”. Widen the look-back to 6, 12 or 24 months and the bars morph into lines. A lower card shows the change per month, either month-on-month or year-on-year. Figures such as change within the window and the average trend per month (least-squares slope) complete the picture, and crossings are marked.
Things to try
In the seasonality scenario it is December: compare a 6-month with a 12-month look-back and switch the lower card to year-on-year. In the base effect scenario the slide reports +50 %; extend the window beyond one year and check what that gain is measured against. In stock vs. flow, watch the stock keep rising as long as net additions stay positive, even while they shrink.
Frequently asked questions
- What is the difference between a stock and a flow variable?
- A stock is measured at a point in time, such as subscribers, inventory or debt at month end. A flow refers to a period, such as new customers or revenue per month. The change in a stock equals its net inflow, which is a flow.
- What is a base effect in statistics?
- A base effect occurs when a growth rate is calculated against an unusually low or high reference value. After a slump, even a partial recovery produces high rates: +50 % on 60 gives 90, which can still be below the earlier level.
- Why compare seasonal data year-on-year?
- Seasonal series rise and fall in a regular yearly pattern, for example with holiday shopping. A month-on-month comparison then mostly measures the season. The same month last year sits at the same point in the cycle; a seasonally adjusted series is better still.
- How does this version differ from the first one?
- This version combines both views in one scene: as you widen the look-back, the snapshot bars turn into lines. It adds a switch between month-on-month and year-on-year change, marked crossings and a stock vs. flow scenario. All data are simulated.
Subject: Data & decisions
More from Data & decisions
- Anchoring effect
- Benford's law
- Berkson's paradox
- Cherry-picking: base period
- Cherry-picking: base period 2.0
- The three-cowboy duel (truel)
- The three-cowboy duel 2.0
- The three means
A VisuApp by heyprof: interactive, free in your browser, no sign-up. What is a VisuApp? · All apps