Virtual fields

Explore the Orbit sample tables

Follow a satellite through computed columns, related passes and an exact count in Sample mode, then draft a field of your own without saving it.

In this tutorial you read computed and related columns on three seeded tables, follow one satellite to its passes, draft a field with a live preview, and turn a partial count into an exact one. You need no AWS account, and nothing you do here is saved.

The tables belong to Orbit, a small satellite operator in Sample mode. OrbitSatellites holds 12 satellites, OrbitGroundStations holds 6 stations, and OrbitPasses holds each pass of a satellite over a station. They open with their links and fields already saved.

Before you start

Enter Sample mode. On the welcome screen, click Try sample data, or open Settings, then Onboarding. Sample mode lifts every plan gate, so virtual fields work on any plan.

Read the satellites

  1. Press ⌘ K (Ctrl + K on Windows and Linux), type OrbitSatellites, and press Enter. The table opens in a query tab.
  2. If the grid shows no rows, press ⌘ Enter (Ctrl + Enter) to run the scan. Twelve satellites load.

The OrbitSatellites grid with Health, Ground stations, Signal trend and Data downlinked columns

After satelliteId, name and operator, the columns are virtual fields. Health carries the boxed ƒ of a computed column and draws status as a colored badge. Ground stations, Signal trend (dB) and Data downlinked carry a link icon, with Through stations or Through passes under the name. Corvid-2’s Data downlinked reads ≥356.3 GB. The ≥ says the total covers only the first passes Dynomatic read.

Look at the right end of the strip under the Filters builder. Related reads counts what the linked columns read, apart from Actual, the scan itself.

The cost strip reading Actual: 1 RCU and Related reads: 11 RCU in 13 requests

Your numbers can differ. They depend on how many rows were on screen when the reads ran.

Follow a satellite to its passes

  1. Click Corvid-2’s Ground stations cell. The value viewer opens and lists all six of its stations, past the three chips the column shows.

    The value viewer listing six ground stations

  2. Press Escape, then click Corvid-2’s Signal trend (dB) cell. The peek opens with passes 25 of 25+. The passes link reads 25 items per row, and Corvid-2 has more.

    The peek listing Corvid-2's passes, 25 of 25+

  3. Press Escape, then click the chevron at the start of Corvid-2’s row. The same passes open in a sub-grid under the row. Click the chevron again to close it.

    Corvid-2's passes expanded under its row

  4. Open the peek again and click Open all in new tab. An OrbitPasses tab opens with the query satelliteId = sat-corvid-2 and every one of Corvid-2’s passes. The breadcrumb above the grid leads back to Corvid-2’s row.

    The OrbitPasses tab opened from Corvid-2, with Satellite, Station and Country read through links

In this tab, Satellite, Station and Country read one item each through the satellite and station links. Outcome and Clean signal are expressions over the pass itself.

See values that depend on the loaded rows

Scroll the OrbitPasses grid to the right. Running total per satellite and Rank by data say Depends on loaded rows under their names. They rank and add up only the passes this tab has loaded, so they would change if more rows loaded.

Data, Running total per satellite, Share of onboard storage, Rank by data and Throughput columns

Draft a field and watch the preview

  1. In the OrbitPasses tab, click Virtual fields in the results toolbar, then Add virtual field. The New virtual field dialog opens on the Expression tab.

  2. In Name, type Downlink per minute (MB).

  3. In the expression editor, type durationSec > 0 ? bytesDown * 60 / durationSec / 1000000. After a moment the preview on the right lists rows with their values, under Previewing 20 rows.

  4. Open Format and choose Number. Set Decimal places to 1 and turn on Group thousands. The preview redraws every value, such as 1,655.4.

    The New virtual field dialog previewing Downlink per minute on 20 passes

  5. Click Cancel. Nothing was saved.

A missed pass has no duration, so the expression gives it no value.

  1. Press ⌘ K, type OrbitGroundStations, and press Enter. Run the scan if the grid is empty.
  2. Click Links in the results toolbar. The menu lists the table’s link, passes → OrbitPasses.
  3. Click the edit button beside passes. The Edit link passes dialog opens.

The Edit link passes dialog reading OrbitPasses through stationId-startsAt-index

The link reads Items that match a key from OrbitPasses, on the index stationId-startsAt-index, with each station’s stationId as the partition key, newest first, 25 items per row. The preview counts six stations with passes and says the six rows need 6 distinct queries.

  1. Click Cancel.

Turn a partial count into an exact one

On OrbitGroundStations, Aurora Ridge’s Passes cell reads 25+, because the link read its first 25 passes.

Aurora Ridge reads Passes 25+ and Data received ≥186.3 GB

  1. Right-click Aurora Ridge’s Passes cell.
  2. Choose Compute Exact. Dynomatic reads the rest of the station’s passes, and the cell reads 57.

Aurora Ridge reads Passes 57 after Compute Exact, and Data received keeps its ≥ mark

Data received still reads ≥186.3 GB. Compute Exact replaces only the cell you ran it on.

What you did

You read a badge field, chips, a sparkline and partial totals, followed one satellite to its passes four ways, drafted a field with a live preview, read a query link’s settings, and made one count exact. Every Orbit field and link is an ordinary one, so you can edit or delete it. Reset in the Sample pill restores them.

Next, create a field on a table of your own, or link another table.

Last updated on