Hi, We are looking for a splunk query using which we have to create a dashboard to show average and maximum TPS for all the services get triggered during the given time frame. First we need to calculate the TPS for all the services second wise and then from that data set we have to calculate Max, Min and Avg TPS. for example- for service1 and service2 we have below TPS value second wise (there is no field called TPS, we have to calculate it first)- Time--------Service1 - Service2 0:00:01 -------10-----------15 0:00:02 -------12-----------18 0:00:03 -------14-----------12 0:00:04 -------8-----------10 Then our table should be looking like this- Service Name ------------ Max TPS ----------- Min TPS -------- Avg TPS Service1 -------------------- 14 ----------- 8 ---------- 11 Service2 -------------------- 18 ----------- 10 ------------ 13.75 We have used below query which is giving only second wise TPS for each service but not able to apply min, max, avg on that- ** Search string | timechart count by host span=1s** Looking for your support. Thanks, Sourav ... View more