Chart Job runs

const ids = Array.isArray(api.input()?.templateIds)
  ? api.input().templateIds
  : [];
if (!ids.length) {
  return [
    [
      {
        type: 'TEXT',
        value: 'Select Job template IDs in widget Inputs.',
      },
    ],
  ];
}

const page = await api.getInstanceData('Jobs', {
  take: 100,
  sort: ['-scheduledFor'],
  fields: ['jobTemplateId', 'status', 'scheduledFor'],
  filter: { jobTemplateId: { in: ids } },
});
const jobs = Array.isArray(page?.data) ? page.data : [];
const dailyCounts = new Map();
for (const job of jobs) {
  const day = String(job.scheduledFor ?? '').slice(0, 10); // UTC date from ISO timestamp.
  if (!/^\d{4}-\d{2}-\d{2}$/.test(day)) continue;
  const entry = dailyCounts.get(day) ?? { day, runs: 0, failed: 0 };
  entry.runs += 1;
  if (job.status === 'ERROR') entry.failed += 1;
  dailyCounts.set(day, entry);
}
const daily = [...dailyCounts.values()].sort((a, b) =>
  a.day.localeCompare(b.day),
);
const scope =
  jobs.length === 100
    ? 'Latest 100 runs; totals may be partial'
    : 'All returned runs';
return [
  [
    {
      type: 'TEXT',
      value: `## Job runs by UTC day\n${scope}`,
      width: 100,
    },
  ],
  [
    {
      type: 'CHART',
      width: 55,
      data: daily,
      options: {
        series: [
          { type: 'bar', xKey: 'day', yKey: 'runs', yName: 'Runs' },
          { type: 'bar', xKey: 'day', yKey: 'failed', yName: 'Errors' },
        ],
      },
    },
    {
      type: 'TABLE',
      width: 40,
      data: daily,
      definition: [
        { field: 'day', headerName: 'UTC day', type: 'DATE' },
        { field: 'runs', headerName: 'Runs', type: 'NUMBER' },
        { field: 'failed', headerName: 'Errors', type: 'NUMBER' },
      ],
    },
    { type: 'EMPTY', width: 5 },
  ],
];