总任务数
app_id:42012 and title_name:'抢舱执行日志' and title_message: Task and title_message: 4525 | select count(*) "任务数" where json_extract_scalar(title_message, '$.bizParam.query_price.Id')= '4525'
成功率统计
app_id:42012 and title_name:'抢舱执行日志' and title_message: Task and title_message: 4525 | select sum(if(json_extract_scalar(title_message, '$.result')='success' or json_extract_scalar(title_message, '$.result')='noData',1,0))100/count() as "成功率" where json_extract_scalar(title_message, '$.bizParam.query_price.carrierId')= '4525'