My requirement is to create a pie chart with the above values ( i mean with each column total count).These total columns should be
Show breakdown by Success/ Failure / Partial Success / Ignored. Show a pie chart for the week
with above data , i need to create a drill down for the above piechart
When i select anyone of the above values like (Success,Failure,Ignored,Partial) ,I have the row value as Name which has machine name as its values.
My search is ,
index=macqw2|fillnull|search name="Saqpedc102" |eventstats sum(Current_Failure) as Failure,sum(Current_Ignored) as Ignored,sum(Current_Partial) as Partial,sum(Current_Success) as Success |transpose|Rename "column" as Delta|search Delta="Ignored"|table Site Partial Success Failure Ignored
I am getting error for this when i click th pie chart .Please help me with the search