Spreadsheet Tables provide a structured way to organize and analyze your data. With spreadsheet tables, you can easily sort, filter, and perform calculations on your data.
There are two common ways to create tables in Lido.
When you connect a datasource to Lido, any live data is automatically added as a spreadsheet table.
Simply select a spreadsheet range and right click to turn that range into a table.
When you've created a table, you'll see its name in the Table Toolbar. The Table Toolbar contains various actions you can perform on a table such as sorting, filtering, editing the data, joining with other tables, etc.
You can reference an entire table, a single column, or a single cell in a table using structured reference syntax.
=TableName returns all the values in the table
=TableName[Column] returns all the values in the column
=TableName[@Column] returns the value of the cell in the current row of the specified column
Structured references are particularly useful when you have a table of live data that is constantly updating.
Instead of constantly updating your formulas with new row references as the table expands, you can just reference the column name using structured references, like =SUM(table[sales]). This makes your formulas more flexible and easier to maintain over time, especially if you have a large amount of live data that is constantly updating.
You can filter, sort, and pivot tables from the spreadsheet toolbar. Note that the filter and sort options will only be visible when your cursor is inside a table.
Joining live data across different sources is one of Lido's most powerful features. You can access the join modal through the spreadsheet toolbar.
Learn more about Joining tables
In addition to filtering, sorting, and pivoting, you can also extend tables from datasources with additional columns that are defined in the spreadsheet.
This means you can add custom calculations, formulas, or even lookups to enrich your data, all while keeping it in the context of the original table. The new computed column will be automatically included in any filtering, sorting, or pivoting you do on the table.
Updated 6 months ago