Skip to main content

Build Reports

A report answers "how is this project going" in numbers, such as samples by status, tasks overdue, records waiting on a sign-off, spend by supplier. It holds tiles that read from the project's records, with text between them like a note. Take a snapshot to keep that day's numbers for a lab meeting or a grant update.

Starting a Report

Reports sits under Essentials in the sidebar, after Slides, and Ctrl + 6 opens it. Each report's card shows its first four tiles with today's numbers.

New report opens Create a New Report. The templates are listed on the left, Blank report first, and Search templates... narrows the list by name and description.

The template you pick is drawn on the right as the report it will make, under Preview with this project's numbers, with a line counting its tiles by kind. Create report at the bottom makes it.

TemplateWhat it starts with
Blank reportAn empty report to fill with tiles and text
Project statusSamples, tasks and sign-offs counted, then broken down by status, with overdue tasks and the records awaiting sign-off
Lab meeting updateSamples collected, protocol and image analysis runs by status, tasks due this week, records awaiting sign-off, and a Discussion section. It counts since the last snapshot
Monthly lab reviewLast month's samples collected and runs completed, samples collected per month over the year, sign-offs decided per week, and spend by supplier
Quarterly progressThis quarter's samples collected, runs completed and sign-offs approved, protocol runs per month, and sections for progress on aims and next quarter
Sample intakeSamples added and collected in the last 30 days, samples in use, samples added per week, and image analysis runs per week
Lab operationsSpend per month in each currency, last month's spend by supplier, open orders, low stock, stock received and used per month, and stock used and written off in value, by reason and by item
Sign-off healthWhat awaits sign-off, what was decided and approved in the last 30 days, and sign-off asks per week by outcome
Instrument usageThis quarter's hours booked, bookings and cancellations, hours per week and per instrument, and tasks due this week
Planner progressThe last 30 days' tasks finished and added, the median days a task takes to finish, tasks finished per week, open and finished per week, finished per week by tag, and the overdue tasks and those due this week
Sample set progressOne sample set's members by status and which fields each one still needs. It asks which sample set before it starts
Stock and ordersOrders by status, spend by supplier, open orders, and stock at or below its reorder point
Protocol run summaryProtocol runs counted and by status, with tasks due this week

A template that reports on a span starts the report on its period, such as Last month for Monthly lab review. Change it with Period once the report is made.

A report is shared with the project when it is made. Folders, favorites, sharing, sign-off, Trash and search work as they do for notes, and a report always stays a report. Comments and sign-offs are in Activity, in the report's menu.

Adding a Tile

A report opens to be read. Press Edit in the top bar to change it, and Done editing when you're finished. A blank report opens ready to edit.

While you edit, a report's toolbar is shorter than a note's. It has Add tile, the insert button, undo and redo, text style, bold, italic and link. Press Add tile to place a tile under the line you're on. Add tile also leads the insert menu when you press + beside a line or type /.

The dialog box reads as a sentence, "Show Samples in This project as By status". Press any part of it to choose another, with a line under each option saying what it shows.

PartWhat you pick
ShowWhat to count, such as samples, tasks, records awaiting sign-off, sign-off asks, notes, protocols and reports, image analysis runs, protocol runs, orders, stock, stock movements, instrument bookings, or a data table's rows
inThis project, one of the project's sample sets by name for samples, or one of its data tables for data table rows
asHow to read it, such as Count, By status, Over time, Open and finished, Overdue, Due this week, Completeness or Spend by supplier

Some readings take more settings, shown under the sentence only when they apply.

SettingOffered onWhat it does
MeasureCounts and breakdowns of records with a number, such as samples, tasks, runs, orders, sign-off asks, bookings and stock movementsReads a number from each record, as the total, mean, median, lowest or highest of a field such as Hours to complete, an order's Total cost, a booking's Hours or a task's Days to finish, counted from when the task was added to when it finished
Split byCounts and Over timeBreaks the count down by a field, such as a sample's Species or a run's Protocol. A field with free text shows its 25 largest values. Over time draws up to 6 lines. A task splits by Tag or Assignee too, and one with two tags counts under each, so the parts add up to more than the total. Assignees are shown by name, and someone no longer in the project reads Former member
DateCounts, breakdowns and Over timeCounts what happened in a chosen span, such as samples Added or Collected, runs Started or Completed, orders Placed, tasks Finished, sign-off asks Asked or Decided, bookings that Start, stock movements Recorded
WithinTiles with a DateThe span the tile counts in, either a period such as Last 30 days or This quarter, or a custom range. The report's period follows the report's Period
ByOver time and Status over timeCounts per Day, Week, Month or Quarter. A tile draws at most its newest 120
OnlyCounts, most breakdowns, and Spend by supplierCounts only the statuses or kinds you pick. A task's statuses are its board's columns. Pick none to count them all
Only these tagsEvery task tileCounts only the tasks with at least one of the tags you pick, such as Bug. Pick none to count every task
Rows shownListsHow many records the list shows, 1 to 50. It shows 10 until you change it
ColumnsCompletenessWhich of the sample set's fields the grid checks

An Over time tile draws its counts as columns, one per day, week, month or quarter, with the quiet ones drawn empty. Draw as switches it to Lines. A column opens the records it counts.

Status over time draws samples by status, or tasks by board column, as they were at the end of each day, week, month or quarter, such as how many samples were in use at the end of each month this year. It reads each record's history of status changes, so a sample counts where it was then, even after it moved on. Draw as switches it to Lines too.

Open and finished draws two lines for tasks. They show how many were still open and how many were finished at the end of each day, week or month. A task is finished while it sits in its board's finish column or a column after it, so one moved back out reads open again. It starts as lines, and Only these tags narrows it to one kind of work, such as the Bug tasks closing over a month.

A record counts from the week or month it was added, and one deleted since is left out. A tile reading more than 20,000 records asks for one sample set instead.

A task is Finished when it last moved into its board's finish column, or when it was added if it was made in that column, so a task moved back out no longer counts.

Data table rows reads one data table, such as an assay's readouts or an image analysis results sheet. Its columns are its fields.

  • Any column is something to Split by.
  • A column of numbers is something to Measure, such as the mean IL-6 or the highest titer. A cell that isn't a number counts as empty.
  • A column of dates is a Date to count by or draw Over time. A cell that isn't a date counts as empty.
  • Where the row came from tells rows an analysis wrote from rows typed in by hand.

A colleague's private data table is left out, as it is everywhere.

Instrument bookings counts only the bookings made for this project, never another project's on the same instrument. Measure Hours to total the time booked, and split by Instrument to see which ones the project uses. An instrument booked through another lab's share is named Shared instrument.

Stock movements counts each time stock was received, used, moved, adjusted, returned or disposed of, on the items you can see in Stock. Quantities are in each item's own unit, so split by Item before you total them.

Its Value tile totals what stock used and written off was worth when it moved, in each currency. Split it by Used or written off, Reason, Item or Category.

  • Used takes off anything returned, such as a protocol step that was undone.
  • A cocktail batch counts as its tests are used or written off, so the antibodies drawn into it aren't counted a second time.
  • An entry with no value is in no total, and the tile says how many it left out. That's an item with no price, or an entry recorded before values were kept.

Target gives a count, a measure or an Over time tile a number to reach, and Due the day it is due. A count shows "84 of 120" over a bar, with how many are left ("36 to go by Jun 30, 2027"). An Over time tile draws the target as a line across its chart. Leave Target empty for none.

Size sets how much of a row the tile takes, Small, Medium or Large. Title names the tile. Left blank, the tile is named for what it shows, such as "Samples by status". The Preview beside them draws the tile live and says how many records it reads, and Add tile puts it in the report.

A tile shows its title and the scope it counts in ("In this project"). Live in the report's top bar means the tiles have today's numbers. It reads Reconnecting… while a tile can't reach its numbers.

Each kind of tile shows something different.

  • A count is one number.
  • A measure is one number read from a field, with its unit, and says how many records it measured.
  • A breakdown draws each status, kind or value as a bar with its number. A measured breakdown draws each bar's measure.
  • A list shows the first records, such as overdue tasks with their due dates or orders still open.
  • Completeness lists a sample set's members against its fields, with how many members have each one filled.
  • Spend by supplier totals priced orders per supplier in each currency, never across currencies. An order counts at its total cost, or its unit price times its quantity when no total was entered.

Choosing the Report's Period

Period in the report's top bar sets the span every dated tile counts in. On a phone or tablet, Period and the report's other settings sit under its title.

PeriodWhat dated tiles count
All timeEverything, the report's starting choice
Since last snapshotWhat happened after the newest snapshot was taken
Last 7 days, Last 30 days, Last 12 weeks, Last 12 monthsThe span ending today
This month, This quarter, This yearFrom the start of the month, quarter or year
Last month, Last quarterThe previous month or quarter, start to end
Custom range…The days you pick

Each dated tile names the days it counts under its title. Tiles that count records as they are now, such as Samples by status, read the same in any period. A tile with its own Within keeps it.

The period is kept on the report, so everyone reading it and every snapshot count the same span, in the reader's own time zone. Since last snapshot starts when the newest snapshot was taken, and counts all time before the first. Viewers see the period without changing it.

Choosing the Report's Sample Set

A report with a sample set tile shows a sample set menu beside Period. Pick a set there and every sample set tile reads it, so one report serves each cohort in turn. Each tile is then named for that set ("In Cohort B"). Each tile's own set puts every tile back on the set it was made with.

Like the period, the set is kept on the report and on each snapshot, so a snapshot shows the set it counted. Tiles that read the whole project are not changed by it.

Reading the Numbers

Tiles count what you can open. A colleague's private sample or note is left out of your numbers, and theirs count what they can open.

Press a number to see the records it counts. A side panel opens beside the report and lists the records by name. Each one opens its page. A row in a list tile opens its record the same way.

Presenting a Report

Present in the top bar shows the report full screen for a lab meeting, read-only, with its tiles live. A number still opens the records it counts. Exit or Esc leaves. Present is offered on a computer or tablet.

Arranging Tiles

Tiles sit side by side in rows, in page order.

SizeWidth
SA third of a row
MHalf a row
LThe whole row

Drag a tile by its grip to move it, or select it and press Alt/Option + Left/Right to move it one place along its row.

Select a tile to bring up its bar. It has Edit, its size as S, M or L, and a menu with Duplicate and Remove. Edit reopens the dialog box on the tile, so you can change what it counts without placing a new one. Remove takes the tile off at once, and undo brings it back.

Adding a Chart From a Sheet

On a sheet's chart, press Add to, then Report. Existing report lists the project's reports with how many tiles each has. Pick one, or use New report to name a new one and create it. The chart goes at the end of the report and reads the sheet as it changes.

Taking Snapshots and Downloading

Take snapshot in the report's Snapshots panel keeps every tile's numbers as they are that day, so you can open what the report said on that day. Open the panel from Snapshots in the report's menu, or from the button beside its name once there is a snapshot. Add a note for the meeting or update it is for. The live report keeps updating.

A snapshot is named by the date and time it was taken, in your time zone.

Once a report has a snapshot, each count and breakdown says how far it has moved since, as in "▲ 9 from 29 on Oct 3", with the change beside each bar. A tile changed since that snapshot shows none, and so does a dated tile once the report's period has changed, because each counts something else now.

Each tile on a snapshot reads Numbers as of its date, and a dated tile also names the days it counted. A snapshot keeps the report's period with it, and an Over time tile keeps its columns. Its numbers don't open records, since the records a number counts today aren't the ones it counted then. A tile the snapshot kept nothing for reads Today's numbers.

ActionWhat it does
RestorePuts the snapshot's text and tiles back on the report. The numbers stay live.
Withdraw snapshotMarks the snapshot as withdrawn with your reason. It stays readable, and withdrawing is permanent.

Snapshots on a Schedule

The snapshot menu beside Period takes snapshots for you.

ChoiceWhen a snapshot is taken
By hand onlyOnly when someone presses Take snapshot
Each Monday, 7:00Every Monday morning, so a weekly lab meeting has the week's numbers
On the 1st of each month, 7:00The morning after each month ends

The time is in the time zone of the person who set the schedule, and each snapshot counts what they can see. A snapshot is taken even when nobody changed the report, since its numbers moved. Viewers see the schedule without changing it.

Following a Report

Follow in the report's Activity panel puts an entry in your inbox each time a snapshot of it is taken, by a colleague or on its schedule. A snapshot you take yourself sends you nothing. The entry opens the report. It comes to the inbox only, never as an email or a phone notification.

Download gives the report as a PDF, Word or Markdown file. A report prints on A4 landscape. In a project export, reports are filed in their own reports folder, with every snapshot beside them.

A line under the PDF's title names the project and, for a snapshot, when it was taken and by whom.

Reports and Your Assistant

With Conspecta connected to your AI assistant, you can ask it to do the following.

  • Build a report, or start one from a template.
  • Read a report's numbers, or change a tile ("make the runs by status tile large and move it to the top").
  • Count something without writing anything, such as "how many samples are in use?".
  • Take a snapshot of a report for a meeting, and give you its PDF as a link that works for an hour.

A report it makes is a draft in Reports, shared with the project like one you make. It takes snapshots of reports and downloads them, never notes or protocols. What Your AI Assistant Can Do lists every action.