in one single event, the field amount appears multiple times. What I need is a new field that includes the total_amount for each event, to calculate stats with it afterwards.
For instance, we have the field amount in an event three times:
Is it possible to add a field thats sums up the total_amount=20 in this event?
thanks for this hint. I tried it out, but I get an empty result.
The field i want to use is definded as a string in the fieldlist. Can this be the reason? On the other hand the same field works with | stats sum() commands