4/ 10Nordwind Travel Goods (fictional)
How much revenue does each channel make per month?
Then
How many tasks per board are in which status?
Orders · Rows channel, columns month, sum of revenue · Largest value: online shop in November
Pivot analysis · Preview
Rows, columns, measure:
your question as a pivot.
The pivot evaluation is the core of Peak Analytics. You pick a source, decide what goes into rows and what into columns, and which measure is calculated: count, sum, average, minimum or maximum, on a grid from day to year.
Build a sample pivotIn the preview for orders, receipts, tasks, goals and files. Sample numbers on this page are fictional.
EXAMPLE / PREVIEWRows, columns, measure:
Rows, columns, measure:
your question as a pivot.
01 / Example value
Which question would you build as a pivot first?
02 / What the evaluation showsHow much revenue does each channel make per month?
Orders · Rows channel, columns month, sum of revenue · Largest value: online shop in November
Change the example value. The finding follows the value.
Fictional example · no real data
One question. Two evaluations.
Rows, columns, measure:
your question as a pivot.Compare both evaluations below ↓
your question as a pivot.Compare both evaluations below ↓
Two sample questions
Which question would you build as a pivot first?
What goes into the rows, what into the columns?
10/ 10Lindgrün Agency (fictional)
How many tasks per board are in which status?
Tasks · Rows board, columns status, count · Largest value: board “Relaunch”, in progress
Honest about the status
What this page promises and what it does not.
01 / What is settled today
Preview
Peak Analytics is a preview. You can evaluate orders, receipts, tasks, goals and files, not arbitrary external data.
- 4/10How much revenue does each channel make per month?Orders · Rows channel, columns month, sum of revenue · Largest value: online shop in November
- 10/10How many tasks per board are in which status?Tasks · Rows board, columns status, count · Largest value: board “Relaunch”, in progress
02 / Your control
Fictional examples
Businesses and numbers on this page are made up and marked as examples. None of it is a measurement or a customer result.
4 / 1010 / 10
Compare both evaluations and their reasons.
03 / The clear limit
Your data stays where it is
The website reads no data from your workspace. Evaluations only happen in Peak Analytics, with your permissions.
End of example│Nothing saved
Your next step
One question, one table.
Build the sample pivot and see how rows, columns and measure add up to an answer.
Build a sample pivotPivot analysis · PreviewHow much revenue does each channel make per month?
In the preview for orders, receipts, tasks, goals and files. Sample numbers on this page are fictional.
Frequently asked questions
Is Peak Analytics finished?
Peak Analytics is available as a preview. What this page describes as available exists in the preview; examples with company names and numbers are fictional.
Which calculations are there?
Count, sum, average, minimum and maximum. Date fields are grouped by day, week, month, quarter or year.
What happens to empty fields?
Empty, null and missing stay distinct. They don't silently drop out of the sum.
What if a source is very large?
Then Peak Analytics evaluates a cut-out and marks it as such, so you don't mistake part of the data for all of it.
Can I save a pivot?
Yes. A saved evaluation is a saved view; the question lives in its address, so others work with the same definition.