Measuring some aspect of system behaviour results in a CSV file containing data of the form:
dd-mmm-yyyy hh:ss:mm,process_name,some_metric1,some_metric2
What I want to do is make a line chart for some_metric1 over time, categorised by process_name. This will give me a lovely graph with lots of coloured lines, one per process.
I'd do this in Excel (man, I love me a PivotTable), but I'm bouncing off performance issues because my source data is 325K lines, and Excel ain't built to chart this kind of volume of data, at least not the way I'm doing it. Also, there's a manual import issue and I'd like to eliminate that.
I looked at R and then quickly got over myself (it's weird and I don't have time to learn it) and remembered about gnuplot, which seems entirely suited to the task at hand.
But I can't figure out how to pivot the data to provide multiple data series (i.e. the metrics for processes over time) on a single chart.
Clue me?