Prepare table for stacked barchart

[krishman23]

Im planning to prepare a stacked barchart,

My current table looks like this

ID       |     Request      |       Response

---------------------------------------------

1       |    Req1             |  Success1

2       |    Req1             |  Success32

3       |    Req1             | 

4       |    Req2             |  Success41

5       |    Req2             |  Success21

6       |    Req2             |

7       |    Req2             |  Success22

I need to stack Total Req1 - 3, Req2-4 .... vs Successful response  for Req1 -2 (i.e. Success1,Success32 ) and for Req2 - 3 (Success41,Success21,Success22)

in table form

Req     | Total    |  Success

---------------------------------

Req1  | 3        | 2

Req2 |  4      | 3         

[ITWhisperer]

| stats count as Total count(eval(like(resp,"Success%"))) as Success by Req