Creating a Helper Column (e.g. Wave or Year)

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.