Skip to main content

A figure in Axi's answer now explains itself

Click a figure in one of Axi's answers and read what it is, how it was counted, the rows behind it and what makes it up — worked out from your metric's own definition and read live from your data, never written by Axi, so the explanation can't disagree with the figure. And when you want more, ask Axi about that figure in one click.

What changed​

  • What it means, in plain words. Under the line a figure came from: your metric's description, then a sentence worked out from its definition — revenue is the sum of amount over the rows of orders, keeping only the rows with status: paid — and what the figure covers: its line, the read's conditions, its dates. If the definition changed since the answer, a line says so.
  • Where it stands. Its rank among the lines it was read with, how it compares with the top one and, for sums and counts, its share of their total.
  • How it was counted. Under Behind this figure: every row of the metric's table, then the rows each condition keeps, step by step, down to the figure recomputed from your data now — and whether it still matches the answer.
  • The rows behind it. The records the figure was computed from, newest first, with how many there are, their first and last date and, for a sum, their average. Open as a table shows them fifty at a time.
  • What makes it up. The figure split by another field — by channel, by store, by month — each part with its share of the whole. Pick the field from the list. For an average or a ratio, each part's own figure, the parts with the most rows first.
  • Ask Axi about this figure. One click sends Axi a question with the figure attached as its details show it, and a chip over your question names it. For a figure from a query Axi wrote itself, it's the way to have it explained.
  • Never written by Axi. Every block but the last is worked out from the definition that produced the figure, or read with it under your own rights. Nothing is saved, and nothing is read until you unfold it.

📖 Where Axi's numbers come from · Have a number explained · The numbers in Axi's answers