ONE TABLE, HEADER ON TOP
The first row with names in it is the header. Every row under it is one record: a sale, a ticket,
a month for one region. A total row at the bottom is spotted and left out, so it is never counted twice.
DATES
2026-03-31, 31/03/2026, 03/31/2026, Mar 2026, 31 Mar 2026 and Q1 2026 are all read. When a date like
03/04/2026 could be either way round, Vantage reads the whole column to decide, and asks you when it cannot tell.
NUMBERS
Currency signs, thousands commas, percent signs and (1,200) for a negative are all understood. A cell that
is not a number is left blank and counted, never quietly turned into zero.
AVERAGES ARE NEVER ADDED UP
A column whose name says average, rate, percent, score, price or per, or whose values are all fractions,
is averaged. Adding up last month’s 4.2 and this month’s 4.6 rating gives 8.8, which means nothing.
IDS AND YEARS ARE NOT AMOUNTS
An order number or a customer id is a label, not a quantity, so it is never totalled. A Year column is used
to group by, never added up.
THE TIME STEP
Vantage picks day, week, month, quarter or year so the trend has between 8 and 60 points. You can change it
in Filters.
A PERIOD THAT IS NOT OVER
If the last period holds clearly fewer days than the others, it is still shown but left out of the
comparison, so a half month is never reported as a fall.
CHARTS THAT DO NOT LIE
Bars always start at zero. A trend line needs 8 points, so fewer are shown as bars. Share of total is
only drawn for amounts that add up, for 2 to 6 groups, and there are no pie charts.
TOP 10, AND THE REST
A category with more than 10 values shows the top 10 and an Other bar holding everything else, so the
bars still add up to the whole.
YOUR LAYOUT
Every change you make to the tiles is remembered on this device for files with the same column names. Save
it as a file to use it on another computer or to give a colleague the same report.
WHAT IT WILL NOT DO
One table at a time, no live link to a database or a private Google Sheet, and no forecasting. A
dashboard shows what happened; it does not predict what comes next.