Lattice Grid

blog

How-to Articles

how-to. 48 posts.

  • about 4 min

    Funnel Chart for a Sales Pipeline

    Bind a funnel chart to a grid of pipeline counts: leads, qualified, proposal, won. Filter the rows by region to redraw the drop at each stage.

  • about 5 min

    Gauge Chart of Warehouse Utilisation

    Bind a gauge chart to a grid of warehouse zones and read utilisation against its bands. Filter the rows and the needle moves.

  • about 4 min

    Radar Chart for Supplier Scorecards

    Bind a radar chart to a grid of supplier scores: one spoke per criterion, one shape per supplier. Filter the rows to redraw it.

  • about 5 min

    Force Tree Chart of Service Dependencies

    Bind a force tree chart to a grid of services and what each depends on, the hub at the centre. Filter the rows and the map redraws.

  • about 5 min

    Tree Chart of an Approval Hierarchy

    Bind a tree chart to a grid of approvers: each node is a person, each line is who they pass up to. Filter the rows to redraw it.

  • about 5 min

    Packed Circle Chart of Teams by Headcount

    Bind a packed circle chart to a grid of teams: each circle is sized by headcount and packed inside its department. Filter the rows to redraw it.

  • about 5 min

    Voronoi Treemap of Market Share by Brand

    Bind a Voronoi treemap to a grid of brand shares: organic cells sized by share, one region per category. Filter the rows to redraw the chart.

  • about 5 min

    Icicle Chart of Request Time by Span

    Bind an icicle chart to a grid of trace spans: width is time spent, depth is nesting, so the slow span stands out. Filter the rows to redraw it.

  • about 5 min

    Waffle Chart for Survey Answers

    Bind a waffle chart to a grid of survey answers: a hundred squares per question, each one percent of respondents, redrawn when you filter the rows.

  • about 4 min

    Treemap of Disk Usage by Folder

    Bind a treemap to a grid of folders: tile size is bytes, branches are age bands, so stale space stands out. Filter the rows to redraw the chart.

  • about 5 min

    Sunburst Chart of Spend by Department

    Bind a sunburst chart to a grid of spend by department, cost centre and vendor: three rings in one chart, and filtering the rows redraws them.

  • about 5 min

    Donut Chart of Budget Used Against Remaining

    Bind a donut chart to a grid of budget lines: show spend by category with the remaining budget in the centre, and filter the rows to redraw both.

  • about 4 min

    Pie Chart of Revenue Share by Channel

    Bind a pie chart to a grid of revenue by channel: show each channel as a share of the quarter, and filter the rows to redraw the slices.

  • about 5 min

    Heatmap of Sign-ups by Hour and Weekday

    Bind a heatmap to a grid of sign-ups: shade every weekday and hour by volume to time a campaign send, and filter the rows to redraw it.

  • about 4 min

    Violin Chart of Salary Bands by Level

    Bind a violin chart to a grid of salaries: see the shape of pay at each level, including two bands inside one, and filter the rows to redraw it.

  • about 5 min

    Ridgeline Chart of Hourly Demand by Weekday

    Bind a ridgeline chart to a grid of store orders: stack each weekday by hour to see how Saturday differs from Tuesday, and filter to redraw it.

  • about 4 min

    Box Plot for Delivery Times by Carrier

    A JavaScript box plot bound to a data grid, comparing delivery days per carrier with the outliers that drive complaints. Live, with code.

  • about 5 min

    Histogram of API Response Times

    Bind a histogram to a grid of API response times, one row per request: see the long tail an average hides, and filter by endpoint to redraw it.

  • about 4 min

    Pareto Chart for Defect Causes

    A JavaScript Pareto chart bound to a data grid, ranking defect causes by count with a cumulative share line. Live, with code.

  • about 5 min

    Combo Chart: Orders and Average Order Value

    Bind a combo chart to a grid of monthly orders and average order value: bars on one axis, a line on the second. Filter the rows and it redraws.

  • about 5 min

    Population Pyramid for Customer Age by Plan

    A JavaScript population pyramid bound to a data grid, with customers per age band split men and women back to back, per plan. Live, with code.

  • about 5 min

    Bullet Chart for KPI Targets by Region

    Bind a bullet chart to a grid of regions with revenue, target and poor, fair, good bands. Filter the rows and it redraws. JavaScript and React code.

  • about 5 min

    Floating Bar Chart for Shift Coverage

    A JavaScript floating bar chart bound to a data grid, with each shift drawn from start hour to end hour per team, so gaps show. Live, with code.

  • about 5 min

    Bubble Chart for Campaign Reach and Cost

    Bind a bubble chart to a grid of campaigns by reach, cost and leads. Filter the rows and the bubbles redraw. Paste-ready JavaScript and React.

  • about 4 min

    Scatter Chart for Price Against Conversion

    A JavaScript scatter chart bound to a data grid, with list price against conversion rate per SKU and a filter that redraws the points. Live, with code.

  • about 4 min

    Waterfall Chart for a Gross to Net Bridge

    Bind a waterfall chart to a grid of gross-to-net steps by region. Filter the rows and the bridge redraws. Paste-ready JavaScript and React.

  • about 4 min

    Bar Chart for Tickets by Support Queue

    A JavaScript bar chart bound to a data grid, with open tickets per support queue split by priority and a filter that redraws the bars. Live, with code.

  • about 4 min

    Area Chart for Stacked Cloud Spend

    Bind a stacked area chart to a grid of weekly cloud spend per service. Filter the rows and it redraws. Paste-ready JavaScript and React listings.

  • about 4 min

    Line Chart for a Monthly Revenue Trend

    A JavaScript line chart bound to a data grid, with twelve months of revenue per product line and a filter that redraws the lines. Live, with code.

  • 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 2 min

    Barcode Cells in a Data Grid: Code 128, EAN-13 and Data Matrix From the Cell Value

    Barcode cells in a data grid: set a column to the barcode renderer and Code 128, EAN-13 or Data Matrix is drawn as inline SVG from the cell value.

  • 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.