Tables
The table view of an analysis shows the values of the series in a table. Table settings are saved with the analysis.
Settings
| Setting | What it changes |
|---|---|
| Displayed period | Start and end period of the table (e.g. from 2020-01 to 2025-12) |
| Series order | The order of the series in the table — move series up or down |
| Layout | Periods in rows and series in columns (default) or the other way round — series in rows, periods in columns |
| Newest first | Shows periods from the newest to the oldest |
| Decimals | How many digits after the decimal point are shown. Set for the whole table and, if needed, per series |
| Thousands separator | Whether numbers are grouped by thousands (e.g. 12,345.6) |
| Metadata | Whether the source, unit and frequency are shown above the values |
The number of decimals only changes the display — calculations use the exact values. Numbers follow the interface language: Lithuanian uses a decimal comma (1 234,5), English a decimal point (1,234.5).
Missing values are shown as empty cells.
Copy, download and print
- Copy table — copies the table to the clipboard; paste it into Excel, Word or an e-mail.
- Download — as XLSX (Excel) or CSV. The file also contains the metadata (title, source, unit).
- Print — the table is printed without menus; long tables are split across pages automatically.
- Add the table to a report.
Want the data in an Excel file to refresh by itself? Use the Excel add-in or Power Query.