May 22, 2013 at 10:54 am
Hello,
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
FROM CALL
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:
CallsCall_OperatoridCall_Status
1Paul SmithIn Progress
2Martin JonesIn Progress
5Tim EdwardsIn Progress
2James PeterIn Progress
3Paul SmithMonitoring
2Martin JonesOpen
4James PetersOpen
2Paul SmithOpen
1Tim EdwardsUser Action Required
4Paul SmithUser 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.
Thanks
May 23, 2013 at 4:29 am
Any ideas anyone?
May 24, 2013 at 3:40 am
Problem solved thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply