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)
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
Thanks for your reply @renjith_nair , I tried it, but getting following area chart
No total coming & not easy to understand
Somehow the field "Total" is missing. Did you add the eventstats to the search ?
Can you share your search ?