Learn · Analysis · Lesson 2 of 7
Group and filter a summary
You willCompare groups side by side and count how many are over or under a value, for only the rows you choose.
Time3 min
Why it mattersThe median of every school says little; the median of primary schools against high schools says a lot.
Try it in Plotlay → Opens Plotlay with this lesson beside it. Nothing to install.
Steps
- Open a table in Analysis.
- In the strip, set by to a column such as level or state. A row per group appears under the strip with its count, median, mean, lowest, highest and total.
- Type a test in Only rows where…, such as level = "Primary" or students > 100, and press Enter. The strip and the rows show only the rows that pass.
- Type a value in Count under or over to count how many are below or above it, with their share.
- Choose Copy numbers to paste the groups into a spreadsheet.
Tips
- Tests use the same words as formula columns: and, or, not, in ("NSW", "SA"), = and != for text, < and > for numbers.
- A column name with spaces goes in square brackets: [floor area] > 500.
Common mistakes
- Typing text without quotes: level = Primary looks for a column called Primary. Write level = "Primary".
Words in this lesson
- Quote and revision
- An estimate turned into a numbered price for a client, on your letterhead, with terms and a payment schedule. A change after it is sent is a new revision (rev B), so the sent copy stays as it was.
Related lessons
Add a table and read its numbersPaste a table from Excel or open a file, then read its count, median, mean, highest and lowest at a glance.2 minSummarise a data layer over timeRead a coloured data layer’s numbers beside the map, and watch them change as the time slider moves.3 min
Steps checked in the app on 8 November 2026.