[{"_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","

This wiki ships with every Silvi app. It explains the app, teaches you to\nbuild reports, documents every component, and is where you keep what you\nlearn about your own data.

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

Page	Read it to
Writing pages	See how pages are written, and what a page may hold

\n",{"_17":18,"_19":20},"About","label","Wiki","to","/wiki","kind","slug","about","title","description","How this wiki is written and kept.","order",8,"icon","info","file","/wiki/about/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":56,"_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":58,"_24":59,"_36":60,"_38":61,"_27":62,"_29":63},{"_21":33,"_22":23,"_24":16,"_36":51,"_38":10,"_27":28,"_29":30},[52],{"_21":9,"_22":53,"_24":54,"_25":55,"_27":56,"_29":-7,"_31":57},"about/ai-instructions","Writing pages","The rules every wiki page follows, for Claude and for you.",1,"/wiki/about/ai-instructions.md","advanced","Advanced",[66,67,68,69],{"_21":9,"_22":58,"_24":59,"_25":64,"_27":62,"_29":63,"_31":65},7,"wrench","Articles for when you want to go further, read in any order.","/wiki/advanced/index.md",{"_21":9,"_22":85,"_24":86,"_25":87,"_27":56,"_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":56,"_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":56,"_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":56,"_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":56,"_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":56,"_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":56,"_29":366,"_31":368},"lightbulb","What Silvi is, in one page.","/wiki/idea/index.md",{"_21":9,"_22":370,"_24":371,"_25":372,"_27":56,"_29":-7,"_31":373},"idea/principles","Principles","The rules every report and every change keeps.","/wiki/idea/principles.md"]