--- title: "How do I see where a value in my results came from?" slug: "how-do-i-see-where-a-value-in-my-results-came-from" tags: ["LumiCode", "Candela"] updated: 2026-10-23T12:22:28Z published: 2026-10-23T12:22:28Z canonical: "support.lusid.com/how-do-i-see-where-a-value-in-my-results-came-from" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.lusid.com/llms.txt > Use this file to discover all available pages before exploring further. # How do I see where a value in my results came from? When a number in your results looks wrong, the first question is where it came from. LumiCode's lineage shows exactly how a result was arrived at: the tables, joins and filters behind it, and what each calculated column is worked out from, through views and even other providers. Candela can then explain it in plain words. ## Prerequisites - LumiCode installed and signed in. See [How do I install LumiCode?](/v1/docs/how-do-i-install-lumicode) - Lineage turned on, which it is by default. If `/set` shows `lineage off`, run `/set lineage on` and run the query again. Note Lineage isn't available for queries run together as a multi-query. ## Methods ### Method 1: See how the whole result was arrived at Type `/lineage` and press Enter. LumiCode draws the query as a tree of tables, joins and filters, read from the top down. To include the full filter expressions, type `/lineage all`. ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-PW4ACMK3.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A08%3A42Z&se=2026-11-18T20%3A08%3A42Z&sr=b&sp=r&sig=8nFoSfhSNEABmJl%2FisAxMLbN2LWrBe6fNDV%2FKITd9Gs%3D) ### Method 2: Explain one column A marker on a column heading means LumiCode can explain that column: - `ƒ`: calculated - `Σ`: aggregated - `∂`: derived To explain one, type `/lineage <column>`, for example `/lineage MarketValue`. LumiCode shows what the column is calculated from. You can also do this while browsing the results: 1. Type `/rows` and press Enter. 2. Press `c` to open the column picker. 3. Move to the column and press `x`. To see the whole query instead, press `t`. ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-13A9KLW8.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A08%3A42Z&se=2026-11-18T20%3A08%3A42Z&sr=b&sp=r&sig=RS44PNE3Bsl0stis96wVX9L9t6QMaBqAEhkHIdS0Ngs%3D) ### Method 3: Ask Candela to explain it Type `/lineage ai` for the whole query, or `/lineage <column> ai` for one column. Candela writes an explanation in plain words into the transcript. From a lineage screen in `/rows`, press `a` to do the same. ![](https://cdn.document360.io/d575ad81-c0ed-4980-bbd1-d59ac5c3de82/Images/Documentation/image-5L5LPYSY.png?sv=2026-02-06&spr=https&st=2026-11-18T19%3A08%3A42Z&se=2026-11-18T20%3A08%3A42Z&sr=b&sp=r&sig=8egDBPxkksf2%2Fn3CXysBdMI9QYGgZCmDRUD1xberUn0%3D) Candela availability Candela is currently available to some customers only. If it isn't available in your domain, LumiCode tells you, and Methods 1 and 2 still work. ## Related articles - [How do I explore, group and chart results?](/v1/docs/how-do-i-explore-group-and-chart-results) - [How do I use Candela to write or fix a query?](/v1/docs/how-do-i-use-candela-to-write-or-fix-a-query)