xmetric vs Hex: Zero-Setup Shelf Analytics vs Reactive SQL/Python Notebooks

Direct shelf manipulation vs reactive notebook cells

Hex combines SQL cells, Python cells, and display widgets inside a reactive cloud notebook. That architecture is ideal when a data scientist wants to chain a Snowflake SQL query into a Pandas dataframe and fit a Python model.

However, when you want to answer rapid business questions from a local dataset or a .twbx workbook, a notebook workflow adds overhead:

1. Waiting for cloud containers and cell re-runs: Hex uploads files to its cloud project storage (/hex directory, up to 100 files per project and 2 GB per file) and runs queries on remote compute kernels. In xmetric, your file stays in your browser with no upload.
2. Shelves and marks vs cell dependencies: In xmetric, breaking a metric down by cohort on Rows and region on Columns is two drags on shelves. In a notebook, changing the grouping grain often means rewriting upstream SQL GROUP BY cells or chaining new pivot cells.
3. Opening .twbx workbooks: Hex cannot open or inspect packaged Tableau .twbx or .twb files. xmetric opens them in the app, and its workbook inspector lists their sheets, data sources and calculated fields.

Comparing a multi-grain calculation: xmetric LOD vs SQL/Python in Hex

Suppose you want to filter a chart to show only customers whose lifetime spend exceeds 5,000, while still plotting their monthly order totals.

In xmetric (one calculated field; you can also test it in the formula playground):

{ FIXED [Customer ID] : SUM([Order Amount]) } > 5000

Equivalent SQL cell in Hex (or any SQL warehouse):

WITH high_value_customers AS (
  SELECT customer_id
  FROM orders
  GROUP BY customer_id
  HAVING SUM(order_amount) > 5000
)
SELECT
  DATE_TRUNC('month', o.order_date) AS order_month,
  SUM(o.order_amount) AS monthly_revenue
FROM orders o
JOIN high_value_customers h ON o.customer_id = h.customer_id
GROUP BY 1
ORDER BY 1;

Pricing and compute limits

Hex offers a free Community plan (up to 5 projects, small compute profile, Hex agent trial only, and no user cap), a Professional plan at $36 per Editor / month, a Team plan at $75 per Editor / month, and custom Enterprise pricing.

xmetric is free in your browser, and your data stays on your own machine unless you save a workbook online.

Spec comparison: xmetric vs Hex