Piechart split for selected hostname?

[super_edition]

Hello Everyone,

I am trying to create piechart for cache operation split(in percentage) for hit/miss/pass using the below query for the selected hostname:

index="my_index" openshift_container_name="container" 
| eval description=case(handling == "hit","HIT", handling == "miss","MISS", handling == "pass","PASS")
| search hostname="int-ie-yyp.grp"
| addtotals
| eval cache_hit=round(100*HIT/Total,1)
| eval cache_miss=round(100*MISS/Total,1)
| eval cache_pass=round(100*PASS/Total,1)

When I try with:

| stats values(cache_hit) as cacheHit values(cache_miss) as cacheMiss values(cache_pass) as cachePass by description

 no data is generated.

super_edition_0-1688638043231.png

However when I try for count it works:

| stats count by description

super_edition_1-1688638447379.png

Can someone please help.

[super_edition]

Its working as expected. Thank you @ITWhisperer 

[ITWhisperer · Accepted solution]

| stats count by description
| eventstats sum(count) as Total
| eval percent=100*count/Total
| fields description percent