I am working producing a table that calculates the number of incidents resolved by each analyst.
What my query does is produces a table with three columns with a count of 'Class Names':
Analyst / Class Name / count
What I am trying to do is produce an output with (4) columns with a count under the descrete columns and a total of the row to the right:
Analyst / Class Name 1 / Class Name 2 / Total Count (of all class names)
<query>
| table "Analyst" "Class Name"
| stats count by Analyst "Class Name"
<query>
| table "Analyst" "Class Name"
| chart count by Analyst "Class Name"
| addtotals
<query>
| table "Analyst" "Class Name"
| chart count by Analyst "Class Name"
| addtotals
This, this resolution works