Let's assume you have the following data-set (Ride Number & Speed for each ride):
How would you go about calculating the speed difference between the different rides like so:
Here's what we'd do. In your data cube:
- Create a copy of your Speed field using the copy element transform
- Add a calculated element transform and set an offset of -1 to your Speed field placeholder. You can read more about offsets in placeholders here.
- Return a calculation of your Speed column minus the copied Speed column with the placeholder set to -1. For example:
The entire data cube will look like this:
