Actual and avg values on one timechart

[lain179]

I would like to draw a line time chart that shows both real values and avg values of Search Time.

When I do timechart avg(SearchTime) values(SearchTime) only avg works.

When I do table _time "SearchTime" only real values show.

How can I put them together on a chart?

Thanks!

[Ayn · Accepted solution]

If you use timechart and want to put its results in a graph, you need one value per time slice. If you want more values, change the timespan. The output from values() cannot be consumed by the chart (how would it know where to put which value?)