Lattice Grid Buy a licence

demo D176

Axes and legends: JavaScript Data Grid Demo

A series per category, named by the legend

series, legend

This draws a series per category, each named by the legend, with labelled axes. It shows how the grid turns a categorical column into separate series a reader can tell apart and read off the axes.

Building…
Loading a live grid…

The configuration

<link rel="stylesheet" href="https://cdn.latticegrid.dev/lattice-grid@1.103.2/lattice-grid.min.css">
<script src="https://cdn.latticegrid.dev/lattice-grid@1.103.2/lattice-grid.min.js"></script>

<div id="grid" style="height: 340px"></div>
<div id="chart" style="height: 320px"></div>

<script type="module">
  import { createChart } from '@toclocoinc/lattice-grid/modules/charts';

  const grid = LatticeGrid.createGrid(document.getElementById('grid'), {
    rowKey: 'id',
    columns: [
      { field: 'region', title: 'Region', filter: { type: 'set' } },
      { field: 'status', title: 'Status', filter: { type: 'set' } },
      { field: 'bandwidth', title: 'Bandwidth', type: 'number' },
      { field: 'utilisation', title: 'Utilisation', type: 'number', format: { decimals: 1, suffix: '%' } },
      { field: 'charge', title: 'Monthly charge', type: 'number',
        format: { style: 'currency', currency: 'GBP' }, total: 'sum' },
    ],
    rows,  // circuits: region, status, bandwidth, utilisation, charge
  });

  // A chart reads the grid's filtered rows and redraws when the grid changes.
  // series splits the measure into one series per distinct value; legend names
  // them and the axes scale them.
  createChart({
    grid,
    container: document.getElementById('chart'),
    type: 'bar',
    x: 'region',
    series: 'status',
    y: 'charge',
    legend: true,
    title: 'Charge by region and status',
  });
</script>