chart by 2 fields

[schufi01]

Hi,

is there a possibility to create a chart by these two fields? If possible I would like to create a heatmap out of this chart.

| eval error= if(count>50, 1, 0)
| chart sum(error) by cpwd_nr
| chart sum(error) by host

[jodonald · Accepted solution]

you could use |stats instead of |chart.

| eval error= if(count>50, 1, 0)
| stats sum(error) by cpwd_nr, host