KPI Scorecard
v0.1.0queriesWorkflow #9 — the L10 cross-system scorecard: 7 KPIs (cash, AR, AP, pipeline, open SO/PO, NWC) with target/status. Optional bounded publish to Smartsheet.
1{
2 "$schema": "http://json-schema.org/draft-07/schema#",
3 "title": "KpiScorecard",
4 "type": "object",
5 "properties": {
6 "publish": {
7 "type": "boolean",
8 "description": "Append a snapshot row to Smartsheet (write; WRITE_MODE-gated)"
9 },
10 "sheetId": {
11 "type": "integer",
12 "exclusiveMinimum": 0,
13 "description": "Target sheet (required when publish=true)"
14 },
15 "asOf": {
16 "type": "string",
17 "description": "ISO date; defaults to today"
18 }
19 }
20}Details
- Format
- JSON Schema
- Resource
- queries
- Filename
- schema.json