# xmetric

> xmetric opens Power BI .pbix reports and Tableau .twbx and .twb workbooks in your browser. You can also build charts from CSV, Excel (.xlsx) and Parquet files at https://getxmetric.com/app/.

Status (2026-10-27): the public browser app supports BI report pages, workbook dashboards and filters, plus charts built with fields on shelves. Support depends on the workbook features and available data; an unpackaged .twb may need its companion data files.

Opening a local file needs no desktop install or sign-in. Files are read in your browser; uploading for saved or shared workbooks happens only when you explicitly choose Save.

Agent integration: the public xmetric MCP endpoint is live at https://getxmetric.com/mcp. Protocol verification (2026-10-28, release 5ccce8d9): MCP initialize returned HTTP 200. ChatGPT and Claude host integration and directory listings remain unverified.

Use the per-function JSON for structured data: https://getxmetric.com/reference/<slug>.json

## Works today

- [xmetric app](https://getxmetric.com/app/): open Power BI .pbix reports and Tableau .twbx/.twb workbooks, or chart CSV, Excel (.xlsx) and Parquet files. Local reading stays in the browser; Save uploads a workbook for saving or sharing. An unpackaged .twb may need its companion data files.
- [Workbook inspector](https://getxmetric.com/inspect/): reads .twbx/.twb/.pbix files and zipped .pbip projects in the browser and lists data sources, calculated fields with formulas, dependencies, sheets, and broken, unused or duplicate calculations; exports the result as JSON. Nothing is uploaded.
- [Formula playground](https://getxmetric.com/play/): run Tableau calculations, DuckDB SQL and scalar DAX measures on editable rows or your CSV in the browser; results run independently.
- [SQL functions](https://getxmetric.com/reference/sql/): runnable SQL examples on your own rows.
- [DAX measures](https://getxmetric.com/reference/dax/): runnable single-table DAX measure examples on your own rows.
- [Calculation errors](https://getxmetric.com/errors/): reproduce a Tableau calculation error and test a fix on sample rows or your own CSV.

## Guides

- [xmetric vs Tableau](https://getxmetric.com/compare/xmetric-vs-tableau/): Prices, free options, .twbx support and where data is processed, with sources checked 2026-10-17; where Tableau is better today.
- [xmetric vs Tableau Public](https://getxmetric.com/compare/xmetric-vs-tableau-public/): When data can't be public: what Tableau Public publishes, Tableau Desktop Free Edition, and a private CSV chart and .twbx opener in the browser.
- [Tableau Reader alternative: open a .twbx in your browser, on any OS](https://getxmetric.com/alternatives/tableau-reader-alternative/): Open your .twbx below with xmetric in your browser. The app renders supported dashboards and worksheets and provides supported filters. No install or account is needed to open a local file. Some layouts, calculations and interactions can differ from Tableau.
- [Open a .twbx on a Mac](https://getxmetric.com/open/twbx-on-mac/): Three ways to open a Tableau packaged workbook on macOS, and an in-browser opener that lists its contents and extracts its data.
- [Stripe export: cohort retention](https://getxmetric.com/use-cases/stripe-cohort-retention/): Monthly cohort retention from the Stripe Dashboard payments CSV, with the Tableau formula, DuckDB SQL and an agent prompt; runs on your export in the browser.
- [xmetric vs Power BI on a Mac or Linux](https://getxmetric.com/compare/xmetric-vs-power-bi/): Power BI Desktop is Windows-only; open a .pbix in the browser to see its pages, visuals and fields (a zipped .pbip also shows DAX); where Power BI is better.
- [xmetric vs Looker Studio (Data Studio)](https://getxmetric.com/compare/xmetric-vs-looker-studio/): Chart a CSV in the browser without Google Sheets or an upload; how Data Studio handles CSV uploads and Parquet; where Data Studio is better.
- [xmetric vs Julius AI: Credits, Local Privacy & BI](https://getxmetric.com/compare/xmetric-vs-julius-ai/): Compare xmetric, free browser BI where files stay local, and Julius AI, a credit-metered cloud chat assistant with Plus, Pro and Business plans.
- [xmetric vs Metabase: Zero-Server Browser BI vs SQL Portal](https://getxmetric.com/compare/xmetric-vs-metabase/): Compare xmetric, free browser BI with no server to run, and Metabase, a database dashboard portal you self-host or buy as Metabase Cloud.
- [xmetric vs Hex: Local Browser BI vs Cloud Notebooks](https://getxmetric.com/compare/xmetric-vs-hex/): Compare xmetric, free browser BI with Tableau-style shelves, and Hex, a cloud SQL and Python notebook with a free Community plan and paid Editor seats.
- [xmetric vs Preset & Superset: Browser BI vs Cloud](https://getxmetric.com/compare/xmetric-vs-preset-superset/): Compare xmetric, free browser BI with Tableau-style shelves, to Preset (free up to 5 users, paid Professional) and self-hosted Apache Superset.
- [xmetric vs Lightdash: Ad-Hoc Browser BI vs YAML BI](https://getxmetric.com/compare/xmetric-vs-lightdash/): Compare xmetric, free browser BI for local files on Tableau-style shelves, and Lightdash, YAML-governed BI over a warehouse, self-hosted or on Cloud Pro.
- [xmetric vs Evidence & Observable: Shelves vs BI-as-Code](https://getxmetric.com/compare/xmetric-vs-evidence-observable/): Compare xmetric, free browser BI with Tableau-style shelves, to Evidence and Observable Framework, which build reports from Markdown, SQL and JavaScript.
- [Free Tableau Desktop Alternative in Your Browser (2026)](https://getxmetric.com/alternatives/tableau-desktop-alternative/): Need a free Tableau Desktop alternative? Open .twbx files, write LOD expressions, and build charts in your browser with xmetric. No desktop install.
- [Tableau Public Alternative for Private Data (No Upload)](https://getxmetric.com/alternatives/tableau-public-private-alternative/): Tableau Public makes every saved workbook public. Analyze confidential CSV, Excel, Parquet, and .twbx files locally in your browser with xmetric.
- [Power BI Alternative for Mac (Free, Runs in Browser)](https://getxmetric.com/alternatives/power-bi-alternative-mac/): Open your .pbix on a Mac with xmetric in your browser. Choose your file below to load its report pages and supported visuals, with no Windows virtual machine or installation. Your file is processed locally. Rendering and interactions can differ from Power BI.
- [Free Julius AI Alternative: Local Browser BI, No Cap](https://getxmetric.com/alternatives/julius-ai-alternative/): Hit the Julius AI free message limit or can't upload private spreadsheets? Explore CSV, Excel, and Parquet files locally in your browser with xmetric.
- [Looker Studio Alternative for Local CSV & Parquet Files](https://getxmetric.com/alternatives/looker-studio-alternative-local-csv-parquet/): Avoid Looker Studio CSV upload limits and cloud storage. Explore local CSV, Excel, and Parquet files in your browser with xmetric. Free, no upload.
- [How to Open a .twbx File Without Tableau Desktop](https://getxmetric.com/open/open-twbx-without-tableau/): Open your .twbx below to view supported dashboards and worksheets in xmetric in your browser, with supported filters and no installation. Your file is processed locally. Some layouts, calculations and interactions can differ from Tableau. Tableau Reader and ZIP extraction are other options described below.
- [How to Open a .twb File and Extract All Formulas](https://getxmetric.com/open/open-twb-xml-and-extract-formulas/): Parse .twb and .twbx workbooks in your browser to list every data source, calculated field formula, dependency, and sheet without reading raw XML.
- [Analyze Confidential CSV Files in Browser (No Upload)](https://getxmetric.com/open/analyze-csv-privately-in-browser/): Chart sensitive CSV files and run LOD calculations in your browser. Files opened on getxmetric.com are read locally and never uploaded.
- [How to Open and Chart Parquet Files in Your Browser](https://getxmetric.com/open/open-parquet-file-in-browser/): Open your .parquet in the xmetric browser viewer to inspect rows and columns without uploading the file. Choose your file below, review the table, then select Chart in xmetric to build an editable view from the same data.
- [Stripe export: MRR and churned MRR](https://getxmetric.com/use-cases/stripe-mrr-churn/): MRR by product, new MRR by start month and churned MRR by end month from the Stripe subscriptions export, annual plans normalized, using Stripe's active + past_due MRR definition; runs on your CSV in the browser.
- [Shopify Repeat Purchase Rate & LTV from CSV](https://getxmetric.com/use-cases/shopify-repeat-purchase-ltv-csv/): Deduplicate Shopify order line items, measure 30/60/90-day repeat purchase rates and chart customer LTV from your orders CSV, in your browser.
- [GA4 export: landing pages that waste traffic](https://getxmetric.com/use-cases/ga4-landing-page-report/): Ranks landing pages from a GA4 Landing page CSV by key events missed against the site rate and rolls them up by section; skips the # header lines and totals row; runs on your download in the browser.
- [GA4 export: traffic sources compared](https://getxmetric.com/use-cases/ga4-traffic-acquisition-sources/): Share of sessions vs share of key events per source / medium, and rates recomputed from counts by medium, from a GA4 Traffic acquisition CSV; runs on your download in the browser.
- [HubSpot Deal Stage Velocity from CSV Export](https://getxmetric.com/use-cases/hubspot-deal-stage-velocity/): Drop your HubSpot Deals or stage history CSV into xmetric to measure median days in each stage, spot stalled deals, and compare cycle time by owner.
- [Budget vs actual variance](https://getxmetric.com/recipes/budget-vs-actual-variance/): Budget vs actual when a monthly budget repeats on every invoice row: the Tableau INCLUDE fix and the SQL, recomputed from your CSV in the browser.
- [Monthly customer and MRR churn](https://getxmetric.com/recipes/customer-and-revenue-churn-rate/): Customer (logo) churn and MRR churn by month from a subscriptions file, with Tableau FIXED formulas and SQL; runs on your CSV in the browser.
- [COUNTD totals that do not add up](https://getxmetric.com/recipes/deduplicated-counts-countd-across-grains/): Why distinct counts per group exceed the distinct total, with Tableau COUNTD and INCLUDE formulas and SQL, checked on your CSV.
- [Date gaps and consecutive streaks](https://getxmetric.com/recipes/date-gaps-and-islands-streaks/): Missed days and consecutive daily streaks per user with Tableau LOOKUP and PREVIOUS_VALUE and the gaps-and-islands SQL, on your activity CSV.
- [Funnel conversion from an event log](https://getxmetric.com/recipes/funnel-conversion-drop-off/): Open and strict (in-order) funnel counts from an event log, with Tableau FIXED formulas and SQL; runs on your CSV.
- [Market basket: confidence and lift](https://getxmetric.com/recipes/market-basket-affinity-analysis/): Products bought with an anchor product, ranked by lift, with Tableau FIXED formulas and SQL; pick any anchor on your order lines CSV.
- [7-day and 28-day moving averages](https://getxmetric.com/recipes/moving-average-rolling-window/): Trailing moving averages with Tableau WINDOW_AVG and SQL window frames, checked against each other on your CSV.
- [New vs returning customers](https://getxmetric.com/recipes/new-vs-returning-customers/): New and returning customers and revenue by month from an orders CSV, with a FIXED first-order date in Tableau and a window MIN in SQL.
- [Ranking with ties](https://getxmetric.com/recipes/rank-with-ties-dense-competition/): How RANK, RANK_DENSE, RANK_MODIFIED, RANK_UNIQUE and RANK_PERCENTILE treat ties, with SQL equivalents, on your CSV.
- [RFM customer segmentation](https://getxmetric.com/recipes/rfm-customer-segmentation/): Recency, frequency and spend scores with per-customer percentile cut-offs, as Tableau formulas and SQL, on your orders CSV.
- [Running total by year](https://getxmetric.com/recipes/running-total-cumulative-sum/): Year-to-date and all-time running totals with Tableau RUNNING_SUM partitioning and SQL SUM OVER, on your CSV.
- [Same-store sales growth](https://getxmetric.com/recipes/same-store-sales-like-for-like/): Year-over-year growth for stores open in both years next to total growth, with Tableau FIXED and SQL, on your CSV.
- [Monthly seasonality index](https://getxmetric.com/recipes/seasonality-index-decomposition/): A seasonality index per calendar month and a 12-month moving-average ratio that removes growth, in Tableau and SQL, on your CSV.
- [Top N per category](https://getxmetric.com/recipes/top-n-per-category-with-other/): Rank products inside each category and label the rest Other, with RANK_UNIQUE in Tableau and ROW_NUMBER in SQL, on your CSV.
- [Weighted averages](https://getxmetric.com/recipes/weighted-average-by-group/): Volume-weighted average price per group next to plain AVG, as a Tableau formula and SQL, on your CSV.
- [Google Ads search terms: wasted spend](https://getxmetric.com/use-cases/google-ads-search-terms-waste/): Total each search term across the account, flag terms with no conversions anywhere, and compare cost per conversion by match type; runs on your downloaded CSV in the browser.
- [Audit data sources and Custom SQL in a .twbx](https://getxmetric.com/agents/audit-workbook-data-sources/): Lists every connection, table, join, Custom SQL query and extract in a .twbx or .twb, in the browser or with a standard-library Python script.
- [Build a Chart From a CSV With AI Without Uploading Data](https://getxmetric.com/agents/ai-agent-csv-chart-no-upload/): Chart sensitive CSV, Excel and Parquet files in your browser with xmetric. Ask an AI for formulas using only column names; raw rows stay on your device.
- [ChatGPT Local Dashboards: Public xmetric MCP Connection](https://getxmetric.com/agents/chatgpt-private-dashboards/): The public xmetric MCP endpoint is live. Connect where custom connections are supported; real ChatGPT/Claude host behavior and directory listings remain unverified.
- [How to Let Claude Code or Cursor Read a .twbx File](https://getxmetric.com/agents/claude-code-cursor-read-twbx/): Unpack a .twbx archive so Claude Code or Cursor can read the .twb XML, or drop the workbook into xmetric in your browser to inspect fields and LODs.
- [Dashboards as Code: Text BI Workbooks for Git & Agents](https://getxmetric.com/agents/dashboards-as-code-text-workbooks/): Why 50,000-line .twb XML files break Git diffs and agent context windows, and how xmetric's command model and workbook inspector fit coding workflows.
- [Explain Any Tableau LOD Expression in SQL & English](https://getxmetric.com/agents/explain-lod-expression-with-agent/): Read nested FIXED, INCLUDE and EXCLUDE formulas inside out: grain, filter order and exact SQL, plus a prompt template for AI agents.
- [How to Find Unused Calculated Fields in a .twbx File](https://getxmetric.com/agents/find-unused-calculated-fields/): Trace dependencies across worksheets, filters, and nested formulas to find unused calculated fields in a .twb or .twbx file, in your browser.
- [Tableau Table Calcs to SQL Window Functions Guide](https://getxmetric.com/agents/table-calcs-to-sql-window-functions/): Map Tableau addressing and partitioning pills directly to SQL PARTITION BY, ORDER BY, and ROWS BETWEEN frames for RUNNING_SUM, LOOKUP, RANK, and INDEX.
- [Convert Tableau Calculated Fields to dbt SQL Models](https://getxmetric.com/agents/tableau-calculations-to-dbt-models/): Extract row-level formulas, aggregates, and FIXED LOD expressions from a .twbx workbook and refactor them into staging and mart dbt SQL models.
- [Tableau Filter Order of Operations Mapped to SQL](https://getxmetric.com/agents/tableau-filter-order-of-operations-sql/): See which SQL clause matches each step in Tableau's filter pipeline, from context filters before FIXED LODs to HAVING and post-window filtering.
- [Tableau LOD vs Power BI DAX: Side-by-Side Translation](https://getxmetric.com/agents/tableau-lod-vs-power-bi-dax/): Side-by-side guide mapping Tableau FIXED, INCLUDE, and EXCLUDE LOD expressions to Power BI DAX CALCULATE, ALLEXCEPT, REMOVEFILTERS, and ALL.
- [Tableau to DuckDB SQL Migration Guide and Formula Map](https://getxmetric.com/agents/tableau-to-duckdb-sql-migration/): Convert Tableau calculated fields, FIXED LOD expressions, date functions, and table calculations into standard DuckDB SQL for local analytics.
- [How to Diff and Review a .twbx Workbook With an Agent](https://getxmetric.com/agents/workbook-diff-review-with-agent/): Compare two versions of a .twb or .twbx workbook without noisy XML layout diffs: review changed calculated fields, filters, and shelves.
- [Hex & Mode Alternative for Instant Ad-Hoc Exploration](https://getxmetric.com/alternatives/hex-mode-alternative-ad-hoc-exploration/): Need ad-hoc charts without spinning up a cloud notebook or warehouse connection? Drag shelves, write LODs, and explore local files in xmetric.
- [Metabase & Superset Alternative Without Server Setup](https://getxmetric.com/alternatives/metabase-superset-alternative-no-server/): Skip Docker containers and database imports just to chart a CSV or Parquet file. Run BI in your browser with xmetric. Free, no server setup.
- [Best BI Tool for Local DuckDB and Parquet Files](https://getxmetric.com/guides/best-bi-tool-local-duckdb-parquet/): Explore local Parquet and CSV files with drag-and-drop shelves and LOD formulas in your browser. Compare xmetric, Evidence, and Apache Superset.
- [Best BI Tool for Mac Startups: Top 3 Compared](https://getxmetric.com/guides/best-bi-tool-mac-startups/): Compare native Mac browser BI options for startups. See how xmetric, Metabase, and Tableau handle local CSVs, .twbx files, and macOS workflows.
- [Best Free BI Tool for Freelance Consultants (2026)](https://getxmetric.com/guides/best-free-bi-tool-freelance-consultants/): Compare xmetric, Data Studio (formerly Looker Studio), and Power BI for freelance consultants analyzing client CSVs and .twbx files without per-seat fees.
- [Best Free BI Tool for Nonprofits and Grant Data](https://getxmetric.com/guides/best-free-bi-tool-nonprofits/): Analyze donor CSVs and grant data in your browser without uploading sensitive PII to a public cloud. Compare xmetric, Data Studio, and Tableau.
- [Best Free BI Tool for Students and Data Classes](https://getxmetric.com/guides/best-free-bi-tool-students/): Learn shelves, marks, LOD expressions, and table calculations in your browser without a license key or Windows PC. Compare student BI options.
- [Best Tools to Open Tableau Files Without a License](https://getxmetric.com/guides/best-tool-open-tableau-files-without-license/): Compare xmetric, Tableau Desktop Free Edition, Tableau Reader, and Tableau Public for opening .twbx and .twb workbooks without a paid Creator seat.
- [Best BI Tool for Agencies With Client Data](https://getxmetric.com/guides/bi-tools-agencies-sharing-client-dashboards/): Compare agency reporting tools by seat cost, connector fees, and data isolation. Open client workbooks and chart CSVs in the browser with xmetric.
- [BI Tools That Run Fully in the Browser Compared](https://getxmetric.com/guides/bi-tools-that-run-in-browser/): Not every browser BI tool runs locally. Compare client-side execution in xmetric against cloud-hosted browser tools like Data Studio and Hex.
- [ChatGPT Data Analysis Alternative: Private Browser BI](https://getxmetric.com/guides/chatgpt-data-analysis-alternative-local-browser/): Don't upload confidential CSVs to a cloud chat window for static charts. Analyze files locally in your browser with interactive shelves in xmetric.
- [How to Build KPI Summary Cards With Period Deltas](https://getxmetric.com/guides/kpi-cards/): Build clean KPI cards showing current-period totals, prior-period comparisons, and percent change using LOD expressions or LOOKUP on your own CSV.
- [How to Plot Latitude and Longitude Maps From a CSV](https://getxmetric.com/guides/maps-lat-long/): Plot store locations, deliveries, or events from latitude and longitude columns in a CSV: shelf steps, spatial binning, and Haversine SQL.
- [Private Data Analysis Tools That Never Upload Data](https://getxmetric.com/guides/private-data-analysis-tools-no-upload/): Analyze confidential payroll, financial, and health CSVs without sending rows to a remote server. Compare xmetric, Tableau Desktop, and cloud AI tools.
- [How to Build a Small Multiples Trellis Chart](https://getxmetric.com/guides/small-multiples-chart/): Split a busy multi-line chart into a grid of small multiples using dimension pills or row/column index table calculations in your browser.
- [How to Build a Waterfall Chart With Running Totals](https://getxmetric.com/guides/waterfall-chart/): Construct a variance or cash-flow waterfall chart using RUNNING_SUM and negative Gantt bar sizing on your own CSV data in the browser.
- [xmetric vs Metabase vs Data Studio for Teams](https://getxmetric.com/guides/xmetric-vs-metabase-vs-looker-studio-small-teams/): Compare setup time, hosting cost, SQL/LOD support, and file handling across xmetric, Metabase, and Data Studio for teams of 2 to 20 people.
- [Open and Chart Excel (.xlsx) Files Privately in Browser](https://getxmetric.com/open/open-large-excel-xlsx-in-browser/): Open .xlsx exports in your browser and analyze them with shelves and LOD expressions. Your financial sheets stay on your computer, never uploaded.
- [How to Open and Query a .hyper Extract File](https://getxmetric.com/open/read-hyper-extract-file/): Open packaged .twbx extracts in your browser with xmetric, or read standalone .hyper files with Python and SQL to export clean CSV data.
- [How to Extract Data and SQL from a .twbx Workbook](https://getxmetric.com/open/unpack-twbx-to-csv-and-sql/): Extract packaged data and every calculated field formula from a .twbx workbook in your browser, then translate the logic into clean SQL.
- [How to Open Tableau Workbooks Privately (No Upload)](https://getxmetric.com/open/view-tableau-workbook-privately-no-upload/): Unlike publishing to Tableau Public, xmetric opens .twbx files and charts your data locally in your browser. Confidential data stays on your device.
- [Monthly cohort analysis on your CSV: retention, Tableau and SQL](https://getxmetric.com/recipes/cohort-retention-fixed-lod/): Calculate observed monthly customer retention from text customer IDs and dates in your CSV. Keep cohort sizes fixed, show observed zero activity and omit future ages.
- [Median, P90 & P95 by Group in Tableau and DuckDB SQL](https://getxmetric.com/recipes/median-and-percentiles-by-group/): Compute grouped medians and P90/P95 percentiles on skewed data in Tableau and DuckDB SQL (MEDIAN and QUANTILE_CONT), and avoid the common traps.
- [Pareto 80/20 Cumulative Curve in Tableau & DuckDB SQL](https://getxmetric.com/recipes/pareto-80-20-analysis/): Find the top 20% of products or customers driving 80% of revenue with Tableau table calcs and DuckDB window SQL, plus the edge cases.
- [Percent of Total in Tableau (LOD vs Table Calc) & SQL](https://getxmetric.com/recipes/percent-of-total-filtered/): Keep your percent-of-total denominator stable when filtering views, using Tableau FIXED/EXCLUDE LODs and DuckDB SQL window totals.
- [YoY and YTD Sales Formulas in Tableau and DuckDB SQL](https://getxmetric.com/recipes/yoy-ytd-comparison/): Write YoY and matched YTD formulas in Tableau and DuckDB SQL without partial-month distortion, including leap years and fiscal years.
- [QuickBooks AR Aging Buckets & DSO from CSV Export](https://getxmetric.com/use-cases/quickbooks-ar-aging-buckets-csv/): Chart 1-30, 31-60, 61-90 and 90+ day overdue balances from your QuickBooks A/R Aging Detail or Open Invoices export, in your browser.
- [QuickBooks Expense Trends & Vendor Spend from CSV](https://getxmetric.com/use-cases/quickbooks-expense-trends-vendor-spend-csv/): Spot month-over-month spend spikes and vendor concentration from your QuickBooks Transaction Detail or Expenses by Vendor export, in your browser.
- [QuickBooks Budget vs Actual Variance Bridge CSV](https://getxmetric.com/use-cases/quickbooks-variance-bridge-csv/): Build a waterfall variance bridge from your QuickBooks Profit and Loss or Budget vs. Actuals export, in your browser with xmetric.
- [Shopify AOV Trend & Basket Size from Orders CSV](https://getxmetric.com/use-cases/shopify-aov-trend-basket-size-csv/): Split Shopify AOV trends into units per transaction and average item price from your orders CSV, without line-item double counting.
- [Shopify Customer Cohort Retention Table from CSV](https://getxmetric.com/use-cases/shopify-customer-cohort-retention-csv/): Group Shopify buyers by first order month and chart monthly buyer and revenue retention from your orders CSV, in your browser.
- [Analyze Shopify Discount Codes & Margin from CSV](https://getxmetric.com/use-cases/shopify-discount-code-margin-csv/): Compare discounted vs full-price AOV, repeat buyer rates and promo code leakage from your Shopify orders CSV, in your browser.
- [Shopify Product Mix & 80/20 SKU Pareto from CSV](https://getxmetric.com/use-cases/shopify-product-mix-pareto-csv/): Rank Shopify SKUs by net sales, build an 80/20 Pareto curve and spot first-order hero products from your orders CSV, in your browser.
- [Analyze Stripe Failed Payments & Recovery CSV](https://getxmetric.com/use-cases/stripe-failed-payments-recovery-csv/): Measure involuntary churn, decline codes and retry recovery rates from your Stripe payments or invoices CSV, with xmetric in your browser.
- [Calculate Stripe LTV by Plan from CSV Export](https://getxmetric.com/use-cases/stripe-ltv-by-plan-csv/): Compare realized and formula LTV across Stripe pricing tiers and billing intervals from your subscriptions or invoices CSV, in the browser.
- [Calculate Stripe Net Revenue Retention (NRR) CSV](https://getxmetric.com/use-cases/stripe-net-revenue-retention-csv/): Compute trailing 12-month Net Revenue Retention (NRR) and Gross Revenue Retention (GRR) from your Stripe invoices CSV, in your browser.
- [GA4 Channel Attribution & Spend CSV Analysis](https://getxmetric.com/use-cases/ga4-channel-attribution-roas/): Analyze a GA4 Traffic acquisition CSV with cost data in your browser. Compute CAC, ROAS and cost per engaged session with LOD expressions.
- [GA4 Content Decay Curve from Pages & Screens CSV](https://getxmetric.com/use-cases/ga4-content-decay-curve/): Drop your GA4 Pages and screens CSV export into xmetric to flag articles losing organic views from their peak month using FIXED LOD expressions.
- [GA4 Landing Page Conversion Funnel from CSV (Free)](https://getxmetric.com/use-cases/ga4-landing-page-funnel/): Drop your GA4 Landing page CSV export into xmetric to chart session-to-conversion rates by page in your browser, with no API quotas.
- [GA4 Search Console Query CTR Curve from CSV](https://getxmetric.com/use-cases/ga4-search-console-query-ctr/): Drop your GA4 Google organic search queries CSV into xmetric to plot CTR by average position and find high-impression pages with weak click rates.
- [HubSpot Lead Source to Revenue Analysis from CSV](https://getxmetric.com/use-cases/hubspot-lead-source-attribution/): Drop your HubSpot Contacts or Deals CSV into xmetric to chart lead-to-customer rate, pipeline generated, and closed revenue by Original Source.
- [HubSpot Pipeline Waterfall Chart from Deals CSV](https://getxmetric.com/use-cases/hubspot-pipeline-waterfall/): Drop your HubSpot Deals CSV export into xmetric to build a period-over-period pipeline bridge showing new, expanded, pushed, won, and lost deal value.
- [HubSpot Win Rate by Cohort & Rep from Deals CSV](https://getxmetric.com/use-cases/hubspot-win-rate-analysis/): Drop your HubSpot Deals CSV into xmetric to calculate count and dollar win rates by creation cohort, deal size band, and owner in your browser.
- [Jira Cycle Time & Sprint Throughput from CSV](https://getxmetric.com/use-cases/jira-cycle-time-throughput/): Drop your Jira Issues CSV export into xmetric to chart lead time percentiles, sprint velocity, and bug escape rates locally in your browser.
- [Meta Ads Creative Fatigue & ROAS from CSV Export](https://getxmetric.com/use-cases/meta-ads-creative-fatigue-roas/): Drop your Meta Ads Manager CSV export into xmetric to plot CPA and ROAS against ad frequency and daily spend without paying for spreadsheet connectors.
- [Zendesk First Reply & Resolution Time from CSV](https://getxmetric.com/use-cases/zendesk-ticket-sla-resolution/): Drop your Zendesk Tickets CSV export into xmetric to analyze first reply time, full resolution percentiles, and backlog aging by channel and group.
- [Chart makers on your data](https://getxmetric.com/make/): Choose a chart, paste or drop your data, edit the fields and download SVG or continue in xmetric.
- [Bar chart maker](https://getxmetric.com/make/bar-chart-maker/): Make an editable chart from your own local file or pasted CSV. Compare totals across categories. Download SVG or continue in xmetric.
- [Line graph maker](https://getxmetric.com/make/line-graph-maker/): Make an editable chart from your own local file or pasted CSV. Follow values across an ordered series. Download SVG or continue in xmetric.
- [Scatter plot maker](https://getxmetric.com/make/scatter-plot-maker/): Make an editable chart from your own local file or pasted CSV. Compare two numeric columns as individual observations. Download SVG or continue in xmetric.
- [Bubble chart maker](https://getxmetric.com/make/bubble-chart-maker/): Make an editable chart from your own local file or pasted CSV. Compare numeric coordinates and encode a third numeric column as bubble size. Download SVG or continue in xmetric.
- [Dot plot maker](https://getxmetric.com/make/dot-plot-maker/): Make an editable chart from your own local file or pasted CSV. Compare category totals with dots on a numeric axis. Download SVG or continue in xmetric.
- [Stacked bar chart maker](https://getxmetric.com/make/stacked-bar-chart-maker/): Make an editable chart from your own local file or pasted CSV. Compare category totals split into a series. Download SVG or continue in xmetric.
- [Stacked area chart maker](https://getxmetric.com/make/stacked-area-chart-maker/): Make an editable chart from your own local file or pasted CSV. Show how a total and its component series change across an ordered axis. Download SVG or continue in xmetric.
- [Pie chart maker](https://getxmetric.com/make/pie-chart-maker/): Make an editable chart from your own local file or pasted CSV. Compare categories as portions of an aggregated total. Use nonnegative values. Download SVG or continue in xmetric.
- [Histogram maker](https://getxmetric.com/make/histogram-maker/): Make an editable chart from your own local file or pasted CSV. Count numeric observations in equal-width bins you can edit. Download SVG or continue in xmetric.
- [Frequency table maker](https://getxmetric.com/make/frequency-table-maker/): Make an editable chart from your own local file or pasted CSV. Count how often each category appears in your data. Download SVG or continue in xmetric.
- [Box plot maker](https://getxmetric.com/make/box-plot-maker/): Make an editable chart from your own local file or pasted CSV. Show medians, quartiles and 1.5 × IQR whiskers across individual numeric observations in each category. Download SVG or continue in xmetric.
- [Scatter plot with line of best fit](https://getxmetric.com/make/scatter-plot-with-line-of-best-fit/): Make an editable chart from your own local file or pasted CSV. Plot two numeric columns and fit a linear trend using the xmetric analytics engine. Download SVG or continue in xmetric.
- [CSV viewer and editor in your browser](https://getxmetric.com/open/csv-viewer/): Open your .csv file in the xmetric browser viewer to inspect rows and columns without uploading it. Choose the local file below, review the table, then continue in xmetric to build a chart.
- [Excel XLSX viewer in your browser](https://getxmetric.com/open/xlsx-viewer/): Open your .xlsx file in the xmetric browser viewer to inspect rows and columns without uploading it. Choose the local file below, review the table, then continue in xmetric to build a chart.
- [Power BI PBIX viewer in your browser](https://getxmetric.com/open/pbix-viewer/): Open your .pbix file with xmetric in your browser to explore supported report pages or workbook sheets. Choose your local file below; rendering and interactions can differ from the original application.
- [Tableau TWB viewer in your browser](https://getxmetric.com/open/twb-viewer/): Open your .twb file with xmetric in your browser to explore supported report pages or workbook sheets. Choose your local file below; rendering and interactions can differ from the original application.
- [JSON viewer in your browser](https://getxmetric.com/open/json-viewer/): Open your .json file in the xmetric browser viewer to inspect rows and columns without uploading it. Choose the local file below, review the table, then continue in xmetric to build a chart.
- [JSONL viewer in your browser](https://getxmetric.com/open/jsonl-viewer/): Open your .jsonl file in the xmetric browser viewer to inspect rows and columns without uploading it. Choose the local file below, review the table, then continue in xmetric to build a chart.
- [JSON to CSV converter](https://getxmetric.com/convert/json-to-csv/): Convert your .json file to CSV with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [JSONL to CSV converter](https://getxmetric.com/convert/jsonl-to-csv/): Convert your .jsonl file to CSV with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [CSV to Excel converter](https://getxmetric.com/convert/csv-to-excel/): Convert your .csv file to XLSX with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [CSV to JSON converter](https://getxmetric.com/convert/csv-to-json/): Convert your .csv file to JSON with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [Excel to CSV converter](https://getxmetric.com/convert/excel-to-csv/): Convert your .xlsx file to CSV with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [XML to CSV converter](https://getxmetric.com/convert/xml-to-csv/): Convert your .xml file to CSV with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [JSON to Excel converter](https://getxmetric.com/convert/json-to-excel/): Convert your .json file to XLSX with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [Excel to JSON converter](https://getxmetric.com/convert/excel-to-json/): Convert your .xlsx file to JSON with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [PARQUET to CSV converter](https://getxmetric.com/convert/parquet-to-csv/): Convert your .parquet file to CSV with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [TSV to CSV converter](https://getxmetric.com/convert/tsv-to-csv/): Convert your .tsv file to CSV with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [CSV to PARQUET converter](https://getxmetric.com/convert/csv-to-parquet/): Convert your .csv file to PARQUET with xmetric in your browser: choose the file, review the imported table, then download the result. Your file is processed locally, without uploading it.
- [Open your data and BI files in your browser](https://getxmetric.com/open/file-viewers/): Choose a viewer for your CSV, Excel, Parquet, JSON, JSONL, Power BI or Tableau file. Process local files with xmetric.
- [Convert a table in your browser](https://getxmetric.com/convert/): Convert flat CSV, TSV, JSON, JSONL, XML, Excel and Parquet tables with xmetric. Preview the imported rows before downloading.
- [Bullet chart maker](https://getxmetric.com/make/bullet-chart-maker/): Make an editable chart from your own local file or pasted CSV. Compare actuals with numeric targets using bars, target lines and 60%, 85% and 100% threshold bands. Download SVG or continue in xmetric.
- [Heat map generator](https://getxmetric.com/make/heat-map-generator/): Make an editable chart from your own local file or pasted CSV. Compare two category dimensions with numeric color, labels and square size. Download SVG or continue in xmetric.
- [Slope chart maker](https://getxmetric.com/make/slope-chart-maker/): Make an editable chart from your own local file or pasted CSV. Connect each category across exactly two periods. Bring a file containing only the two periods you want to compare. Download SVG or continue in xmetric.
- [Gantt chart maker](https://getxmetric.com/make/gantt-chart-maker/): Make an editable chart from your own local file or pasted CSV. Draw task timelines from start and end dates, with durations calculated in days by the xmetric engine. Download SVG or continue in xmetric.
- [Dual axis chart maker](https://getxmetric.com/make/dual-axis-chart-maker/): Make an editable chart from your own local file or pasted CSV. Compare two numeric measures using a bar and a line with independent vertical axes. Download SVG or continue in xmetric.
- [Use xmetric in ChatGPT and Claude](https://getxmetric.com/guides/ai-app/): Connect the no-account file board, inspect authored definitions and request aggregates; local-file privacy and limits.
- [Every way to open a .pbix without Power BI Desktop on your Mac](https://getxmetric.com/open/open-pbix-without-power-bi-desktop/): Open your .pbix in xmetric to view supported report pages and visuals locally in your Mac browser. For Microsoft's hosted report experience, use Power BI Service; for native Desktop authoring, run Power BI Desktop in a compatible Windows environment, including a VM. These routes differ in compatibility, setup and where the data is processed.

## Level of detail

- [Distinct customers per region](https://getxmetric.com/reference/lod-fixed-distinct-customers/): Counts each customer once per region.
- [Exclude all view dimensions](https://getxmetric.com/reference/lod-exclude-all-dimensions/): Removing every view dimension produces a global total.
- [Exclude responds to dimension filter](https://getxmetric.com/reference/lod-exclude-filter/): Dimension filters change the input to EXCLUDE calculations.
- [First invoice date](https://getxmetric.com/reference/lod-fixed-first-date/): Returns the earliest invoice date per customer.
- [Fixed customer lifetime revenue](https://getxmetric.com/reference/lod-fixed-customer-total/): Adds invoices at customer grain.
- [Fixed grand total](https://getxmetric.com/reference/lod-fixed-grand-total/): Repeats the total across regional marks.
- [Fixed region total](https://getxmetric.com/reference/lod-fixed-region-total/): Repeats a region total across its teams.
- [Fixed total with context filter](https://getxmetric.com/reference/lod-fixed-context-filter/): A context filter changes the fixed calculation population.
- [Fixed total with ordinary filter](https://getxmetric.com/reference/lod-fixed-dimension-filter/): An ordinary dimension filter does not change the fixed total.
- [Invoice count per customer](https://getxmetric.com/reference/lod-fixed-count-invoices/): Counts non-null invoice amounts at customer grain.
- [Largest customer revenue](https://getxmetric.com/reference/lod-include-largest-customer/): Aggregates customer totals once within each region.
- [Mean customer revenue](https://getxmetric.com/reference/lod-include-mean-customer/): Aggregates customer totals once within each region.
- [Mean team revenue](https://getxmetric.com/reference/lod-include-mean-team/): Averages team totals within each region.
- [Median customer revenue](https://getxmetric.com/reference/lod-include-customer-median/): Aggregates customer totals once within each region.
- [Nested largest customer per region](https://getxmetric.com/reference/lod-nested-largest-customer/): Finds the largest customer total inside each region.
- [Nested smallest customer per region](https://getxmetric.com/reference/lod-nested-smallest-customer/): Finds the smallest customer total inside each region.
- [Region share of fixed total](https://getxmetric.com/reference/lod-fixed-share/): Divides regional revenue by the fixed global total.
- [Region total excluding team](https://getxmetric.com/reference/lod-exclude-team/): Removes team from the view calculation grain.
- [Smallest customer revenue](https://getxmetric.com/reference/lod-include-smallest-customer/): Aggregates customer totals once within each region.
- [Team share within region](https://getxmetric.com/reference/lod-exclude-share/): Divides team revenue by its region total.

## Table calculations

- [Centered three-period average](https://getxmetric.com/reference/pattern-centered-three-period-average/): Averages the previous, current, and next regional marks with clipped edges.
- [Dense rank within region](https://getxmetric.com/reference/pattern-dense-rank-within-region/): Assigns dense descending revenue ranks separately within each region.
- [Difference from first period](https://getxmetric.com/reference/pattern-difference-from-first-period/): Subtracts the revenue of the first addressed period in each region.
- [Difference from last period](https://getxmetric.com/reference/pattern-difference-from-last-period/): Subtracts the revenue of the last addressed period in each region.
- [Difference from previous period](https://getxmetric.com/reference/pattern-difference-from-previous-period/): Subtracts the previous regional period revenue.
- [FIRST](https://getxmetric.com/reference/first/): Returns the relative offset to the first mark in the partition.
- [INDEX](https://getxmetric.com/reference/index/): Returns the one-based mark position within each regional partition.
- [LAST](https://getxmetric.com/reference/last/): Returns the relative offset to the last mark in the partition.
- [LOOKUP](https://getxmetric.com/reference/lookup/): Returns the previous addressed mark revenue, or null outside the partition.
- [Next period revenue](https://getxmetric.com/reference/pattern-next-period-revenue/): Returns the next addressed regional period revenue.
- [Percent change from previous period](https://getxmetric.com/reference/pattern-percent-change-previous-period/): Measures revenue change relative to the absolute previous period revenue.
- [Percent of regional total](https://getxmetric.com/reference/pattern-percent-of-regional-total/): Divides each period revenue by its regional total.
- [PREVIOUS_VALUE](https://getxmetric.com/reference/previous-value/): Repeats the initial revenue when the calculated field consists only of PREVIOUS_VALUE.
- [RANK](https://getxmetric.com/reference/rank/): Ranks regional mark revenues with the documented tie rule and excludes null measures.
- [RANK_DENSE](https://getxmetric.com/reference/rank-dense/): Ranks regional mark revenues with the documented tie rule and excludes null measures.
- [RANK_MODIFIED](https://getxmetric.com/reference/rank-modified/): Ranks regional mark revenues with the documented tie rule and excludes null measures.
- [RANK_PERCENTILE](https://getxmetric.com/reference/rank-percentile/): Ranks regional mark revenues with the documented tie rule and excludes null measures.
- [RANK_UNIQUE](https://getxmetric.com/reference/rank-unique/): Ranks regional mark revenues with the documented tie rule and excludes null measures.
- [Regional mark position fraction](https://getxmetric.com/reference/pattern-regional-position-fraction/): Divides the one-based addressed position by the regional mark count.
- [Regional min-max normalization](https://getxmetric.com/reference/pattern-regional-min-max-normalization/): Scales revenue between the regional minimum and maximum.
- [Regional revenue z-score](https://getxmetric.com/reference/pattern-regional-z-score/): Standardizes revenue using the regional mean and sample standard deviation.
- [Regional running total](https://getxmetric.com/reference/pattern-running-total-by-region/): Accumulates period revenue independently for each region.
- [Running percent of total](https://getxmetric.com/reference/pattern-running-percent-of-total/): Measures cumulative revenue as a share of the full regional total.
- [Running revenue product](https://getxmetric.com/reference/pattern-running-product/): Multiplies each revenue into the prior calculated product; a null propagates.
- [RUNNING_AVG](https://getxmetric.com/reference/running-avg/): Calculates avg over the current and preceding regional marks, excluding null revenues.
- [RUNNING_COUNT](https://getxmetric.com/reference/running-count/): Calculates count over the current and preceding regional marks, excluding null revenues.
- [RUNNING_MAX](https://getxmetric.com/reference/running-max/): Calculates max over the current and preceding regional marks, excluding null revenues.
- [RUNNING_MIN](https://getxmetric.com/reference/running-min/): Calculates min over the current and preceding regional marks, excluding null revenues.
- [RUNNING_STDEV](https://getxmetric.com/reference/running-stdev/): Calculates stdev over the current and preceding regional marks, excluding null revenues.
- [RUNNING_STDEVP](https://getxmetric.com/reference/running-stdevp/): Calculates stdevp over the current and preceding regional marks, excluding null revenues.
- [RUNNING_SUM](https://getxmetric.com/reference/running-sum/): Calculates sum over the current and preceding regional marks, excluding null revenues.
- [RUNNING_VAR](https://getxmetric.com/reference/running-var/): Calculates var over the current and preceding regional marks, excluding null revenues.
- [RUNNING_VARP](https://getxmetric.com/reference/running-varp/): Calculates varp over the current and preceding regional marks, excluding null revenues.
- [SIZE](https://getxmetric.com/reference/size/): Returns the number of marks in each regional partition, including null measures.
- [TOTAL](https://getxmetric.com/reference/total/): Returns the total revenue across the regional partition.
- [Two-period moving average](https://getxmetric.com/reference/pattern-two-period-moving-average/): Averages non-null revenues from the current and preceding regional mark.
- [WINDOW_AVG](https://getxmetric.com/reference/window-avg/): Calculates avg over all regional marks, excluding null revenues.
- [WINDOW_CORR](https://getxmetric.com/reference/window-corr/): Calculates the regional paired revenue and cost statistic using non-null pairs.
- [WINDOW_COUNT](https://getxmetric.com/reference/window-count/): Calculates count over all regional marks, excluding null revenues.
- [WINDOW_COVAR](https://getxmetric.com/reference/window-covar/): Calculates the regional paired revenue and cost statistic using non-null pairs.
- [WINDOW_COVARP](https://getxmetric.com/reference/window-covarp/): Calculates the regional paired revenue and cost statistic using non-null pairs.
- [WINDOW_MAX](https://getxmetric.com/reference/window-max/): Calculates max over all regional marks, excluding null revenues.
- [WINDOW_MEDIAN](https://getxmetric.com/reference/window-median/): Calculates median over all regional marks, excluding null revenues.
- [WINDOW_MIN](https://getxmetric.com/reference/window-min/): Calculates min over all regional marks, excluding null revenues.
- [WINDOW_PERCENTILE](https://getxmetric.com/reference/window-percentile/): Returns the interpolated 25th percentile of non-null regional mark revenues.
- [WINDOW_STDEV](https://getxmetric.com/reference/window-stdev/): Calculates stdev over all regional marks, excluding null revenues.
- [WINDOW_STDEVP](https://getxmetric.com/reference/window-stdevp/): Calculates stdevp over all regional marks, excluding null revenues.
- [WINDOW_SUM](https://getxmetric.com/reference/window-sum/): Calculates sum over all regional marks, excluding null revenues.
- [WINDOW_VAR](https://getxmetric.com/reference/window-var/): Calculates var over all regional marks, excluding null revenues.
- [WINDOW_VARP](https://getxmetric.com/reference/window-varp/): Calculates varp over all regional marks, excluding null revenues.

## Aggregates

- [ATTR](https://getxmetric.com/reference/attr/): Returns the sole distinct non-null value, or a multiple-value marker.
- [AVG](https://getxmetric.com/reference/avg/): Returns the arithmetic mean of non-null values.
- [CORR](https://getxmetric.com/reference/corr/): Returns the Pearson correlation of complete numeric pairs.
- [COUNT](https://getxmetric.com/reference/count/): Counts non-null values.
- [COUNTD](https://getxmetric.com/reference/countd/): Counts distinct non-null values.
- [COVAR](https://getxmetric.com/reference/covar/): Returns the sample covariance of complete numeric pairs.
- [COVARP](https://getxmetric.com/reference/covarp/): Returns the population covariance of complete numeric pairs.
- [MAX](https://getxmetric.com/reference/max/): Returns the greatest non-null value.
- [MEDIAN](https://getxmetric.com/reference/median/): Returns the median of non-null values.
- [MIN](https://getxmetric.com/reference/min/): Returns the least non-null value.
- [PERCENTILE](https://getxmetric.com/reference/percentile/): Returns a linearly interpolated percentile of non-null values.
- [STDEV](https://getxmetric.com/reference/stdev/): Returns the sample standard deviation of non-null values.
- [STDEVP](https://getxmetric.com/reference/stdevp/): Returns the population standard deviation of non-null values.
- [SUM](https://getxmetric.com/reference/sum/): Returns the sum of non-null values.
- [VAR](https://getxmetric.com/reference/var/): Returns the sample variance of non-null values.
- [VARP](https://getxmetric.com/reference/varp/): Returns the population variance of non-null values.

## Dates

- [DATE](https://getxmetric.com/reference/date/): Converts a value to a date.
- [DATEADD](https://getxmetric.com/reference/dateadd/): Adds an interval to a date.
- [DATEDIFF](https://getxmetric.com/reference/datediff/): Counts date-part boundaries between dates.
- [DATENAME](https://getxmetric.com/reference/datename/): Returns a date-part name as text.
- [DATEPARSE](https://getxmetric.com/reference/dateparse/): Parses a date string using a supplied format.
- [DATEPART](https://getxmetric.com/reference/datepart/): Returns a numeric date part.
- [DATETIME](https://getxmetric.com/reference/datetime/): Converts a value to a datetime.
- [DATETRUNC](https://getxmetric.com/reference/datetrunc/): Truncates a date to a date-part boundary.
- [DAY](https://getxmetric.com/reference/day/): Returns the day of month.
- [ISDATE](https://getxmetric.com/reference/isdate/): Tests whether a string can be interpreted as a date.
- [ISOQUARTER](https://getxmetric.com/reference/isoquarter/): Returns the quarter within the ISO week year.
- [ISOWEEK](https://getxmetric.com/reference/isoweek/): Returns the ISO week number.
- [ISOWEEKDAY](https://getxmetric.com/reference/isoweekday/): Returns Monday-based ISO weekday numbers.
- [ISOYEAR](https://getxmetric.com/reference/isoyear/): Returns the ISO week year.
- [MAKEDATE](https://getxmetric.com/reference/makedate/): Constructs a date from year, month, and day.
- [MAKEDATETIME](https://getxmetric.com/reference/makedatetime/): Combines a date with the time component of a datetime.
- [MONTH](https://getxmetric.com/reference/month/): Returns the month number.
- [NOW](https://getxmetric.com/reference/now/): Returns the configured current datetime.
- [QUARTER](https://getxmetric.com/reference/quarter/): Returns the calendar quarter number.
- [TODAY](https://getxmetric.com/reference/today/): Returns the configured current date.
- [WEEK](https://getxmetric.com/reference/week/): Returns the week number under the configured week start.
- [YEAR](https://getxmetric.com/reference/year/): Returns the calendar year.

## Logic

- [CASE](https://getxmetric.com/reference/operator-case/): CASE compares values and returns the matching branch.
- [ELSEIF](https://getxmetric.com/reference/operator-elseif/): ELSEIF tests an additional condition after earlier conditions fail.
- [IF](https://getxmetric.com/reference/operator-if/): IF selects ELSE for an unknown condition.
- [IFNULL](https://getxmetric.com/reference/ifnull/): Replaces a null value with a fallback.
- [IIF](https://getxmetric.com/reference/iif/): Returns separate branches for true, false, and unknown conditions.
- [IN](https://getxmetric.com/reference/in/): Tests membership in a list; a null left operand returns false in this profile.
- [ISNULL](https://getxmetric.com/reference/isnull/): Tests whether a value is null.

## Numbers

- [ABS](https://getxmetric.com/reference/abs/): Returns the absolute value of a number.
- [ACOS](https://getxmetric.com/reference/acos/): Returns the inverse cosine in radians.
- [ASIN](https://getxmetric.com/reference/asin/): Returns the inverse sine in radians.
- [ATAN](https://getxmetric.com/reference/atan/): Returns the inverse tangent in radians.
- [ATAN2](https://getxmetric.com/reference/atan2/): Returns the angle in radians from two coordinates.
- [CEILING](https://getxmetric.com/reference/ceiling/): Rounds upward to the nearest integer.
- [COS](https://getxmetric.com/reference/cos/): Returns the cosine of an angle in radians.
- [COT](https://getxmetric.com/reference/cot/): Returns the cotangent of an angle in radians.
- [DEGREES](https://getxmetric.com/reference/degrees/): Converts radians to degrees.
- [DIV](https://getxmetric.com/reference/div/): Returns the integer quotient, truncated toward zero.
- [EXP](https://getxmetric.com/reference/exp/): Returns e raised to the specified power.
- [FLOOR](https://getxmetric.com/reference/floor/): Rounds downward to the nearest integer.
- [GREATEST](https://getxmetric.com/reference/greatest/): Returns the greatest non-null argument.
- [GREATESTPROPAGATENULL](https://getxmetric.com/reference/greatestpropagatenull/): Returns the greatest argument, or null if any argument is null.
- [HEXBINX](https://getxmetric.com/reference/hexbinx/): Returns the horizontal coordinate of the nearest hexagonal bin center.
- [HEXBINY](https://getxmetric.com/reference/hexbiny/): Returns the vertical coordinate of the nearest hexagonal bin center.
- [LEAST](https://getxmetric.com/reference/least/): Returns the least non-null argument.
- [LEASTPROPAGATENULL](https://getxmetric.com/reference/leastpropagatenull/): Returns the least argument, or null if any argument is null.
- [LN](https://getxmetric.com/reference/ln/): Returns the natural logarithm for a positive number.
- [LOG](https://getxmetric.com/reference/log/): Returns a logarithm in the specified base.
- [PI](https://getxmetric.com/reference/pi/): Returns the ratio of a circle circumference to its diameter.
- [POWER](https://getxmetric.com/reference/power/): Raises a number to a power.
- [RADIANS](https://getxmetric.com/reference/radians/): Converts degrees to radians.
- [ROUND](https://getxmetric.com/reference/round/): Rounds a number to the specified decimal precision.
- [SIGN](https://getxmetric.com/reference/sign/): Returns minus one, zero, or one for the sign of a number.
- [SIN](https://getxmetric.com/reference/sin/): Returns the sine of an angle in radians.
- [SQRT](https://getxmetric.com/reference/sqrt/): Returns the nonnegative square root.
- [SQUARE](https://getxmetric.com/reference/square/): Returns a number multiplied by itself.
- [TAN](https://getxmetric.com/reference/tan/): Returns the tangent of an angle in radians.
- [ZN](https://getxmetric.com/reference/zn/): Replaces a null numeric value with zero.

## Strings

- [ASCII](https://getxmetric.com/reference/ascii/): Returns the code point of the first character.
- [CHAR](https://getxmetric.com/reference/char/): Returns the character for a Unicode code point.
- [CONTAINS](https://getxmetric.com/reference/contains/): Tests whether a string contains a substring.
- [ENDSWITH](https://getxmetric.com/reference/endswith/): Tests a suffix after trailing spaces are removed in this example.
- [FIND](https://getxmetric.com/reference/find/): Returns a one-based substring position, or zero when absent.
- [FINDNTH](https://getxmetric.com/reference/findnth/): Returns the position of a requested substring occurrence.
- [LEFT](https://getxmetric.com/reference/left/): Returns the first requested characters.
- [LEN](https://getxmetric.com/reference/len/): Counts characters including spaces.
- [LOWER](https://getxmetric.com/reference/lower/): Converts text to lower case.
- [LTRIM](https://getxmetric.com/reference/ltrim/): Removes spaces at the specified string edges.
- [MID](https://getxmetric.com/reference/mid/): Returns a substring starting at a one-based position.
- [PROPER](https://getxmetric.com/reference/proper/): Capitalizes the first character of each word.
- [REGEXP_EXTRACT](https://getxmetric.com/reference/regexp-extract/): Returns the first captured substring, or null when there is no match.
- [REGEXP_EXTRACT_NTH](https://getxmetric.com/reference/regexp-extract-nth/): Returns the requested regular-expression capture group.
- [REGEXP_MATCH](https://getxmetric.com/reference/regexp-match/): Tests whether a regular expression matches anywhere in a string.
- [REGEXP_REPLACE](https://getxmetric.com/reference/regexp-replace/): Replaces all matches of a regular expression.
- [REPLACE](https://getxmetric.com/reference/replace/): Replaces every literal occurrence of a substring.
- [RIGHT](https://getxmetric.com/reference/right/): Returns the last requested characters.
- [RTRIM](https://getxmetric.com/reference/rtrim/): Removes spaces at the specified string edges.
- [SPACE](https://getxmetric.com/reference/space/): Returns the requested number of spaces.
- [SPLIT](https://getxmetric.com/reference/split/): Returns a numbered delimiter-separated token; negative numbers count from the end.
- [STARTSWITH](https://getxmetric.com/reference/startswith/): Tests a prefix after leading spaces are removed in this example.
- [TRIM](https://getxmetric.com/reference/trim/): Removes spaces at the specified string edges.
- [UPPER](https://getxmetric.com/reference/upper/): Converts text to upper case.

## Type conversion

- [FLOAT](https://getxmetric.com/reference/float/): Converts a value to a floating-point number.
- [INT](https://getxmetric.com/reference/int/): Converts a number to an integer by truncating its fractional part.
- [STR](https://getxmetric.com/reference/str/): Converts a value to text.

## User functions

- [FULLNAME](https://getxmetric.com/reference/fullname/): Returns the configured full user name.
- [ISFULLNAME](https://getxmetric.com/reference/isfullname/): Tests the configured full user name against a literal.
- [ISMEMBEROF](https://getxmetric.com/reference/ismemberof/): Tests group membership for the configured user.
- [ISUSERNAME](https://getxmetric.com/reference/isusername/): Tests the configured user name against a literal.
- [USERDOMAIN](https://getxmetric.com/reference/userdomain/): Returns the domain component of the configured user name.
- [USERNAME](https://getxmetric.com/reference/username/): Returns the configured user name.

## Pass-through SQL

- [RAWSQL_BOOL](https://getxmetric.com/reference/rawsql-bool/): Evaluates a permitted scalar SQL expression with positional substitutions.
- [RAWSQL_DATE](https://getxmetric.com/reference/rawsql-date/): Evaluates a permitted scalar SQL expression with positional substitutions.
- [RAWSQL_DATETIME](https://getxmetric.com/reference/rawsql-datetime/): Evaluates a permitted scalar SQL expression with positional substitutions.
- [RAWSQL_INT](https://getxmetric.com/reference/rawsql-int/): Evaluates a permitted scalar SQL expression with positional substitutions.
- [RAWSQL_REAL](https://getxmetric.com/reference/rawsql-real/): Evaluates a permitted scalar SQL expression with positional substitutions.
- [RAWSQL_STR](https://getxmetric.com/reference/rawsql-str/): Evaluates a permitted scalar SQL expression with positional substitutions.
- [RAWSQLAGG_BOOL](https://getxmetric.com/reference/rawsqlagg-bool/): Evaluates a permitted aggregate SQL expression with positional substitutions.
- [RAWSQLAGG_DATE](https://getxmetric.com/reference/rawsqlagg-date/): Evaluates a permitted aggregate SQL expression with positional substitutions.
- [RAWSQLAGG_DATETIME](https://getxmetric.com/reference/rawsqlagg-datetime/): Evaluates a permitted aggregate SQL expression with positional substitutions.
- [RAWSQLAGG_INT](https://getxmetric.com/reference/rawsqlagg-int/): Evaluates a permitted aggregate SQL expression with positional substitutions.
- [RAWSQLAGG_REAL](https://getxmetric.com/reference/rawsqlagg-real/): Evaluates a permitted aggregate SQL expression with positional substitutions.
- [RAWSQLAGG_STR](https://getxmetric.com/reference/rawsqlagg-str/): Evaluates a permitted aggregate SQL expression with positional substitutions.

## Spatial

- [MAKELINE](https://getxmetric.com/reference/makeline/): Creates a line connecting two points.
- [MAKEPOINT](https://getxmetric.com/reference/makepoint/): Creates a WGS84 point from latitude and longitude.
- [PARSE_WKT](https://getxmetric.com/reference/parse-wkt-linestring/): Parses ordered WKT LineString coordinate pairs into a spatial line.
- [PARSE_WKT](https://getxmetric.com/reference/parse-wkt/): Parses WKT text into geometry.

## Operators

- [!=](https://getxmetric.com/reference/operator-not-equal/): A comparison with an unknown operand remains unknown.
- [%](https://getxmetric.com/reference/operator-modulo/): Integer remainder keeps the dividend sign.
- [( )](https://getxmetric.com/reference/operator-parentheses/): Parentheses control evaluation order.
- [*](https://getxmetric.com/reference/operator-multiply/): Numeric multiplication preserves unknown operands.
- [+](https://getxmetric.com/reference/operator-add/): Numeric addition preserves unknown operands.
- [+ (date)](https://getxmetric.com/reference/operator-date-add/): Adding an integer to a date advances calendar days.
- [+ (string)](https://getxmetric.com/reference/operator-concatenate/): String addition concatenates; null is not an empty string.
- [-](https://getxmetric.com/reference/operator-subtract/): Numeric subtraction preserves unknown operands.
- [- (date, date)](https://getxmetric.com/reference/operator-date-difference/): Subtracting dates gives their difference in days.
- [- (date, days)](https://getxmetric.com/reference/operator-date-subtract-days/): Subtracting an integer from a date moves back by calendar days.
- [/](https://getxmetric.com/reference/operator-divide/): Division retains the fractional quotient.
- [<](https://getxmetric.com/reference/operator-less/): A comparison with an unknown operand remains unknown.
- [<=](https://getxmetric.com/reference/operator-less-equal/): A comparison with an unknown operand remains unknown.
- [<>](https://getxmetric.com/reference/operator-not-equal-angle/): A comparison with an unknown operand remains unknown.
- [=](https://getxmetric.com/reference/operator-equal/): A comparison with an unknown operand remains unknown.
- [==](https://getxmetric.com/reference/operator-equal-double/): A comparison with an unknown operand remains unknown.
- [>](https://getxmetric.com/reference/operator-greater/): A comparison with an unknown operand remains unknown.
- [>=](https://getxmetric.com/reference/operator-greater-equal/): A comparison with an unknown operand remains unknown.
- [^](https://getxmetric.com/reference/operator-power/): Power raises the base rather than multiplying it by the exponent.
- [AND](https://getxmetric.com/reference/operator-and/): Conjunction includes true, false, and unknown operands.
- [NOT](https://getxmetric.com/reference/operator-not/): Negating an unknown value remains unknown.
- [OR](https://getxmetric.com/reference/operator-or/): Disjunction includes true, false, and unknown operands.
- [precedence](https://getxmetric.com/reference/operator-precedence/): Multiplication precedes addition.
- [unary -](https://getxmetric.com/reference/operator-negate/): Unary minus changes the sign and keeps null.