
The picture is the format I am going for.
The data comes out already pivoted once and produces a dataset consisting of 4 columns
date|state|total error|error change|
What I would like to get is the result in the picture but I am not sure how to go about this or if rapid miner is even the appropriate tool.
I'd be appreciative of any help or suggestions anyone might have