[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6},"actionData","errors","wiki/route",{"_7":8,"_9":10,"_11":12,"_13":14},"tree",{"_21":33,"_22":34,"_24":35,"_36":37,"_38":39,"_29":40},"page",{"_21":9,"_22":23,"_24":16,"_25":26,"_27":28,"_29":30,"_31":32},"crumbs",[15,16],"content","

You do not need these to build reports. Read one when the need comes up.

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Article	Read it when
Metrics	A measure is used in several reports and should have one definition
Saved versions	You want to keep a good state, or go back to one
Kit updates	The kit has improved and you want the improvements
Reading the code	You are curious how the app is built

\n",{"_17":18,"_19":20},"Advanced","label","Wiki","to","/wiki","kind","slug","advanced","title","description","Articles for when you want to go further, read in any order.","order",7,"icon","wrench","file","/wiki/advanced/index.md","folder","","Silvi","children",[43,44,45,46,47,48,49,50],"index",{"_21":9,"_22":34,"_24":35,"_25":41,"_27":-7,"_29":40,"_31":42},"book-open","A reporting starter kit. Connect your database and build reports by asking Claude.","/wiki/index.md",{"_21":33,"_22":362,"_24":363,"_36":364,"_38":365,"_27":63,"_29":366},{"_21":33,"_22":350,"_24":351,"_36":352,"_38":353,"_27":83,"_29":354},{"_21":33,"_22":328,"_24":329,"_36":330,"_38":331,"_27":78,"_29":332},{"_21":33,"_22":149,"_24":150,"_36":151,"_38":152,"_27":73,"_29":153},{"_21":33,"_22":116,"_24":117,"_36":118,"_38":119,"_27":120,"_29":121},{"_21":33,"_22":89,"_24":90,"_36":91,"_38":92,"_27":93,"_29":94},{"_21":33,"_22":23,"_24":16,"_36":65,"_38":10,"_27":28,"_29":30},{"_21":33,"_22":51,"_24":52,"_36":53,"_38":54,"_27":55,"_29":56},"about","About",[59],{"_21":9,"_22":51,"_24":52,"_25":57,"_27":55,"_29":56,"_31":58},8,"info","How this wiki is written and kept.","/wiki/about/index.md",{"_21":9,"_22":60,"_24":61,"_25":62,"_27":63,"_29":-7,"_31":64},"about/ai-instructions","Writing pages","The rules every wiki page follows, for Claude and for you.",1,"/wiki/about/ai-instructions.md",[66,67,68,69],{"_21":9,"_22":85,"_24":86,"_25":87,"_27":63,"_29":-7,"_31":88},{"_21":9,"_22":80,"_24":81,"_25":82,"_27":83,"_29":-7,"_31":84},{"_21":9,"_22":75,"_24":76,"_25":77,"_27":78,"_29":-7,"_31":79},{"_21":9,"_22":70,"_24":71,"_25":72,"_27":73,"_29":-7,"_31":74},"advanced/reading-the-code","Reading the code","Where things live in the app's code, for the curious.",4,"/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","Metrics","Named measures with one definition, used by name in every report.","/wiki/advanced/metrics.md","reference","Reference",[97,98,99,100],{"_21":9,"_22":89,"_24":90,"_25":95,"_27":93,"_29":94,"_31":96},6,"library","Words, folders and common questions, to look up.","/wiki/reference/index.md",{"_21":9,"_22":112,"_24":113,"_25":114,"_27":63,"_29":-7,"_31":115},{"_21":9,"_22":108,"_24":109,"_25":110,"_27":83,"_29":-7,"_31":111},{"_21":9,"_22":104,"_24":105,"_25":106,"_27":78,"_29":-7,"_31":107},{"_21":9,"_22":101,"_24":86,"_25":102,"_27":73,"_29":-7,"_31":103},"reference/metrics","Every named metric and dictionary term, written out from app/src/metrics/.","/wiki/reference/metrics.md","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",[124,125,126,127,128],{"_21":9,"_22":116,"_24":117,"_25":122,"_27":120,"_29":121,"_31":123},5,"map","One job at a time, such as connecting your database or fixing a failing check.","/wiki/guides/index.md",{"_21":9,"_22":145,"_24":146,"_25":147,"_27":63,"_29":-7,"_31":148},{"_21":9,"_22":141,"_24":142,"_25":143,"_27":83,"_29":-7,"_31":144},{"_21":9,"_22":137,"_24":138,"_25":139,"_27":78,"_29":-7,"_31":140},{"_21":9,"_22":133,"_24":134,"_25":135,"_27":73,"_29":-7,"_31":136},{"_21":9,"_22":129,"_24":130,"_25":131,"_27":120,"_29":-7,"_31":132},"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",[156,157,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],{"_21":9,"_22":149,"_24":150,"_25":154,"_27":73,"_29":153,"_31":155},"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",{"_21":9,"_22":324,"_24":325,"_25":326,"_27":63,"_29":-7,"_31":327},{"_21":9,"_22":320,"_24":321,"_25":322,"_27":83,"_29":-7,"_31":323},{"_21":9,"_22":315,"_24":316,"_25":317,"_27":318,"_29":-7,"_31":319},{"_21":9,"_22":310,"_24":311,"_25":312,"_27":313,"_29":-7,"_31":314},{"_21":9,"_22":305,"_24":306,"_25":307,"_27":308,"_29":-7,"_31":309},{"_21":9,"_22":300,"_24":301,"_25":302,"_27":303,"_29":-7,"_31":304},{"_21":9,"_22":295,"_24":296,"_25":297,"_27":298,"_29":-7,"_31":299},{"_21":9,"_22":290,"_24":291,"_25":292,"_27":293,"_29":-7,"_31":294},{"_21":9,"_22":285,"_24":286,"_25":287,"_27":288,"_29":-7,"_31":289},{"_21":9,"_22":280,"_24":281,"_25":282,"_27":283,"_29":-7,"_31":284},{"_21":9,"_22":275,"_24":276,"_25":277,"_27":278,"_29":-7,"_31":279},{"_21":9,"_22":270,"_24":271,"_25":272,"_27":273,"_29":-7,"_31":274},{"_21":9,"_22":265,"_24":266,"_25":267,"_27":268,"_29":-7,"_31":269},{"_21":9,"_22":260,"_24":261,"_25":262,"_27":263,"_29":-7,"_31":264},{"_21":9,"_22":255,"_24":256,"_25":257,"_27":258,"_29":-7,"_31":259},{"_21":9,"_22":250,"_24":251,"_25":252,"_27":253,"_29":-7,"_31":254},{"_21":9,"_22":245,"_24":246,"_25":247,"_27":248,"_29":-7,"_31":249},{"_21":9,"_22":240,"_24":241,"_25":242,"_27":243,"_29":-7,"_31":244},{"_21":9,"_22":235,"_24":236,"_25":237,"_27":238,"_29":-7,"_31":239},{"_21":9,"_22":230,"_24":231,"_25":232,"_27":233,"_29":-7,"_31":234},{"_21":9,"_22":225,"_24":226,"_25":227,"_27":228,"_29":-7,"_31":229},{"_21":9,"_22":220,"_24":221,"_25":222,"_27":223,"_29":-7,"_31":224},{"_21":9,"_22":215,"_24":216,"_25":217,"_27":218,"_29":-7,"_31":219},{"_21":9,"_22":210,"_24":211,"_25":212,"_27":213,"_29":-7,"_31":214},{"_21":9,"_22":205,"_24":206,"_25":207,"_27":208,"_29":-7,"_31":209},{"_21":9,"_22":200,"_24":201,"_25":202,"_27":203,"_29":-7,"_31":204},{"_21":9,"_22":195,"_24":196,"_25":197,"_27":198,"_29":-7,"_31":199},{"_21":9,"_22":190,"_24":191,"_25":192,"_27":193,"_29":-7,"_31":194},{"_21":9,"_22":185,"_24":186,"_25":187,"_27":188,"_29":-7,"_31":189},"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",[335,336,337],{"_21":9,"_22":328,"_24":329,"_25":333,"_27":78,"_29":332,"_31":334},"graduation-cap","A short course from an open folder to a report of your own.","/wiki/learn/index.md",{"_21":9,"_22":346,"_24":347,"_25":348,"_27":63,"_29":-7,"_31":349},{"_21":9,"_22":342,"_24":343,"_25":344,"_27":83,"_29":-7,"_31":345},{"_21":9,"_22":338,"_24":339,"_25":340,"_27":78,"_29":-7,"_31":341},"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",[357],{"_21":9,"_22":350,"_24":351,"_25":355,"_27":83,"_29":354,"_31":356},"cog","How a report file becomes a page of figures from your database.","/wiki/how-it-works/index.md",{"_21":9,"_22":358,"_24":359,"_25":360,"_27":63,"_29":-7,"_31":361},"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",[369],{"_21":9,"_22":362,"_24":363,"_25":367,"_27":63,"_29":366,"_31":368},"lightbulb","What Silvi is, in one page.","/wiki/idea/index.md",{"_21":9,"_22":370,"_24":371,"_25":372,"_27":63,"_29":-7,"_31":373},"idea/principles","Principles","The rules every report and every change keeps.","/wiki/idea/principles.md"]