Pie chart show values section wise

[rj1408]

base search | stats dc(TransactionID),count(StatusSuccess), count(StatusFailure) as count by MainMethod |rename MainMethod as MicroService count(StatusSuccess) as Success count as Failed | replace LostStolen with LostandStolen RetailConversion with TransactionRetailConversion TempCreditLimit with TemporaryCreditLimitIncrease


Hi,  in the above query I want to add pie chart as visualization, right now in pie chart it is only showing the no of transactions hit per function and ignoring the Success and Failed status.

What i want is when I hover over the functions in  piechart I want to see the no Failed and Sucess Tranactions. How do i do that?

[rj1408]

Hi anyone? Ill again repost if the question isnt clear

[rj1408]

@ITWhisperer

[ITWhisperer]

The standard pie chart does not support the functionality you are after.

[rj1408]

Any other vizualization that can tell me total, success and failure?

[ITWhisperer]

You could use a stacked column chart of success and failure so the total height of the column is the total.