---
title: "How-to guides by task | Oplema"
description: "Find the guide for your task: build flows and dashboards, connect data, schedule runs, publish, share, manage teams and pay for usage."
url: "https://oplema.com/docs/how-do-i"
updated: "2026-11-08"
---

# How-to guides by task

Find your task, then follow the link.

## Get started

- [Build your first flow and dashboard](https://oplema.com/docs/getting-started)
- [Learn Strata step by step in a hands-on course](https://oplema.com/learn/export-to-report)
- [Look up a term](https://oplema.com/docs/glossary)
- [Understand what Cloud does](https://oplema.com/docs/cloud/what-is-cloud)

## Bring data in

- [Load a file, URL or example dataset](https://oplema.com/docs/strata/io/input)
- [Type a small table by hand](https://oplema.com/docs/strata/io/manual-input)
- [Connect Postgres](https://oplema.com/docs/strata/io/connectors/postgres)
- [Find another connector](https://oplema.com/docs/strata/io/connectors)
- [Upload, move and manage files in Cloud](https://oplema.com/docs/cloud/files)

## Prepare data in Strata

- [Learn how a flow works](https://oplema.com/docs/strata/what-is-strata)
- [Filter rows](https://oplema.com/docs/strata/prep/filter)
- [Calculate a column](https://oplema.com/docs/strata/prep/formula)
- [Join or merge two tables](https://oplema.com/docs/strata/combine/join)
- [Add values from a reference table, like VLOOKUP](https://oplema.com/docs/strata/combine/lookup)
- [Remove duplicate rows (dedupe, distinct rows)](https://oplema.com/docs/strata/prep/unique)
- [Pivot rows into columns](https://oplema.com/docs/strata/transform/cross-tab)
- [Extract text with a regular expression (regex)](https://oplema.com/docs/strata/parse/regex)
- [Count the days between two dates (datediff)](https://oplema.com/docs/strata/functions/date-diff)
- [Save the result as an Excel file (.xlsx)](https://oplema.com/docs/strata/io/output)
- [Total values by group](https://oplema.com/docs/strata/transform/summarize)
- [Look up an expression function](https://oplema.com/docs/strata/functions)
- [Write the result somewhere](https://oplema.com/docs/strata/io/output)
- [Write a Python code block](https://oplema.com/docs/strata/developer/python)
- [Write an R code block](https://oplema.com/docs/strata/developer/r)
- Export a flow to Python: open Settings, then Export, then Python.

## Build dashboards in Vista

- [Build your first dashboard](https://oplema.com/docs/vista/first-dashboard)
- [Send a table from Strata to Vista](https://oplema.com/docs/strata/io/vista-source)
- [Add filters and use a parameter](https://oplema.com/docs/vista/parameters-and-filters)
- [Filter a dashboard by date range](https://oplema.com/docs/vista/controls/filter)
- [Make a line chart](https://oplema.com/docs/vista/lines-areas/line)
- [Make a stacked bar chart](https://oplema.com/docs/vista/bars-columns/stacked-horizontal-bars)
- [Show a KPI with the Number visual](https://oplema.com/docs/vista/metrics/number)
- [Show a KPI against a target with Progress](https://oplema.com/docs/vista/metrics/progress)
- [Show a pivot table on a dashboard](https://oplema.com/docs/vista/tables/pivot-table)
- [Add pages and arrange the layout](https://oplema.com/docs/vista/pages-and-layout)
- [Add calculations](https://oplema.com/docs/vista/calculations)
- [Choose a chart](https://oplema.com/docs/vista#where-next)
- Export a dashboard: Vista has no HTML, PNG or PDF export. The PNG and PDF menu items export only the Strata graph. [Publish it](https://oplema.com/docs/vista/publish-a-dashboard) instead.

## Work with Elara

- [Set up a hosted model, your own key or a local model](https://oplema.com/docs/elara/setup)
- [Ask Elara to build or fix a flow](https://oplema.com/docs/elara/in-strata)
- [Ask Elara to change a dashboard](https://oplema.com/docs/elara/in-vista)
- [See what Elara can do](https://oplema.com/docs/elara/what-it-can-touch)
- [Read the Privacy Policy](https://oplema.com/privacy-policy)

## Save, undo and compare work

- [Save a version and go back to it](https://oplema.com/docs/echo/saves)
- [Undo a change](https://oplema.com/docs/echo/saves#undo)
- [Go back to an earlier version](https://oplema.com/docs/echo/saves#open)
- [See what changed](https://oplema.com/docs/echo/diffs)
- [Delete a branch](https://oplema.com/docs/echo/saves#delete)
- [Go back to before an Elara turn](https://oplema.com/docs/echo/elara)
- [Check how your project syncs](https://oplema.com/docs/cloud/sync)

## Fix a wrong number

- Totals don't match the published dashboard? In the editor, previews use a sample of each source, 100 rows by default. [See how sampling changes totals](https://oplema.com/docs/vista/first-dashboard#sampling).
- Total too high after a join? Duplicate rows appear when a key repeats, because Inner has one row for each matching pair. See [Join](https://oplema.com/docs/strata/combine/join), or use [Lookup](https://oplema.com/docs/strata/combine/lookup) to keep the row count fixed.
- Rows missing after a join? [Find out why rows don't match in a join](https://oplema.com/learn/many-sources/find-unmatched-join-rows).
- The flow runs but the total is wrong? [Debug a flow that runs but gives the wrong total](https://oplema.com/learn/many-sources/debug-a-wrong-total).

## Schedule and share

- [Run a flow on a schedule, such as nightly (no cron needed)](https://oplema.com/docs/cloud/scheduling)
- [Find out why a scheduled run failed](https://oplema.com/docs/cloud/run-history). Failures appear in the schedule dialog and Run history. No email is sent.
- [Publish a dashboard and send people the link](https://oplema.com/docs/cloud/publish)
- [Share a project with a teammate](https://oplema.com/docs/cloud/sharing)

## Manage a team

- [Create a team and add people](https://oplema.com/docs/console/teams)
- [Add a teammate to a team](https://oplema.com/docs/console/teams#invite)
- [Understand the Owner, Admin, Editor and Viewer roles](https://oplema.com/docs/console/roles)
- [Assign usage to a team](https://oplema.com/docs/console/usage-and-top-up#assign)
- [Set a member limit](https://oplema.com/docs/console/usage-and-top-up#member-limits)

## Pay for usage

- [Check your usage and top up (add credits)](https://oplema.com/docs/console/usage-and-top-up)
- [See what a run costs](https://oplema.com/pricing)
- [Change or cancel your plan and find invoices](https://oplema.com/docs/console/billing)
- [Compare plans, prices and limits](https://oplema.com/pricing)

### 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)
