Hello all, I currently have the following data set, and a table will look like this: Test Iteration Results Test1 1 400 Test1 2 500 Test1 3 600 Test2 0 1000 Test2 1 500 Test2 2 1000 Test2 3 2000 We run a test several times and save the results for each time. What I need to do is to calculate iteration 0 for the tests that don't have it (test1), which will be a median of all other iterations available. What I want to do is add a new for, with the new value: Test Iteration Results Test1 0 500 Test1 1 400 Test1 2 500 Test1 3 600 Test2 0 1000 Test2 1 500 Test2 2 1000 Test2 3 2000 It needs to add only the iteration 0 for those tests that doesnt have it, and ignore the other cases. I've tried using appendpipe + eventstats, but It only rewrites the Iteration and Value fields: |appendpipe [ |eventstats median(Results) as Results, first(Test) as Test, | eval iteration=0 ] I would like to get some ideas on how to do this. Any help will be appreciated, thank you in advance.
... View more