Graph by two fields

[AlexMcDuffMille]

Hello,

I have a log file that creates 3 unique files for each node every 15 minutes. I would like to graph the PercentUsed by HDD and by NODE, so for this example I would have 6 different lines. Currently I'm using an eval statement to concatenate the NODE and the HDD as a new field and graphing 'by new_field'.

Is there a more elegant way of doing this? Maybe somehow saying max(Percent_Used) by HDD by NODE?

The files look like this:

2013-11-19 07:52:06 (NODE1) HDD=1 Percent_Used=49%

2013-11-19 07:52:05 (NODE1) HDD=2 Percent_Used=19%

2013-11-19 07:52:05 (NODE1) HDD=3 Percent_Used=37%

2013-11-19 07:52:06 (NODE2) HDD=1 Percent_Used=50%

2013-11-19 07:52:05 (NODE2) HDD=2 Percent_Used=66%

2013-11-19 07:52:05 (NODE2) HDD=3 Percent_Used=05%

Thanks!!

[MuS · Accepted solution]

Hi AlexMcDuffMiller,

you can use chart for this kind of tables, see docs for the chart ... over ... by example.
If you want a table like output, the by argument sets the columns and the over argument sets the rows.

hope this helps ...

cheers, MuS