-
about 7 min
This Quarter vs Last Quarter: a Grid That Diffs the Two
Run a period over period comparison in JavaScript: compare this quarter's orders grid against last quarter's, ranked by effect size, with both sides still filterable.
-
about 7 min
Trend Figures for Any Series, as Grid Rows
Time series statistics in JavaScript: turn any series, like daily revenue, into trend rows, change, volatility, drawdown, with a derived grid that follows your filter.
-
about 6 min
Correlation Matrix: Which Measures Move Together
Build a correlation matrix in JavaScript straight from your orders grid: one row per measure pair, Pearson's r, live as the orders grid is filtered.
-
about 8 min
Median, p95 and Spread Per Rep, Not Just the Totals
Median and percentile JavaScript grid: median, p95 and spread per rep, built from your orders grid, so the spread stays live the moment you filter.
-
about 7 min
Data Quality Profile: One Row Per Column, One Line
Data profiling in JavaScript: profile any grid in one line, with count, missing, distinct, min, max, mean, median, quartiles and outliers, following every filter.
-
about 7 min
Totals That Follow However You Group: a Derived Grid
A dynamic group by grid: group orders by rep, region or month, and a derived totals grid follows, with groupBy as the fallback before anyone groups it.
-
about 6 min
Totals for Selected Rows: a Derived Grid, Not a Filter
Build a live totals panel for just the rows a user ticks, with a derived grid whose follow is selected, so the total re-sums every time the selection changes.
-
about 7 min
Revenue by Customer Segment: Join a Grid, Then Group It
Join two tables in a JavaScript grid: bring segment across from a customers grid, group orders by it, and keep the segment totals moving with both tables' filters.
-
about 7 min
Units and Revenue by SKU: Unnest Order Lines
Flatten a nested array into a JavaScript table: unnest each order's line items and total units and revenue by SKU, in a derived grid that follows the orders grid's filters.
-
about 7 min
Loss-Making Orders: an Exceptions Grid, Not an Export
A conditional row filter in a JavaScript grid: a live list of loss-making orders, built from your orders grid with where, updated the moment cost passes amount.
-
about 8 min
Overdue Orders: a Derived Grid That Maintains Itself
Build an overdue orders exception report as a derived data grid from your orders grid, filtered with where, so it never goes stale when someone filters the table.
-
about 7 min
Top Customers by Revenue: the 80% Cutoff
Pareto analysis in JavaScript: a top-customers grid from your orders grid, kept until the running revenue share crosses 80%, and re-applied whenever the orders are filtered.
-
about 7 min
Top 3 Products Per Region: a Derived Grid with limitPer
Top N per group in JavaScript: the best three products per region from your orders grid, with groupBy and limitPer, so one filter moves both and the ranking never drifts.
-
about 6 min
Sales Leaderboard: Top Five Reps From a Derived Grid
Show the top N rows in a JavaScript grid: a top five sales leaderboard built from your orders grid by rep and revenue, so one filter moves both.
-
about 7 min
Monthly Revenue Trend Grid That Feeds a Line Chart
Group by month in JavaScript with a derived grid: bucket orders, sum revenue and feed a chart from grid data that stays in step once someone filters the table.
-
about 11 min
Chart a Derived Grid: Source and Derived Data, One Chart
Bind a chart to a derived grid and it follows the parent live. Union the source grid with the derived one and a single chart overlays both, on one chart or two axes.
-
about 6 min
Region by Category Revenue Matrix From One Order Grid
A pivot table in JavaScript, built from one order grid: a region by category revenue matrix that groups and sums live, so it never disagrees with the filtered table.
-
about 6 min
Revenue by Region: a Derived Grid, Not a Second Query
Group by region in a JavaScript data grid: a revenue summary table built from your orders grid, so one filter moves both and the numbers never disagree.