Unable to get stacked Column chart working

  • 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

  • Any ideas anyone?

  • 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