Rules that describe the data

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@toclocoinc/lattice-grid@1.28.0/lattice-grid.min.css">

<div id="grid"></div>

<script type="module">
  import React from 'https://esm.sh/react@18';
  import { createRoot } from 'https://esm.sh/react-dom@18/client';
  import { createGrid } from 'https://cdn.jsdelivr.net/npm/@toclocoinc/lattice-grid@1.28.0/lattice-grid.esm.min.js';
  import createLatticeGrid from 'https://cdn.jsdelivr.net/npm/@toclocoinc/lattice-grid@1.28.0/modules/react.esm.min.js';

  const LatticeGrid = createLatticeGrid({ React, createGrid });

  // Two columns of the same field: a threshold you type, and a rule that finds
  // the outliers in the data itself.
  const formatting = {
    charge: [{ when: { op: 'gt', value: 3000 }, style: { background: '#fff4e5' } }],
    'charge-outlier': [{ when: { op: 'outlier' }, style: { background: '#fbeceb' } }],
  };

  const columns = [
    { field: 'circuit', title: 'Circuit', layout: { pin: 'start', width: 180 } },
    { field: 'region', title: 'Region', filter: { type: 'set' } },
    { field: 'charge', title: 'Charge · gt 3000', type: 'number' },
    { field: 'charge', id: 'charge-outlier', title: 'Charge · outlier', type: 'number' },
  ];

  const rows = [/* circuit records */];

  function App() {
    return (
      <LatticeGrid
        rowKey="id"
        columnDefaults={{ filter: true }}
        formatting={formatting}
        columns={columns}
        rows={rows}
        style={{ height: '500px' }}
      />
    );
  }

  createRoot(document.getElementById('grid')).render(<App />);
</script>