Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to get stacked Column chart working Expand / Collapse
Author
Message
Posted Wednesday, May 22, 2013 10:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:13 PM
Points: 112, Visits: 1,479
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:


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.

Thanks
Post #1455615
Posted Thursday, May 23, 2013 4:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:13 PM
Points: 112, Visits: 1,479
Any ideas anyone?
Post #1455931
Posted Friday, May 24, 2013 3:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 3:13 PM
Points: 112, Visits: 1,479
Problem solved thanks.
Post #1456353
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse