reporting on telephony data

[foxies22]

Hi all,

I've got transformed data  which contains a telephone pick up group plus if a call was answered or abandoned like so:

I'm struggling to find a way where i can return a result where it will list the unique group values and then count on the pick up state eg:

London    -       Answered          -  2
London    -        Abandoned      -  1

Birmingham -    Answered       -    1

Birmingham  - Abandoned     -    1

Would anyone be able to assist on how to acheive this?

Thanks in advanced 

[AlexanderPrime · Accepted solution]

If you are just looking for this in a a Table Visual.

Add a new table visual on your report, then add the following columns in:

Group

Pickup State

Count of Pickup State

To get the option of "Count of" - When adding Pickup State again in the columns, select the dropdown arrow and select "Count"