# Oplema documentation > Documentation for Oplema, a browser-based data analytics platform: Strata prepares data in flows of blocks, Vista builds interactive dashboards, Elara is the AI assistant, Echo keeps version history, Cloud stores, shares, publishes and schedules work, and Console manages teams and usage. Last updated 2026-11-08. For what Oplema is, pricing, limits and comparisons with other tools, read https://oplema.com/llms.txt. Each product section below starts with its overview, then guides, then reference hubs, then individual blocks or visuals. Strata connectors come last. Blocks list their settings, inputs and outputs; visuals list their properties and data bindings. **Common tasks** - Join two tables on matching keys: https://oplema.com/docs/strata/combine/join.md (Matched rows go to the Inner output, unmatched rows to Left and Right.) - Keep every row from all tables (full outer join), or join three or more tables on one shared key: https://oplema.com/docs/strata/combine/join-multiple.md - Add columns from a reference table, like VLOOKUP or a left join: https://oplema.com/docs/strata/combine/lookup.md (Rows with no match get NULL in the new columns.) - Unpivot or melt columns into rows (wide to long): https://oplema.com/docs/strata/transform/transpose.md (The Value column is text, so convert numbers back afterwards, for example with the Number block.) - Pivot rows into columns (long to wide): https://oplema.com/docs/strata/transform/cross-tab.md - Group and aggregate, like GROUP BY: https://oplema.com/docs/strata/transform/summarize.md - Calculate a column with an expression: https://oplema.com/docs/strata/prep/formula.md (Expressions are DuckDB SQL. Put column names containing spaces in double quotes, and set the output type to match the result, such as VARCHAR for text.) - Look up a SQL function, its signature and examples: https://oplema.com/docs/strata/functions.md - Put numbers into bands or buckets without SQL: https://oplema.com/docs/strata/prep/bin.md - Load data from a database such as Postgres: https://oplema.com/docs/strata/io/connectors/postgres.md - Schedule a flow to run every day: https://oplema.com/docs/cloud/scheduling.md - Build a first dashboard: https://oplema.com/docs/vista/first-dashboard.md - Add a filter control to a dashboard: https://oplema.com/docs/vista/controls/filter.md - Show a matrix heatmap, such as cohort retention: https://oplema.com/docs/vista/heatmaps/matrix-heatmap.md (Calculate rates such as retention in Strata first, and keep any filter column in the grouped table.) - Publish a dashboard and choose who can open it: https://oplema.com/docs/cloud/publish.md - Share a project with a teammate: https://oplema.com/docs/cloud/sharing.md - Set up Elara with a hosted model, your own API key or a local model: https://oplema.com/docs/elara/setup.md (Hosted models, including Anthropic's, are paid from Oplema usage. Your own key works with any OpenAI-compatible HTTPS endpoint (a base URL and API key).) - Ask Elara to build a flow or fix a failed step: https://oplema.com/docs/elara/in-strata.md - Restore or revert to an earlier version: https://oplema.com/docs/echo/saves.md - Manage teams, roles and spending: https://oplema.com/docs/console/teams.md - Find a guide for any other task: https://oplema.com/docs/how-do-i.md **Things to know before you answer** - Editing needs a desktop browser. Local work in Strata and Vista needs no account. - Previews show 100 rows by default, and you can switch a preview to all rows. Runs and published dashboards always use all rows. - Database and app connections always go through Oplema's servers, even when the flow runs in the browser. - A schedule runs as a hosted run in your region, even when the browser is closed, and each hosted run stops after 5 minutes. - Anyone who can open a published dashboard can reach the published project and its input data. Filters don't limit that. - Elara needs an account with every model option, including your own key and local models. ## Getting started - [Getting started](https://oplema.com/docs/getting-started.md): Join two sample tables, chart revenue by country, save a version and open it again in a 15-minute tutorial that needs no account. - [Glossary](https://oplema.com/docs/glossary.md): Look up one-line definitions of the terms used across the docs, from block and flow to saved version, usage, publish and share. - [How-to guides by task](https://oplema.com/docs/how-do-i.md): Find the guide for your task: build flows and dashboards, connect data, schedule runs, publish, share, manage teams and pay for usage. ## Strata - [What is Strata?](https://oplema.com/docs/strata/what-is-strata.md): Strata is Oplema's browser app for data prep. Learn how blocks connect into a flow and how the canvas and the script edit the same flow. - [Strata documentation](https://oplema.com/docs/strata.md): Browse Strata blocks by palette, from IO and Prep to Combine, Transform, Parse and Developer, with settings, inputs and outputs, plus every function. - [Connectors](https://oplema.com/docs/strata/io/connectors.md): Connect Strata to databases, business apps, finance tools and file storage. See what each connector reads and writes and how connections and billing work. - [IO](https://oplema.com/docs/strata/io.md): Load data into a Strata flow, deliver results, connect to services and link tables and values to Vista dashboards with the IO blocks. - [Prep](https://oplema.com/docs/strata/prep.md): Clean and prepare a table in Strata: choose columns, filter rows, fix types and missing values, remove duplicates and calculate new columns. - [Combine](https://oplema.com/docs/strata/combine.md): Bring tables together in Strata: match them on a key, link similar text, stack rows from several tables or add values from a reference table. - [Transform](https://oplema.com/docs/strata/transform.md): Change the shape of a table in Strata: summarize by group, calculate running values, move values between rows and columns and expand rows into ranges. - [Parse](https://oplema.com/docs/strata/parse.md): Turn text into data you can use in Strata: dates, numbers, JSON, pieces extracted with a pattern and lists split into columns or rows. - [Developer (Strata blocks)](https://oplema.com/docs/strata/developer.md): Run your own Python or R in a Strata flow when no other block does what you need. Read tables as inputs and assign tables as outputs. - [Documentation](https://oplema.com/docs/strata/documentation.md): Documentation blocks explain a Strata flow to the people reading it. The palette holds Note, plain text on the canvas that doesn't run or change results. - [Functions](https://oplema.com/docs/strata/functions.md): Look up Strata functions for text, numbers, dates, lists and missing values, with signatures and verified examples for Formula and Filter. - [Input](https://oplema.com/docs/strata/io/input.md): Load a table into Strata from a file, a URL, Cloud, a bundled example dataset or a connector such as Postgres, Google Sheets or Stripe. - [Output](https://oplema.com/docs/strata/io/output.md): Send a finished table to a download, a local folder, Cloud or a connector such as Postgres with Output. Only Cloud and connector outputs can be scheduled. - [Date/Time Now](https://oplema.com/docs/strata/io/date-time-now.md): Add the current date or time as a one-row table with Date/Time Now in Strata. Choose the column name and a format such as ISO, DATE, TIMESTAMP or UNIX. - [Sequence](https://oplema.com/docs/strata/io/sequence.md): Create a table of evenly spaced dates or numbers in Strata, such as one row for every day of a month, without any input table. - [Manual Input (Strata block)](https://oplema.com/docs/strata/io/manual-input.md): Type a small table into Strata with Manual Input for lookup values or test data. Edit a live example, add rows and columns and see blank cells become NULL. - [Vista Source](https://oplema.com/docs/strata/io/vista-source.md): Make a Strata table available to Vista dashboards with Vista Source. Add one where a table is ready to chart, and see how a chart reads from a flow. - [Vista Filters](https://oplema.com/docs/strata/io/vista-filters.md): Back a dashboard Filter control with a Strata table. Vista Filters sits before a Vista Source, so readers can narrow every visual in the filter's scope. - [Vista Parameter](https://oplema.com/docs/strata/io/vista-parameter.md): Read a value or table set in Vista, such as a slider or a Manual data table, into a Strata flow with Vista Parameter. The flow recalculates on each change. - [Record ID](https://oplema.com/docs/strata/prep/record-id.md): Add a row number or sequential ID column with Record ID in Strata. Set the column name and starting value, and choose BIGINT numbers or VARCHAR text. - [Select](https://oplema.com/docs/strata/prep/select.md): Choose, rename, reorder and change the type of columns with Select in Strata. A value that doesn't fit its new type becomes NULL. - [Auto Field](https://oplema.com/docs/strata/prep/auto-field.md): Detect and convert column types with Auto Field. It checks every value, so codes with leading zeros stay text, and it can read 0 and 1 as booleans. - [Cleanse](https://oplema.com/docs/strata/prep/cleanse.md): Clean messy values with Cleanse: trim spaces, change case, remove letters, digits or punctuation, round decimals and override settings per column. - [Sort](https://oplema.com/docs/strata/prep/sort.md): Sort rows by one or more columns, or rank them, with Sort in Strata. Set the direction and priority of each key, and rank within groups. - [Fuzzy Search](https://oplema.com/docs/strata/prep/fuzzy-search.md): Search a text column for close matches, even with typos, with Fuzzy Search. Every row is kept and ranked by a \_fuzzy\_score column, best match first. - [Formula](https://oplema.com/docs/strata/prep/formula.md): Add or update columns with SQL expressions using Formula in Strata. A formula can use the result of an earlier one, and you can set each output type. - [Filter (Strata block)](https://oplema.com/docs/strata/prep/filter.md): Filter rows by a condition with the Filter block. Matching rows go to the True output and the rest to False, including rows with a missing value. - [Sample](https://oplema.com/docs/strata/prep/sample.md): Take a random sample, the first or last rows or every Nth row with Sample. Set a row count or percentage, sample within groups or balance classes. - [Split](https://oplema.com/docs/strata/prep/split.md): Split a table into train, validation and test sets with Split in Strata. Use a random or sequential split, a seed to repeat it and stratify by a column. - [Unique](https://oplema.com/docs/strata/prep/unique.md): Remove or flag duplicate rows with Unique. Choose the columns that define a match, and the block sends rows to its Unique and Duplicate outputs. - [Impute](https://oplema.com/docs/strata/prep/impute.md): Fill missing values with the mean, median, mode or a fixed value using Impute in Strata. You can keep the original column and flag each filled cell. - [Scale](https://oplema.com/docs/strata/prep/scale.md): Normalize or standardize numeric columns with Scale. Choose min-max, standard (z-score) or robust scaling, and keep the original values if needed. - [Bin](https://oplema.com/docs/strata/prep/bin.md): Group numbers into ranges with Bin in Strata: equal count, equal width, standard deviation or your own cut points, with optional labels for each range. - [Encode](https://oplema.com/docs/strata/prep/encode.md): One-hot, label or ordinal encode text categories as numbers with Encode in Strata. For ordinal encoding, you set the order of the categories yourself. - [Interpolation](https://oplema.com/docs/strata/prep/interpolation.md): Fill gaps in ordered data such as a time series with Interpolation. Choose linear, polynomial or spline interpolation, or fill forward or backward. - [Join](https://oplema.com/docs/strata/combine/join.md): Join or merge two tables on matching key columns with the Join block. Matched rows go to the Inner output, unmatched rows to Left and Right. - [Join Multiple](https://oplema.com/docs/strata/combine/join-multiple.md): Join two or more tables on one shared key column with Join Multiple. The key needs the same name in every table. Choose a full outer or inner join. - [Fuzzy Match](https://oplema.com/docs/strata/combine/fuzzy-match.md): Join two tables on similar text, such as misspelled company names, with Fuzzy Match. Each pair gets a score from 0 to 100, and you set the cutoff. - [Union](https://oplema.com/docs/strata/combine/union.md): Stack rows from several tables with Union. Columns line up by name or position, and a Source column records which table each row came from. - [Lookup](https://oplema.com/docs/strata/combine/lookup.md): Add columns from a reference table, much like VLOOKUP, or correct values against a list with Lookup. Rows with no match get NULL in the new columns. - [Summarize](https://oplema.com/docs/strata/transform/summarize.md): Group by and aggregate rows with Summarize. Calculate sums, averages, medians and counts per group, and see how Count differs from Count non-null. - [Rolling Calc](https://oplema.com/docs/strata/transform/rolling-calc.md): Calculate running totals, moving averages, lag, lead and percent change with Rolling Calc. Set the window size, row order and Partition By groups. - [Count Dataset](https://oplema.com/docs/strata/transform/count-dataset.md): Count the rows, columns or both in a table with Count Dataset in Strata. The result is a one-row table, and rows with missing values are counted too. - [Transpose](https://oplema.com/docs/strata/transform/transpose.md): Unpivot or melt columns into rows with Transpose in Strata. Mark each column as Key, Data or Skip. The Value column is text, so numbers become text too. - [Cross Tab](https://oplema.com/docs/strata/transform/cross-tab.md): Pivot rows into columns with Cross Tab in Strata. Pick the column that names the new columns and the value column, then sum, count or average shared cells. - [Expand Rows](https://oplema.com/docs/strata/transform/expand-rows.md): Create one row for each day, month or number between a start and an end column with Expand Rows in Strata, or repeat each row a fixed number of times. - [DateTime](https://oplema.com/docs/strata/parse/datetime.md): Convert text or numbers to dates or timestamps with DateTime. Pick an input format such as a US or EU date and choose what happens to failed values. - [JSON](https://oplema.com/docs/strata/parse/json.md): Parse JSON text into columns or rows with the JSON block. Choose Unnest object, Flatten array, Strings or Typed values and see how missing keys work. - [Number (Strata block)](https://oplema.com/docs/strata/parse/number.md): Convert numbers stored as text, such as 1.234,56, into numeric columns with Number in Strata. Set the thousands and decimal separators and the output type. - [RegEx](https://oplema.com/docs/strata/parse/regex.md): Extract text or test for a pattern with a regular expression using RegEx. Extract returns the first capture group, and Match returns 1 or 0. - [Split to columns](https://oplema.com/docs/strata/parse/split-to-columns.md): Split comma-separated or other delimited text into columns with Split to columns in Strata. Choose the separator and whether to keep the original column. - [Split to rows](https://oplema.com/docs/strata/parse/split-to-rows.md): Split a list in one cell, such as comma-separated tags, into one row per item with Split to rows in Strata. The other columns repeat on every new row. - [Python (Strata block)](https://oplema.com/docs/strata/developer/python.md): Run your own Python in a Strata flow. Read input tables as Polars DataFrames and assign each output, in your browser or in a hosted run. - [R (Strata block)](https://oplema.com/docs/strata/developer/r.md): Run your own R in a Strata flow. Read input tables as data.frames and assign each output, in your browser or in a hosted run. - [Note](https://oplema.com/docs/strata/documentation/note.md): Add plain-text notes to a Strata flow to explain a step or label a section. Notes don't change results or appear in the Python export. - [Airtable](https://oplema.com/docs/strata/io/connectors/airtable.md): Read records from an Airtable base into a Strata flow. Connect your Airtable account and pick a base, table and view, then check limits and billing. - [BigQuery](https://oplema.com/docs/strata/io/connectors/bigquery.md): Read and write BigQuery tables from a Strata flow. It uses a Google connection shared with Google Sheets. See how to connect, limits and common fixes. - [Databricks](https://oplema.com/docs/strata/io/connectors/databricks.md): Read and write Unity Catalog tables from a Strata flow. Connect through a Databricks SQL warehouse with a personal access token, then pick a table. - [Dropbox](https://oplema.com/docs/strata/io/connectors/dropbox.md): Read data files from Dropbox into a Strata flow and write results back as new or replaced files. See how to connect, limits and common fixes. - [Google Sheets](https://oplema.com/docs/strata/io/connectors/google-sheets.md): Read a Google Sheets tab into a Strata flow and write results to a sheet or a file in Google Drive. See how to connect, limits and common fixes. - [HTTP](https://oplema.com/docs/strata/io/connectors/http.md): Read JSON, JSON Lines, CSV or Parquet from an HTTPS API into a Strata flow, with or without a bearer token. - [HubSpot](https://oplema.com/docs/strata/io/connectors/hubspot.md): Read HubSpot CRM records into a Strata flow, including contacts, companies, deals, tickets and custom objects. See how to connect and the limits. - [MySQL](https://oplema.com/docs/strata/io/connectors/mysql.md): Read and write MySQL 8.0 and 8.4 or MariaDB tables from a Strata flow with a database login. See what you need first, how to connect and how to fix errors. - [Notion](https://oplema.com/docs/strata/io/connectors/notion.md): Read a Notion data source into a Strata flow. Share the data source with your connection, pick it in the Input block and check limits and billing. - [OneDrive](https://oplema.com/docs/strata/io/connectors/onedrive.md): Read data files from your own OneDrive into a Strata flow and write results back as new or replaced files. See how to connect and common fixes. - [Postgres](https://oplema.com/docs/strata/io/connectors/postgres.md): Read and write PostgreSQL 14 to 18 tables from a Strata flow with a database login. See what you need first, how to connect and how to fix errors. - [QuickBooks](https://oplema.com/docs/strata/io/connectors/quickbooks.md): Read QuickBooks Online records such as invoices, bills, customers and accounts into a Strata flow. See how to connect, limits and common fixes. - [Snowflake](https://oplema.com/docs/strata/io/connectors/snowflake.md): Read and write Snowflake tables from a Strata flow. Connect with an account identifier and a programmatic access token, then check limits and billing. - [SQL Server](https://oplema.com/docs/strata/io/connectors/sql-server.md): Read and write SQL Server 2017 to 2025 tables from a Strata flow with a SQL login. See what you need first, how to connect and how to fix errors. - [Stripe](https://oplema.com/docs/strata/io/connectors/stripe.md): Read Stripe objects such as customers, charges, invoices and subscriptions into a Strata flow using a restricted API key. - [Supabase](https://oplema.com/docs/strata/io/connectors/supabase.md): Read Supabase tables through the Data API and write to them through PostgreSQL from a Strata flow. See how to connect, limits and common fixes. - [Xero](https://oplema.com/docs/strata/io/connectors/xero.md): Read Xero accounting records and reports, such as invoices, payments, budgets and the balance sheet, into a Strata flow. See how to connect and the limits. ## Vista - [What is Vista?](https://oplema.com/docs/vista/what-is-vista.md): Vista is Oplema's browser app for dashboards. Learn how visuals, data sources, the canvas and the script work together, and how previews use a sample. - [Vista documentation](https://oplema.com/docs/vista.md): Build dashboards in Vista with step-by-step guides to pages, filters, calculations and publishing, plus a reference for every chart, table and control. - [Calculations](https://oplema.com/docs/vista/calculations.md): Choose where to calculate on a Vista dashboard: in a Strata Formula, in a chart or KPI operation or with a parameter, and see which suits each job. - [Your first dashboard](https://oplema.com/docs/vista/first-dashboard.md): Build a Vista dashboard step by step: add a chart, a KPI, a table and a filter, check it against the full data and then publish it for viewers. - [Pages and layout](https://oplema.com/docs/vista/pages-and-layout.md): Choose a fixed or scrolling canvas, add pages to a Vista dashboard and arrange, resize and align its visuals. Each page can have its own canvas. - [Parameters and filters](https://oplema.com/docs/vista/parameters-and-filters.md): Let readers narrow a Vista dashboard with filters and change calculations with parameters, and learn how each connects to Strata. - [Publish a dashboard (Vista guide)](https://oplema.com/docs/vista/publish-a-dashboard.md): Publish a Vista dashboard to a link and see what viewers get: all rows, usable controls and no editing, with or without the Strata view. - [Bars & columns](https://oplema.com/docs/vista/bars-columns.md): Compare categories with column, horizontal bar and radial bar charts in Vista, plain, stacked or 100% stacked. Horizontal bars suit long labels. - [Lines & areas](https://oplema.com/docs/vista/lines-areas.md): Show trends over time or any ordered axis with line and area charts in Vista, vertical or horizontal, plain, stacked or 100% stacked. - [Distribution](https://oplema.com/docs/vista/distribution.md): See the shape of a numeric column in Vista with a histogram, a histogram with a density curve or a line or area distribution, and pick the right one. - [Scatter](https://oplema.com/docs/vista/scatter.md): Plot two measures against each other in Vista with a scatter plot, size points by a third in a bubble chart or show dense areas with a density plot. - [Part to whole](https://oplema.com/docs/vista/part-to-whole.md): Show how a total splits into parts in Vista with pie and donut charts, treemaps, sunbursts and waffle charts, and see which suits few or many parts. - [Heatmaps](https://oplema.com/docs/vista/heatmaps.md): Color a grid by value in Vista with a matrix heatmap, a correlation matrix or a calendar heatmap, and see which one fits categories, columns or dates. - [Comparison](https://oplema.com/docs/vista/comparison.md): Compare items across several measures at once in Vista with a radar chart for a few profiles or parallel coordinates for many rows and outliers. - [Timelines](https://oplema.com/docs/vista/timelines.md): Plan and show dates in Vista: draw tasks as bars with a Gantt chart or put milestones on a line with an event timeline, and pick the one that fits. - [Tables](https://oplema.com/docs/vista/tables.md): Show data as rows in Vista: raw rows with Table, data quality with Summary, a polished Formatted table for readers or totals with a Pivot table. - [Metrics](https://oplema.com/docs/vista/metrics.md): Show one calculated value on a dashboard in Vista: a headline Number, Progress toward a target, a Gauge on a range or a Status verdict. - [Controls](https://oplema.com/docs/vista/controls.md): Let readers change a dashboard with Filter and Parameter controls, explain chart colors with Legend or type a small table with Manual Input in Vista. - [Content](https://oplema.com/docs/vista/content.md): Content visuals explain a Vista dashboard. The group holds Text, for titles and notes that can show values calculated from a source inside a sentence. - [Developer (Vista visuals)](https://oplema.com/docs/vista/developer.md): Draw a custom plot with Python or R from one Vista source when the built-in charts don't cover what you need. The first plot loads the runtime. - [Columns](https://oplema.com/docs/vista/bars-columns/columns.md): Make a column chart in Vista: compare one calculated value across categories or time periods, with a live example you can edit. - [Stacked columns](https://oplema.com/docs/vista/bars-columns/stacked-columns.md): Make a stacked column chart in Vista: show each category's total and the parts that make it up, split by a second column. - [100% stacked columns](https://oplema.com/docs/vista/bars-columns/100-stacked-columns.md): Make a 100% stacked column chart in Vista: every column fills the height, so you can compare each category's mix as shares. - [Horizontal bars](https://oplema.com/docs/vista/bars-columns/horizontal-bars.md): Make a horizontal bar chart in Vista: compare one calculated value across categories with room for long or numerous labels. - [Stacked horizontal bars](https://oplema.com/docs/vista/bars-columns/stacked-horizontal-bars.md): Make a stacked horizontal bar chart in Vista: split each bar into parts to compare category totals that have long labels. - [100% stacked horizontal bars](https://oplema.com/docs/vista/bars-columns/100-stacked-horizontal-bars.md): Make a 100% stacked horizontal bar chart in Vista: every bar fills the width, showing each category's mix as shares, even with long labels. - [Radial bars](https://oplema.com/docs/vista/bars-columns/radial-bars.md): Make a radial bar chart in Vista, with one bar per category around a circle. It suits a few categories, and Columns compare values more exactly. - [Line](https://oplema.com/docs/vista/lines-areas/line.md): Make a line chart or line graph in Vista: follow one calculated value over time or any other ordered axis, with a live example. - [Stacked lines](https://oplema.com/docs/vista/lines-areas/stacked-lines.md): Plot several series on one axis in Vista with Stacked lines: one line per value of a second column, each at its own value. - [Area](https://oplema.com/docs/vista/lines-areas/area.md): Make an area chart in Vista: a trend with the space beneath it filled, to give weight to the size of a value over time or along another ordered axis. - [Stacked area](https://oplema.com/docs/vista/lines-areas/stacked-area.md): Make a stacked area chart in Vista: pile several series on each other to show a total over time and how much each one adds. - [100% stacked area](https://oplema.com/docs/vista/lines-areas/100-stacked-area.md): Make a 100% stacked area chart in Vista to show how each series' share changes over time. Every point is scaled to the same height, so totals are hidden. - [Horizontal line](https://oplema.com/docs/vista/lines-areas/horizontal-line.md): Draw a trend along a vertical axis in Vista with Horizontal line: the line runs top to bottom, so ordered labels sit in rows. - [Horizontal stacked lines](https://oplema.com/docs/vista/lines-areas/horizontal-stacked-lines.md): Build up cumulative series along a vertical axis in Vista with Horizontal stacked lines, while tooltips show each point's own value. - [Horizontal area](https://oplema.com/docs/vista/lines-areas/horizontal-area.md): Fill in a trend along a vertical axis in Vista with Horizontal area: categories run down the side and the value extends across. - [Horizontal stacked area](https://oplema.com/docs/vista/lines-areas/horizontal-stacked-area.md): Pile filled series along a vertical axis in Vista with Horizontal stacked area, to show a cumulative total across labeled rows. - [Horizontal 100% stacked area](https://oplema.com/docs/vista/lines-areas/horizontal-100-stacked-area.md): Show a changing mix along a vertical axis in Vista with Horizontal 100% stacked area: every row fills the width, split into shares. - [Histogram](https://oplema.com/docs/vista/distribution/histogram.md): Make a histogram in Vista: group the numbers in one column into bins and count the rows per bin to see the shape of the data. - [Histogram with density curve](https://oplema.com/docs/vista/distribution/histogram-with-density-curve.md): Add a smoothed density curve (KDE) to a histogram in Vista, to see the shape of a numeric distribution without its bin edges. - [Line distribution](https://oplema.com/docs/vista/distribution/line-distribution.md): Draw a distribution as a line in Vista: a frequency polygon that keeps overlaid groups readable where columns would hide each other. - [Area distribution](https://oplema.com/docs/vista/distribution/area-distribution.md): Draw a distribution as a filled area in Vista, to give the overall shape of a column's values more visual weight on a dashboard. - [Scatter plot](https://oplema.com/docs/vista/scatter/scatter-plot.md): Make a scatter plot in Vista: plot two numeric columns against each other to see whether they move together, with a live example. - [Bubble chart](https://oplema.com/docs/vista/scatter/bubble-chart.md): Make a bubble chart in Vista: plot two measures as points and size each bubble by a third, to compare three numbers at once. - [Density plot](https://oplema.com/docs/vista/scatter/density-plot.md): Make a 2D density plot in Vista: show where pairs of values concentrate, with contours, when there are too many points to read. - [Pie chart](https://oplema.com/docs/vista/part-to-whole/pie-chart.md): Make a pie chart or donut chart in Vista: show how a total splits into a few parts when the share matters more than the number. - [Treemap](https://oplema.com/docs/vista/part-to-whole/treemap.md): Make a treemap in Vista: show the shares of a total as nested tiles, which stay readable with many parts or two levels of category. - [Sunburst](https://oplema.com/docs/vista/part-to-whole/sunburst.md): Make a sunburst chart in Vista: show the shares of a total across several nested levels as rings, with up to four split levels. - [Waffle chart](https://oplema.com/docs/vista/part-to-whole/waffle-chart.md): Make a waffle chart in Vista: show shares of a total as a grid of tiles, an easy-to-count alternative to a pie for simple proportions. - [Matrix heatmap](https://oplema.com/docs/vista/heatmaps/matrix-heatmap.md): Make a matrix heatmap in Vista that colors one cell per pair of categories by a calculated value, such as cups by store and drink, up to 10,000 cells. - [Correlation matrix](https://oplema.com/docs/vista/heatmaps/correlation-matrix.md): Make a correlation matrix in Vista: see the Pearson correlation between 2 to 24 numeric columns as a colored grid, with a live example. - [Calendar heatmap](https://oplema.com/docs/vista/heatmaps/calendar-heatmap.md): Make a calendar heatmap in Vista: color each day of the year by a value to spot daily and weekly patterns, in the style of a contribution graph. - [Radar chart](https://oplema.com/docs/vista/comparison/radar-chart.md): Make a radar chart or spider chart in Vista: compare the profile of a few items across several measures, as one shape per item. - [Parallel coordinates](https://oplema.com/docs/vista/comparison/parallel-coordinates.md): Make a parallel coordinates chart in Vista: trace each row as one line across several axes to spot patterns and outliers. - [Gantt chart](https://oplema.com/docs/vista/timelines/gantt-chart.md): Make a Gantt chart in Vista: draw tasks as bars between start and end dates, with swimlanes and milestones, for project schedules. - [Event timeline](https://oplema.com/docs/vista/timelines/event-timeline.md): Make an event timeline in Vista: put dated events on a line as callouts, for milestones, launches and histories of change. - [Table](https://oplema.com/docs/vista/tables/table.md): Show the raw rows of a source on a Vista dashboard with the Table visual. It lists column names and types and marks NULL values so gaps stand out. - [Summary](https://oplema.com/docs/vista/tables/summary.md): Check each column of a source for its type and null, empty and distinct value counts with the Summary visual, to spot data quality issues in Vista. - [Formatted table](https://oplema.com/docs/vista/tables/formatted-table.md): Present source rows with chosen columns, number formats, totals and conditional formatting using the Formatted table visual in Vista. - [Pivot table](https://oplema.com/docs/vista/tables/pivot-table.md): Group source rows into rows, columns and values and add subtotals and totals with the Pivot table visual, to summarize data on a Vista dashboard. - [Number (Vista visual)](https://oplema.com/docs/vista/metrics/number.md): Show one headline value such as a KPI, calculated from source rows, with an optional comparison and status using the Number visual in Vista. - [Progress](https://oplema.com/docs/vista/metrics/progress.md): Track progress from a start value toward a target with a bar, a percentage and a label using the Progress visual on a Vista dashboard. - [Gauge](https://oplema.com/docs/vista/metrics/gauge.md): Show a calculated value on a fixed range with a Gauge in Vista, with an optional target and colored status zones so readers see where it stands. - [Status](https://oplema.com/docs/vista/metrics/status.md): Show a labeled good, warning or needs-attention state set by numeric thresholds using the Status visual, so readers see at a glance what needs action. - [Manual Input (Vista control)](https://oplema.com/docs/vista/controls/manual-input.md): Type a small table directly on a Vista dashboard with Manual Input, then read it in a Strata flow through the Vista Parameter block. - [Filter (Vista control)](https://oplema.com/docs/vista/controls/filter.md): Let readers narrow the visuals on one page, on chosen visuals or on every page that uses a source, with the Filter control on a Vista dashboard. - [Parameter](https://oplema.com/docs/vista/controls/parameter.md): Show a value readers can change on a dashboard, and use it in a calculation or a Strata block setting, with the Parameter control. - [Legend](https://oplema.com/docs/vista/controls/legend.md): Place a chart legend anywhere on a Vista dashboard to explain what each color means. Connect it to a filter, and selecting a value filters the data too. - [Text](https://oplema.com/docs/vista/content/text.md): Add titles and explanations to a dashboard, with values calculated from a source shown inside the text, using the Text visual in Vista. - [Python (Vista visual)](https://oplema.com/docs/vista/developer/python.md): Draw a custom Matplotlib plot in Vista with Python, reading one source as a Polars DataFrame, for charts the built-in visuals don't cover. - [R (Vista visual)](https://oplema.com/docs/vista/developer/r.md): Draw a custom plot in Vista with R, reading one source as a data.frame, for charts the built-in visuals don't cover. Write the code in the visual. ## Cloud - [What is Cloud?](https://oplema.com/docs/cloud/what-is-cloud.md): Cloud is where Oplema stores projects and files, runs schedules and publishes dashboards. Learn the layout and what it costs. - [Cloud documentation](https://oplema.com/docs/cloud.md): Store files, sync projects, schedule flows, check run history, publish dashboards and share projects in Oplema Cloud, with a guide for each task. - [Files](https://oplema.com/docs/cloud/files.md): Upload files to Oplema Cloud, organize them in folders, use them in a flow and check supported file types and storage limits. - [Publish a dashboard (Cloud guide)](https://oplema.com/docs/cloud/publish.md): Choose who can open a published dashboard: people, teams or anyone with the link. Republish after changes, unpublish it and see what viewers can read. - [Run history](https://oplema.com/docs/cloud/run-history.md): Find a scheduled run's result, time, cost, version and output files in Run history, and learn what each run state means. - [Scheduling](https://oplema.com/docs/cloud/scheduling.md): Create a schedule that runs a Strata flow as a hosted run in your region. Choose its timing and version, then pause, resume or delete it. - [Sharing](https://oplema.com/docs/cloud/sharing.md): Give people and teams access to a project, folder or file in Oplema Cloud, create Viewer and Editor links and grant access to its files. - [Sync](https://oplema.com/docs/cloud/sync.md): See what syncs to Cloud and when, where your work lives and how to fix a paused sync when two devices change the same project. ## Elara - [What is Elara?](https://oplema.com/docs/elara/what-is-elara.md): Elara is an AI assistant that reads and edits your Strata flow and Vista dashboard. Learn what a turn is, what it costs and how to stop it. - [Elara documentation](https://oplema.com/docs/elara.md): Set up Elara with a model, ask it to build or change flows and dashboards, see the nine tools it can use and learn what each turn costs. - [Elara in Strata](https://oplema.com/docs/elara/in-strata.md): Ask Elara to build or fix a Strata flow: what to type, how it checks its work with previews, what it costs and how to review the result. - [Elara in Vista](https://oplema.com/docs/elara/in-vista.md): Ask Elara to add or change visuals and pages in Vista. It edits the dashboard script and page list, and uses the tables from your flow. - [Set up Elara](https://oplema.com/docs/elara/setup.md): Connect Elara to a hosted model, your own API key (BYOK) or a local model such as Ollama, and see what each option costs and how to fix common failures. - [What Elara can do](https://oplema.com/docs/elara/what-it-can-touch.md): See what each of Elara's nine tools does: search blocks, read and edit scripts, manage pages, inspect previews, run flows and change settings. ## Echo - [What is Echo?](https://oplema.com/docs/echo/what-is-echo.md): Echo keeps saved versions of your flow and dashboard. It runs in your browser, autosaves and syncs to Cloud. Learn what's kept and what isn't. - [Echo documentation](https://oplema.com/docs/echo.md): Save versions of your flow and dashboard, compare one with your current work, open earlier work and review Elara's changes with Echo version history. - [Diffs](https://oplema.com/docs/echo/diffs.md): Compare any saved version with your current work. Logic, Canvas, Script and Full each show a different part of what changed. - [Elara turns](https://oplema.com/docs/echo/elara.md): Review each change Elara makes to your project as one saved version, and go back to the version before it with Open if you don't want it. - [Saves](https://oplema.com/docs/echo/saves.md): Save a named version, open an earlier one, return to your unsaved work, discard changes and understand automatic branches. ## Console - [What is Console?](https://oplema.com/docs/console/what-is-console.md): See what Console shows and who sees each part: the account list, usage by account, usage left, top-ups, team members and storage. - [Console documentation](https://oplema.com/docs/console.md): Create teams, set member roles, top up usage, fund a team and manage your plan and invoices in Oplema Console, with a guide for each task. - [Billing](https://oplema.com/docs/console/billing.md): Subscribe to a plan, switch or cancel it, find your invoices and see how refunds work. Payments and invoices are handled by Paddle. - [Roles](https://oplema.com/docs/console/roles.md): See what Owner, Admin, Editor and Viewer can each do, both in a team and on shared projects, folders and files, so you can pick the right role. - [Teams](https://oplema.com/docs/console/teams.md): Create a team in Console, add members who already have an account, set their roles, transfer ownership or delete the team when it is no longer needed. - [Usage and top-ups](https://oplema.com/docs/console/usage-and-top-up.md): Learn where usage comes from, the order it's spent in and what happens at zero, then top up, fund a team and set limits for its members.