[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6},"actionData","errors","wiki/route",{"_7":8,"_9":10,"_11":12,"_13":14},"tree",{"_24":35,"_25":36,"_27":37,"_38":39,"_40":41,"_32":42},"page",{"_24":9,"_25":26,"_27":17,"_28":29,"_30":31,"_32":-7,"_33":34},"crumbs",[15,16,17],"content","

Every named metric in app/src/metrics/metrics.ts\nand every term of the dictionary, app/src/metrics/dictionary.ts, written\nout from those files. This page follows them: ask Claude to change a metric,\nnever this page.

No metrics yet.

\n",{"_18":22,"_20":23},{"_18":19,"_20":21},"Metrics","label","Reference","to","/wiki/reference","Wiki","/wiki","kind","slug","reference/metrics","title","description","Every named metric and dictionary term, written out from app/src/metrics/.","order",4,"icon","file","/wiki/reference/metrics.md","folder","","Silvi","children",[45,46,47,48,49,50,51,52],"index",{"_24":9,"_25":36,"_27":37,"_28":43,"_30":-7,"_32":42,"_33":44},"book-open","A reporting starter kit. Connect your database and build reports by asking Claude.","/wiki/index.md",{"_24":35,"_25":364,"_27":365,"_38":366,"_40":367,"_30":65,"_32":368},{"_24":35,"_25":352,"_27":353,"_38":354,"_40":355,"_30":91,"_32":356},{"_24":35,"_25":330,"_27":331,"_38":332,"_40":333,"_30":86,"_32":334},{"_24":35,"_25":151,"_27":152,"_38":153,"_40":154,"_30":31,"_32":155},{"_24":35,"_25":118,"_27":119,"_38":120,"_40":121,"_30":122,"_32":123},{"_24":35,"_25":96,"_27":19,"_38":97,"_40":98,"_30":99,"_32":100},{"_24":35,"_25":67,"_27":68,"_38":69,"_40":70,"_30":71,"_32":72},{"_24":35,"_25":53,"_27":54,"_38":55,"_40":56,"_30":57,"_32":58},"about","About",[61],{"_24":9,"_25":53,"_27":54,"_28":59,"_30":57,"_32":58,"_33":60},8,"info","How this wiki is written and kept.","/wiki/about/index.md",{"_24":9,"_25":62,"_27":63,"_28":64,"_30":65,"_32":-7,"_33":66},"about/ai-instructions","Writing pages","The rules every wiki page follows, for Claude and for you.",1,"/wiki/about/ai-instructions.md","advanced","Advanced",[75,76,77,78],{"_24":9,"_25":67,"_27":68,"_28":73,"_30":71,"_32":72,"_33":74},7,"wrench","Articles for when you want to go further, read in any order.","/wiki/advanced/index.md",{"_24":9,"_25":93,"_27":17,"_28":94,"_30":65,"_32":-7,"_33":95},{"_24":9,"_25":88,"_27":89,"_28":90,"_30":91,"_32":-7,"_33":92},{"_24":9,"_25":83,"_27":84,"_28":85,"_30":86,"_32":-7,"_33":87},{"_24":9,"_25":79,"_27":80,"_28":81,"_30":31,"_32":-7,"_33":82},"advanced/reading-the-code","Reading the code","Where things live in the app's code, for the curious.","/wiki/advanced/reading-the-code.md","advanced/kit-updates","Kit updates","Bring the kit's improvements into your app without losing your reports.",3,"/wiki/advanced/kit-updates.md","advanced/checkpoints","Saved versions","Keep a good state of your app, and go back to one.",2,"/wiki/advanced/checkpoints.md","advanced/metrics","Named measures with one definition, used by name in every report.","/wiki/advanced/metrics.md","reference",[103,104,105,10],{"_24":9,"_25":96,"_27":19,"_28":101,"_30":99,"_32":100,"_33":102},6,"library","Words, folders and common questions, to look up.","/wiki/reference/index.md",{"_24":9,"_25":114,"_27":115,"_28":116,"_30":65,"_32":-7,"_33":117},{"_24":9,"_25":110,"_27":111,"_28":112,"_30":91,"_32":-7,"_33":113},{"_24":9,"_25":106,"_27":107,"_28":108,"_30":86,"_32":-7,"_33":109},"reference/faq","Questions","Answers to the questions people ask most.","/wiki/reference/faq.md","reference/folders","Folders","Where each kind of file lives in your app.","/wiki/reference/folders.md","reference/words","Words","The words this wiki uses, in one place.","/wiki/reference/words.md","guides","Guides",[126,127,128,129,130],{"_24":9,"_25":118,"_27":119,"_28":124,"_30":122,"_32":123,"_33":125},5,"map","One job at a time, such as connecting your database or fixing a failing check.","/wiki/guides/index.md",{"_24":9,"_25":147,"_27":148,"_28":149,"_30":65,"_32":-7,"_33":150},{"_24":9,"_25":143,"_27":144,"_28":145,"_30":91,"_32":-7,"_33":146},{"_24":9,"_25":139,"_27":140,"_28":141,"_30":86,"_32":-7,"_33":142},{"_24":9,"_25":135,"_27":136,"_28":137,"_30":31,"_32":-7,"_33":138},{"_24":9,"_25":131,"_27":132,"_28":133,"_30":122,"_32":-7,"_33":134},"guides/wiki-pages","Write wiki pages","Add your own pages to this wiki by asking Claude.","/wiki/guides/wiki-pages.md","guides/fix-problems","Fix problems","What to do when a report says Not connected, a check fails or a figure looks wrong.","/wiki/guides/fix-problems.md","guides/ask-claude","Ask Claude","Requests that work well when you build reports.","/wiki/guides/ask-claude.md","guides/build-a-report","Build a report","Ask for a new report so it comes out right the first time.","/wiki/guides/build-a-report.md","guides/connect-database","Connect your database","Point the app at your data files or database, with the keys each connector needs.","/wiki/guides/connect-database.md","components","Components",[158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186],{"_24":9,"_25":151,"_27":152,"_28":156,"_30":31,"_32":155,"_33":157},"blocks","Every piece a report is built from, one page each, with its props, an example and the checks that fail it.","/wiki/components/index.md",{"_24":9,"_25":326,"_27":327,"_28":328,"_30":65,"_32":-7,"_33":329},{"_24":9,"_25":322,"_27":323,"_28":324,"_30":91,"_32":-7,"_33":325},{"_24":9,"_25":317,"_27":318,"_28":319,"_30":320,"_32":-7,"_33":321},{"_24":9,"_25":312,"_27":313,"_28":314,"_30":315,"_32":-7,"_33":316},{"_24":9,"_25":307,"_27":308,"_28":309,"_30":310,"_32":-7,"_33":311},{"_24":9,"_25":302,"_27":303,"_28":304,"_30":305,"_32":-7,"_33":306},{"_24":9,"_25":297,"_27":298,"_28":299,"_30":300,"_32":-7,"_33":301},{"_24":9,"_25":292,"_27":293,"_28":294,"_30":295,"_32":-7,"_33":296},{"_24":9,"_25":287,"_27":288,"_28":289,"_30":290,"_32":-7,"_33":291},{"_24":9,"_25":282,"_27":283,"_28":284,"_30":285,"_32":-7,"_33":286},{"_24":9,"_25":277,"_27":278,"_28":279,"_30":280,"_32":-7,"_33":281},{"_24":9,"_25":272,"_27":273,"_28":274,"_30":275,"_32":-7,"_33":276},{"_24":9,"_25":267,"_27":268,"_28":269,"_30":270,"_32":-7,"_33":271},{"_24":9,"_25":262,"_27":263,"_28":264,"_30":265,"_32":-7,"_33":266},{"_24":9,"_25":257,"_27":258,"_28":259,"_30":260,"_32":-7,"_33":261},{"_24":9,"_25":252,"_27":253,"_28":254,"_30":255,"_32":-7,"_33":256},{"_24":9,"_25":247,"_27":248,"_28":249,"_30":250,"_32":-7,"_33":251},{"_24":9,"_25":242,"_27":243,"_28":244,"_30":245,"_32":-7,"_33":246},{"_24":9,"_25":237,"_27":238,"_28":239,"_30":240,"_32":-7,"_33":241},{"_24":9,"_25":232,"_27":233,"_28":234,"_30":235,"_32":-7,"_33":236},{"_24":9,"_25":227,"_27":228,"_28":229,"_30":230,"_32":-7,"_33":231},{"_24":9,"_25":222,"_27":223,"_28":224,"_30":225,"_32":-7,"_33":226},{"_24":9,"_25":217,"_27":218,"_28":219,"_30":220,"_32":-7,"_33":221},{"_24":9,"_25":212,"_27":213,"_28":214,"_30":215,"_32":-7,"_33":216},{"_24":9,"_25":207,"_27":208,"_28":209,"_30":210,"_32":-7,"_33":211},{"_24":9,"_25":202,"_27":203,"_28":204,"_30":205,"_32":-7,"_33":206},{"_24":9,"_25":197,"_27":198,"_28":199,"_30":200,"_32":-7,"_33":201},{"_24":9,"_25":192,"_27":193,"_28":194,"_30":195,"_32":-7,"_33":196},{"_24":9,"_25":187,"_27":188,"_28":189,"_30":190,"_32":-7,"_33":191},"components/definition","Definition","A named metric's one-line definition, quoted in the dialog from app/src/metrics/metrics.ts.",55,"/wiki/components/definition.md","components/value","Value","One figure from the report's own data, printed in the dialog in a format.",54,"/wiki/components/value.md","components/sql","Sql","Shows one of the report's queries, as the database runs it, in the dialog.",53,"/wiki/components/sql.md","components/rules","Rules, Rule and Lead","The definitions a report follows, written once in the dialog and picked by id into each block's \"(i)\".",52,"/wiki/components/rules.md","components/panel","Panel","A further tab in the report's \"(i)\" dialog, after Info and Technical, for reading that is not rules or SQL.",51,"/wiki/components/panel.md","components/dialog","Info and Technical","The report's \"(i)\" in the header, with an Info tab for the reader and a Technical tab for the SQL.",50,"/wiki/components/dialog.md","components/number","number","A typed number inside an Inputs card, with the same props as a slider.",44,"/wiki/components/number.md","components/slider","slider","A number picked on a slider inside an Inputs card, its default and \"Today\" value read from the data.",43,"/wiki/components/slider.md","components/toggle","toggle","An on/off switch in the View menu, kept in the URL as on or off.",42,"/wiki/components/toggle.md","components/select","select","A choice from a list, in the View menu or the filter bar, with fixed options or options from the data.",41,"/wiki/components/select.md","components/inputs","Inputs","Values the reader sets, kept in the URL; a card of sliders and numbers on the page for a model's assumptions.",40,"/wiki/components/inputs.md","components/drill","Drills","Blocks drawn for one row in a dialog, opened by clicking a table row or a tile.",32,"/wiki/components/drill.md","components/tabs","Tabs","Groups of blocks shown one at a time under tabs, optionally kept in the URL as an input.",31,"/wiki/components/tabs.md","components/section","Section","A heading over a group of blocks, laid out like the page or three across.",30,"/wiki/components/section.md","components/share-bars","ShareBars","A list of labelled bars, each filled to a share out of 100.",23,"/wiki/components/share-bars.md","components/grouped-table","GroupedTable","Rows with the same measures repeated under a header per group, such as one group of columns per region.",22,"/wiki/components/grouped-table.md","components/table","Table","Rows and columns, with formats, totals, a column picker, copy, Excel download and row drills.",21,"/wiki/components/table.md","components/kpis","Kpis","A row of figures as tiles, from one row of a result or one tile per row, with deltas, targets and drills.",20,"/wiki/components/kpis.md","components/driver-tree","DriverTree","Measures joined parent to child as cards on a canvas, each its figure against its target.",18,"/wiki/components/driver-tree.md","components/progress","Progress","A figure against its target as a bar, with a projection behind it and up to three figures under it.",17,"/wiki/components/progress.md","components/waffle","Waffle","Stages as 100 squares, the largest stage the whole, each square shaded by the deepest stage its 1 % reaches.",16,"/wiki/components/waffle.md","components/funnel","Funnel","Stages that narrow, drawn as nested areas proportional to each stage's count.",15,"/wiki/components/funnel.md","components/treemap","Treemap","Shares of a whole as nested rectangles, one per row, optionally grouped.",14,"/wiki/components/treemap.md","components/bars-with-line","BarsWithLine","A count as bars and a rate as a line on one chart, on two axes that share zero.",13,"/wiki/components/bars-with-line.md","components/category-bars","CategoryBars","One measure across categories as bars, with a value label per bar and an optional reference line.",12,"/wiki/components/category-bars.md","components/stacked-bars","StackedBars","Parts of a whole per period as stacked bars, with totals, shares, rate lines and clickable bars.",11,"/wiki/components/stacked-bars.md","components/line","Line","One or more measures over time as lines, with targets, value labels and small multiples.",10,"/wiki/components/line.md","components/common","Props every block takes","title, description, span, info and metric, the When and Repeat wrappers, and the number formats every block prints with.","/wiki/components/common.md","components/report-file","The report file","What report.tsx holds, how its SQL runs, the dialect of each connector, and the checks a report must pass.","/wiki/components/report-file.md","learn","Learn",[337,338,339],{"_24":9,"_25":330,"_27":331,"_28":335,"_30":86,"_32":334,"_33":336},"graduation-cap","A short course from an open folder to a report of your own.","/wiki/learn/index.md",{"_24":9,"_25":348,"_27":349,"_28":350,"_30":65,"_32":-7,"_33":351},{"_24":9,"_25":344,"_27":345,"_28":346,"_30":91,"_32":-7,"_33":347},{"_24":9,"_25":340,"_27":341,"_28":342,"_30":86,"_32":-7,"_33":343},"learn/next","Make it yours","Lesson 3. Add charts, a table, the dialog, the date filter and an input.","/wiki/learn/next.md","learn/start","Your first report","Lesson 2. Ask Claude for a report on one of your tables, and open it.","/wiki/learn/start.md","learn/setup","Setup","Lesson 1. Open the app, see the example reports, connect your database.","/wiki/learn/setup.md","how-it-works","How it works",[359],{"_24":9,"_25":352,"_27":353,"_28":357,"_30":91,"_32":356,"_33":358},"cog","How a report file becomes a page of figures from your database.","/wiki/how-it-works/index.md",{"_24":9,"_25":360,"_27":361,"_28":362,"_30":65,"_32":-7,"_33":363},"how-it-works/connectors","Connectors","How the reports reach your database, and which one a report uses.","/wiki/how-it-works/connectors.md","idea","The idea",[371],{"_24":9,"_25":364,"_27":365,"_28":369,"_30":65,"_32":368,"_33":370},"lightbulb","What Silvi is, in one page.","/wiki/idea/index.md",{"_24":9,"_25":372,"_27":373,"_28":374,"_30":65,"_32":-7,"_33":375},"idea/principles","Principles","The rules every report and every change keeps.","/wiki/idea/principles.md"]