KPIs belong to the model
Forecast and average are named formulas independent of any presentation surface.
Canonical Grid model
Summarize a forecast in dashboard tiles.
What this model gives you
10 min to study · Source reviewed 2026-08-25
Continue with guided practiceExpected checkpoint
After loading five authored monthly values and the 186,000 pipeline.
Forecast and average are named formulas independent of any presentation surface.
Metric tiles bind to the named KPIs and the note explains their scope.
A monthly edit recalculates the formulas first; Layout renders the new values.
MODEL "Revenue Dashboard"
DESCRIPTION "Summarize a forecast in dashboard tiles."
VERSION "1.0.0"
AUTHOR "AI Agent"
TAGS "surface-template", "dashboard", "layout", "surfaces"
MonthlyRevenue = [120000, 135000, 142000, 150000, 168000]
Pipeline = 186000
Forecast IS currency = SUM(MonthlyRevenue#) + Pipeline
AverageMonth IS currency = AVERAGE(MonthlyRevenue#)
Dashboard!type = "layout"
Dashboard!config = """
version = 1
kind = "layout"
title = "Dashboard"
[layout]
cols = 12
rows = 6
show_controls = true
[[tiles.static]]
title = "Forecast"
x = 0
y = 0
w = 4
h = 2
formula = "=Forecast"
[[tiles.static]]
title = "Average Month"
x = 4
y = 0
w = 4
h = 2
formula = "=AverageMonth"
[[tiles.static]]
title = "Notes"
x = 0
y = 2
w = 12
h = 4
body = "Forecast includes five months of actuals plus open pipeline."
"""
Dashboard!data = ""
END MODEL