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
| stats count as Total count(eval(like(resp,"Success%"))) as Success by Req