topic Re: Pie chart show values section wise in Dashboards & Visualizations

Pie chart show values section wise

rj1408 — Wed, 17 Mar 2021 04:15:41 GMT

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?

Re: Pie chart show values section wise

rj1408 — Wed, 17 Mar 2021 04:16:45 GMT

@ITWhisperer

Re: Pie chart show values section wise

rj1408 — Mon, 22 Mar 2021 05:20:02 GMT

Hi anyone? Ill again repost if the question isnt clear

Re: Pie chart show values section wise

ITWhisperer — Tue, 23 Mar 2021 10:30:06 GMT

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

Re: Pie chart show values section wise

rj1408 — Tue, 23 Mar 2021 10:45:05 GMT

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

Re: Pie chart show values section wise

ITWhisperer — Tue, 23 Mar 2021 10:55:08 GMT

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