Joining a second grid

import * as ng from '@angular/core';
import { Component, ViewChild, AfterViewInit } from '@angular/core';
import { CommonModule } from '@angular/common';
import { bootstrapApplication } from '@angular/platform-browser';
import { createGrid } from '@toclocoinc/lattice-grid';
import '@toclocoinc/lattice-grid/css';
import createLatticeGrid from '@toclocoinc/lattice-grid/modules/angular';

const { LatticeGridComponent } = createLatticeGrid({ ng, createGrid });

const USD = { style: 'currency', currency: 'USD', maximumFractionDigits: 0 };

// The two sides: orders carry a customerId, and the tier lives on the customer.
const customerColumns = [
  { field: 'id', title: 'ID' },
  { field: 'name', title: 'Customer' },
  { field: 'tier', title: 'Tier' },
];
const orderColumns = [
  { field: 'customerId', title: 'Customer' },
  { field: 'region', title: 'Region', filter: { type: 'set' } },
  { field: 'amount', title: 'Value', type: 'number', format: USD, total: 'sum' },
];
const byTierColumns = [
  { field: 'tier', title: 'Tier' },
  { field: 'revenue', title: 'Revenue', type: 'number', format: USD },
  { field: 'orders', title: 'Orders', type: 'number' },
];

@Component({
  selector: 'app-root',
  standalone: true,
  imports: [CommonModule, LatticeGridComponent],
  template:
    '<div style="display:flex;gap:16px">' +
    '  <lattice-grid #orders [config]="ordersGrid" style="flex:2;height:300px"></lattice-grid>' +
    '  <lattice-grid #customers [config]="customersGrid" style="flex:1;height:300px"></lattice-grid>' +
    '</div>' +
    '<lattice-grid *ngIf="byTier" [config]="byTier" style="display:block;margin-top:16px"></lattice-grid>',
})
export class AppComponent implements AfterViewInit {
  @ViewChild('orders') ordersRef!: LatticeGridComponent;
  @ViewChild('customers') customersRef!: LatticeGridComponent;
  byTier: any = null;

  ordersGrid = { rowKey: 'id', toolPanel: { side: 'left', panels: ['filters', 'columns'] }, columns: orderColumns, rows: [/* orders */] };
  customersGrid = { rowKey: 'id', columns: customerColumns, rows: [/* customers */] };

  // The join brings tier across from the customers grid onto each order, matching
  // customerId to id, then the group runs on that brought-across field. Both sides
  // are live instances, so the roll-up follows the filters on the orders grid.
  ngAfterViewInit() {
    const orders = this.ordersRef.grid;
    const customers = this.customersRef.grid;
    this.byTier = {
      autoHeight: true,
      columns: byTierColumns,
      source: {
        mode: 'derived', from: orders, follow: 'filtered', refresh: 'live',
        join: { with: customers, on: { left: 'customerId', right: 'id' }, select: ['tier'] },
        groupBy: 'tier',
        select: { revenue: { of: 'amount', fn: 'sum' }, orders: { fn: 'count' } },
        sort: [{ col: 'revenue', dir: 'desc' }],
      },
    };
  }
}

bootstrapApplication(AppComponent);