DQL
Questions about Dynatrace Query Language
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Result in Percentage of service in a single query

kumarv14
Visitor

i wants to check % of success and failure in my query these are (0","1","200","1001","2001","5001","5450")success code rest are all error code , so how can i get % of service in succes and failure respectively .
with this query i am achhieving counts of error code ,so it possible to get success and failure counts with % of success and failed one . Please help me to resolve this issue .

fetch logs,scanLimitGBytes:-1
| filter dt.system.bucket=="engineering" and index == "db"
| filter Market == "IND"
| filter not in (ResultCode,array ("0","1","200","1001","2001","5001","5450"))

 

 

| summarize count(),by:{TransactionType,ResultCode,ApiName}
|dedup TransactionType

 

@krzysztof_hoja 

 

 

1 REPLY 1

kumarv14
Visitor

@krzysztof_hoja could you please check my table data which one are for success and failure respectively i wants in a single table % of success and failure with counts of total and failed .

 
 

Featured Posts