Dear all, There are two columns with data: time (time scale in steps of 10 minutes) and val (amount of transactions). I need to calculate median values (med_val) for the val column for 7 weeks. The specific example for the point 12.04.2018 15:00:00 med_val = median ( val by 7 points. 5.04.2018 15:00:00, 29/03/2018 15:00:00, 22/03/2018 15:00:00, 15/03/2018 15:00:00, 8/8/2018 15:00:00, 03/03/2018 15:00:00, 22/02/2018 15:00:00), i.e. so median at 7 same time points on the same days of the week. If there are no data, then we consider that 0 transactions were performed. The best that I could come up with is: | timechart span=10m median(val) | timewrap 1w series=exact Are there any good solutions? Thanks in advance! ... View more

Dear all, There are three columns with data: time (time scale in steps of 10 minutes) , val (amount of transactions) and type (type of automated system - 3 different types only). I need to aggregate data for each type at the hour level - and calculate median(val) for each type on the hourly aggregation. As the answer should be 3 time series of the same length. What I did: source="data.txt" | chart median(val) by type, date_hour But X-axis contains not all hours, they aggregate into "OTHER" tab. Thanks in advance for the help. ... View more