Hi , given the below input (4 mins of sample access log data): _time,URI,Bytes 2021-05-18 02:01:00,a,1 2021-05-18 02:01:00,a,1 2021-05-18 02:02:00,a,1 2021-05-18 02:03:00,b,1 2021-05-18 02:03:00,b,1 2021-05-18 02:04:00,a,1 assuming a window of 2 mins, i want to perform some computations (average and standard dev of bytes grouped by URI) as below source="ds1.csv" host="vgspl11hr" index="sfp" sourcetype="csv" | table _time,URI,Bytes | timechart span=1m avg(Bytes) AS avg_bytes, stdev(Bytes) AS std_bytes by URI limit=0 | fillnull value="" | untable _time Measure Value | eval Metric=mvindex(split(Measure,": "),0),uri=mvindex(split(Measure,": "),1) | fields - Measure | eval time_uri=_time."__".uri | fields - uri - _time | xyseries time_uri Metric Value | eval _time=mvindex(split(time_uri,"__"),0),uri=mvindex(split(time_uri,"__"),1) | fields - time_uri with 2-min time window between (5/18/21 2:01:00.000 AM to 5/18/21 2:03:00.000 AM), below is the output: _time uri avg_bytes std_bytes 2021-05-18 02:01:00 a 1 0 2021-05-18 02:02:00 a 1 0 So, the timechart performed the computations on the existing URIs in the first 2 mins time window, in that case the URI=a. but i want the timechart to consider the existence of the URI = b. Is there a way to have the timechart consider all the values of the URI in the computation, even if not all of the URI have values in the time window? I need the output to be as below in the first 2 mins time window: _time uri avg_bytes std_bytes 2021-05-18 02:01:00 a 1 0 2021-05-18 02:01:00 b 2021-05-18 02:02:00 a 1 0 2021-05-18 02:02:00 b Is that possible?
... View more