Thu 10:42 · board meeting · example data
The follow-up, replayed
Three questions in the meeting. Each answer names what the AI did and uses the margin metric your team approved.
The metric it used
gross_margin
(SUM(revenue) - SUM(cogs)) / NULLIF(SUM(revenue), 0)
Tested on 500 sample rows, approved by the data team
- 01
Gross margin by quarter, this year
listMetricscreateWidgetBuilt a line chart from the approved gross margin metric. Q3 is 59%, down from 64% in Q2.
- 02
Split by product line
addFieldToWidgetaddHighlightHardware fell to 41% in September while Software held at 78%. I marked September on the chart.
- 03
Add Q3 revenue against budget
createWidgetAdded a KPI. Q3 revenue is €1.8M, 4% over budget.