Dashboards & Visualizations

Prepare table for stacked barchart

krishman23
Explorer

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         

Labels (1)
Tags (2)

ITWhisperer
Ultra Champion
| stats count as Total count(eval(like(resp,"Success%"))) as Success by Req
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!