---
title: "Build your first flow and dashboard | Oplema"
description: "Join two sample tables, chart revenue by country, save a version and open it again in a 15-minute tutorial that needs no account."
url: "https://oplema.com/docs/getting-started"
updated: "2026-11-05"
---

# Getting started

In about 15 minutes you'll build a flow in Strata, chart its result in Vista, save a version, read a diff and go back to that version. You need a desktop browser. You don't need to sign up.

## What you'll build

A flow that joins retail orders to retail stores and totals revenue for each country, and a dashboard with one column chart of that total.

As a guest, your project runs in your browser and syncs to a temporary My Cloud. Guest copies are deleted about 30 days after the guest session started.

## Step 1: Add the two sample tables

1. Open [Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata). You see an empty canvas with a block palette above it.
2. In the palette, select IO. Drag Input onto the canvas, or double-click it. A single click only shows a description.
3. Select the block, then look at Properties on the left. Open the dropdown that says Local File and choose Example.
4. Open Dataset and choose Retail Orders. The preview under the canvas shows columns starting with `order_id` and `store_id`.
5. Drag a second Input onto the canvas, below the first. Select the new block, then choose Example again, then the Retail Stores dataset. It has 40 rows and 5 columns, including `store_id` and `country`.

A red message such as `file_path is required` is normal until you pick a dataset.

## Step 2: Join orders to stores

Both tables have a `store_id` column, so that's the join key.

1. In the palette, select Combine and drag Join to the right of the two inputs.
2. Drag from the dot on the right of the Retail Orders block to the upper dot on the left of Join. That's the left input.
3. Drag from the dot on the right of the Retail Stores block to the lower dot on the left of Join. That's the right input.
4. Select Join. Under Join Keys, select Add.
5. Set Left Column to `store_id` and Right Column to `store_id`.
6. In the preview, select OUTPUT INNER. You should see 14 columns: the 10 order columns followed by `store_name`, `city`, `country` and `store_format`.

Join has three output dots, in this order from the top: OUTPUT LEFT (orders with no store), OUTPUT INNER (matches) and OUTPUT RIGHT (stores with no orders). See [Join](https://oplema.com/docs/strata/combine/join) for details.

## Step 3: Total revenue by country

1. In the palette, select Transform and drag Summarize to the right of Join.
2. Drag from the **middle** output dot of Join to the input dot of Summarize.
3. Select Summarize. Under Actions, select Add. Leave Action as Group by and set Column to `country`. Output fills in by itself.
4. Select Add again. Set Action to Sum, set Column to `net_sales_eur`, and type `revenue` in Output.
5. The preview now shows 10 rows and 2 columns, `country` and `revenue`.
6. Open the dropdown that says Preview: 100 rows and choose Preview: All rows. The default is a sample, so its totals aren't the real totals. Finland is now highest at about 11,758, followed by Sweden and Belgium.

## Step 4: Send the result to Vista

1. In the palette, select IO and drag Vista Source to the right of Summarize.
2. Drag from the output dot of Summarize to the input dot of Vista Source.
3. Select Vista Source. Display name holds a random name. Replace it with `Revenue by country`.

A dashboard can only use tables that reach a [Vista Source](https://oplema.com/docs/strata/io/vista-source) block.

## Step 5: Add a chart

1. At the top of the page, select Vista. You see an empty page called Page 1.
2. With Bars & columns selected in the palette, drag Columns onto the page.
3. The chart appears straight away. Select it and open the Data tab in Properties. Data source shows `Revenue by country`, Group by is `country`, Bar value is `revenue` and Operation is Sum.

Vista chose the source because the project has only one. With more sources, select Change next to Data source and use the Table dropdown to choose one.

## Step 6: Save a version

Your work autosaves, but only a saved version gets a name you can find later.

1. On the right, select History.
2. In What changed?, type `Revenue by country`, then select Save.
3. A new row with your message appears at the top of the list. It has a small colored tag with a branch name that Oplema picked, such as `papa`.

## Step 7: Change something and read the diff

1. Select Strata at the top, then select Summarize.
2. In the second action, change Action from Sum to Average. The preview now shows averages.
3. In History, a row named <current> marked unsaved appears at the top. Leave it unsaved.
4. Select the row below it, `Revenue by country`. On the canvas, Summarize is highlighted because it changed. Everything else is dotted.
5. Above the canvas, select Script, then select the `Revenue by country` row again if needed. You see the changed `actions` line, with the old line in red and the new line in green.
6. Select Graph to return to the canvas.

## Step 8: Open the earlier version

1. On the `Revenue by country` row, select Open.
2. Select Summarize. The action is Sum again.
3. Look at the list. Your average change wasn't lost. It's now a row named <current> with an Open button, which brings it back.

[Saves](https://oplema.com/docs/echo/saves) explains what happens when you edit from an older version, and [Diffs](https://oplema.com/docs/echo/diffs) explains the Logic, Canvas and Full buttons.

## Compare with the finished project

This is the version you saved in step 6, with Preview: All rows: Finland is highest at about 11,758.

Result
| country | revenue |
| --- | --- |
| Belgium | 11554.9 |
| France | 9688.5 |
| Norway | 8575.3 |
| Finland | 11758.3 |
| Ireland | 8443.5 |
| Germany | 8486 |
| Sweden | 11650.3 |
| Austria | 10770.2 |

## Where to go next

- **Learn Strata step by step.** The first course, [Build a report from a CSV export](https://oplema.com/learn/export-to-report), goes deeper, with hands-on lessons that turn one shop's export into a weekly report you can check. It starts with [Build your first data flow from a CSV](https://oplema.com/learn/export-to-report/first-data-flow).
- **Sign up to keep it.** Select Sign up at the top right, in this browser. You also need an account for the next three.
- **Ask Elara to change it.** Start at [Set up Elara](https://oplema.com/docs/elara/setup).
- **Run it on a schedule.** Scheduling needs an [Output](https://oplema.com/docs/strata/io/output) block with a saved destination. See [Scheduling](https://oplema.com/docs/cloud/scheduling).
- **Publish the dashboard.** Give people a link to it. See [Publish](https://oplema.com/docs/cloud/publish).
- **Find any other task.** See [How-to guides](https://oplema.com/docs/how-do-i) and the [Glossary](https://oplema.com/docs/glossary).

### Prepare your data. Build it in Strata.

Strata opens in your browser, with no account.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
