Help Center

| Submit or View Help Requests | Developer Docs |
| |

Recalculate a Calculated Field

When you set up a new calculated field, we only perform the calculation when we receive new event data that matches your calculation criteria. Recalculation is an optional way of running the calculation on historical event data. Recalculating historical data will update your participants’ profiles, but it won’t trigger your program rules to run—so you can safely perform a recalculation without affecting your program.

Start a recalculation

You can request a recalculation when setting up or editing a calculated field that uses either a sum or a count calculation.

  1. From the left navigation menu, select Data Sources → Fields.

  2. Open the field creation interface.

    • To create a new calculated field, select Create a calculated field.

    • To edit an existing calculated field, locate it in the Fields table. Hover your cursor over the field and select Edit.

  3. In the Review section, select the square-regular.svg Recalculate values on save checkbox.

Recalculation example

It’s currently September 26th. You are setting up a calculated field with a fixed 1-month tracking window. Rather than having your field start calculating values only from the 26th to the end of the month, you want it to take into account values from all of September. You can achieve this by selecting the square-regular.svg Backfill calculation checkbox while setting up the field. The recalculation begins after you save your changes.

Processing order

Recalculation is not instant and can take some time to complete, depending on how much data needs to be processed. You can check the status of your recalculation from the Data Sources → Processes page.

Any events that we receive while your recalculation is in progress will be placed in a queue until the recalculation is done. After the recalculation is completed, we will start to process the events in the order they were received.

Are the order of events important to your program logic?

Events may be processed out of order during a recalculation. This happens only if we receive new event data while the queued events are processing.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.