There are two ways to define the data series for a diagram.
Series from columns: All column values are added to a series. The name of the series is the column header
Series from rows: All column values define the series. The names of the series is defined by the values of the label column. The values of the series are defined by the value column.
To display the result in a pie chart select the following configuration:
The result will be a multiple pie charts
A query summarizes cpu, io, and mem usage over all departments:
To display the results in a bar char select the following configuration
The results will be a bar chart with three bars for each department: