I am trying to get a stacked column chart to work. I have the following query:
SELECT COUNT(CALL_Status) AS Calls, Call_Operatorid, Call_Status
WHERE ( CALL_OPERATORID = 'Paul Smith' OR
CALL_OPERATORID = 'Martin Jones' OR
CALL_OPERATORID = 'Tim Edwards' OR
CALL_OPERATORID = 'James Peters') and (Call_Status <> 'Closed' or Call_Status = 'In Progress' or Call_Status = 'User Action Required' or Call_Status = 'Monitoring')
GROUP BY CALL_OPERATORID, Call_Status
If I run my query i get the following results:
Calls Call_Operatorid Call_Status
1 Paul Smith In Progress
2 Martin Jones In Progress
5 Tim Edwards In Progress
2 James Peter In Progress
3 Paul Smith Monitoring
2 Martin Jones Open
4 James Peters Open
2 Paul Smith Open
1 Tim Edwards User Action Required
4 Paul Smith User Action Required
I am trying to create a stacked column chart. I have dragged the chart on to the report. I would like the columns to contain the results for each Call Operatorid
So for instance the first stacked column would have 'Open' in red, 'In progress' in blue, 'monitoring' in green etc.
In the value section I have dragged Calls. I then added another field and then another field. Subsequently adding three calls values.
In the category groups section i added Call_Operatorid.
If i run the report all the stacked columns look the same height. What i need is for the respective stacks to correspond with the query results. Do i need to use an expression somehow?
Or does anyone know where I am going wrong.