Thanks for quick reply,
I had a data for daily basis with half an hour intervals (so per day 48 events) will be generated in Database.
Getting data into index "myindex", using Splunk DB connect dbinput. On that index, with span period of 1 day, I have to calculate interval wise (00:00,00:30... so on) averages & summation for Column1 & Column2 on time interval basis.
i.e. for "0:00:00" on day1,day2 , day3... so on , values average and summation. and that should display in another column along with day1, day2, day3 values .. so on values with column1 & column2 values (as sample output provided in above question)
I have used stats, streamstats and timechart to achieve expected output, but not succeeded .
... View more