Forum Discussion

FireFireFire's avatar
FireFireFire
Frequent Visitor
9 years ago
Solved

Please help me with my Stacked Column Chart

I have a table "Incoming CC Calls".     I want to see how many calls were accepted / missed per queue.   I want to do this with a stacked column chart. On the X axis should be listed the ...
Need Help
Show and Tell
  • spuder's avatar
    spuder
    9 years ago

    Hi FireFireFire

     

    I would start with a calculated column that extracts the info wether it is a missed or accepted call.

     

     

    missed/accepted = IF([cc_talk_time]<0.1,"missed","accepted"

     

     

    generate your stacked column chart and use this column in legend. 

     

    use queues on the axis field 

     

    and cc_call_time on values (set cc_call_time to count)

     

    This is what I understand was your problem and the solution. 

spuder's avatar
spuder
Icon for Resolver IV rankResolver IV
9 years ago

Hi FireFireFire

 

I would start with a calculated column that extracts the info wether it is a missed or accepted call.

 

 

missed/accepted = IF([cc_talk_time]<0.1,"missed","accepted"

 

 

generate your stacked column chart and use this column in legend. 

 

use queues on the axis field 

 

and cc_call_time on values (set cc_call_time to count)

 

This is what I understand was your problem and the solution. 

FireFireFire's avatar
FireFireFire
Frequent Visitor
9 years ago

Great, thank you. Now I get it. The different values per column are the count of each distinct legend item.

Thanks!