Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.caplena.com/llms.txt

Use this file to discover all available pages before exploring further.

When you upload several datasets, or example, monthly or yearly data, it’s helpful to differentiate between uploads by assigning a label such as Wave 1, Wave 2, or 2024 / 2025. This allows you to:
  • Filter or segment results per upload
  • Compare time periods (e.g., “Wave 1 vs Wave 2”)
  • Create clear visualizations over time
Caplena offers an easy way to do this using Smart Columns. You can easily create a new Formula Column that assigns the same value to all records in your dataset. This is the easiest and most efficient method. When you upload new data waves, you can include this column directly in your dataset to clearly highlight which records belong to each wave or year. How to do it:
1
Go to Columns → Add Column → Smart Columns → Formula
2
Choose Output type: Text
3
Enter the following formula: Wave 1 or 2025
4
Save the column
This will add a new column with the same value (“Wave 1” or “2025”) for every row in your dataset.
Last modified on May 22, 2026