How-to guides by task
Find your task, then follow the link.
Get started
Bring data in
Prepare data in Strata
- Learn how a flow works
- Filter rows
- Calculate a column
- Join or merge two tables
- Add values from a reference table, like VLOOKUP
- Remove duplicate rows (dedupe, distinct rows)
- Pivot rows into columns
- Extract text with a regular expression (regex)
- Count the days between two dates (datediff)
- Save the result as an Excel file (.xlsx)
- Total values by group
- Look up an expression function
- Write the result somewhere
- Write a Python code block
- Write an R code block
- Export a flow to Python: open Settings, then Export, then Python.
Build dashboards in Vista
- Build your first dashboard
- Send a table from Strata to Vista
- Add filters and use a parameter
- Filter a dashboard by date range
- Make a line chart
- Make a stacked bar chart
- Show a KPI with the Number visual
- Show a KPI against a target with Progress
- Show a pivot table on a dashboard
- Add pages and arrange the layout
- Add calculations
- Choose a chart
- Export a dashboard: Vista has no HTML, PNG or PDF export. The PNG and PDF menu items export only the Strata graph. Publish it instead.
Work with Elara
Save, undo and compare work
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.
- Total too high after a join? Duplicate rows appear when a key repeats, because Inner has one row for each matching pair. See Join, or use Lookup to keep the row count fixed.
- Rows missing after a join? Find out why rows don't match in a join.
- The flow runs but the total is wrong? Debug a flow that runs but gives the wrong total.
Schedule and share
- Run a flow on a schedule, such as nightly (no cron needed)
- Find out why a scheduled run failed. Failures appear in the schedule dialog and Run history. No email is sent.
- Publish a dashboard and send people the link
- Share a project with a teammate
Manage a team
Pay for usage
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.