How to visualise single series stats sum by filed and it total

[dyapasrikanth]

I am getting statistics like below (only 3 categories)

Category    Amount
cat1     20
cat2     30
cat3     40

and added total column also with query

| basequery
| chart sum(amount) as Amount by category 
| addtotals row=f col=t labelfield=category

which chart I can use to show this data & how to show Total in different color or different location in chart.

I tried bar chart but got same color for all bars, pie chart showing totals also in the same chart (misleading)

[renjith_nair]

Try below search to get total as a different field.

| basequery
| chart sum(amount) as Amount by category 
|eventstats sum(Amount) as Total

Now you should be able to visualize with column or area with distinction in colors

Or even as an overlay

[dyapasrikanth]

Thanks for your reply @renjith_nair , I tried it, but getting following area chart

No total coming & not easy to understand

[renjith_nair]

Somehow the field "Total" is missing. Did you add the eventstats to  the search ?

Can you share your search ?