IS there a way I can create a new field with a cumulative count of a unique ID?
For example, currently i have created a transaction which groups events together as "trips", however I would like to give each trip a number.
below is an example of what I am trying to acheive:
initially after using the transaction, the events will look like below. Each transaction event will have a unique vehicle ID, duration of trip and distance travelled.
I would like to add a cumulative count to act as a Trip Number.
Could anyone advise how I could achieve the above?