How to print latest value and average value of a column

[SG]

Hi, I have a list of values as shown below 

from the above picture data I wanted to pick the average of each column's values and the latest value of that column also. I am able to successfully take the average value but unable to print the latest value. Please help.

index=nextgen sourcetype=lighthouse_json sourcetype=lighthouse_json datasource=webpagetest step="Homepage" url="*.bundle"
| chart avg(objectSize) as average, tail 1 as latest by url

I gave "tail 1" to get the average value but the query is giving an error while executing it.

Thanks,

[isoutamo · Accepted solution]

Hi

You could try the next:

index=nextgen sourcetype=lighthouse_json sourcetype=lighthouse_json datasource=webpagetest step="Homepage" url="*.bundle"
| chart avg(objectSize) as average latest(objectSize) as latest by url

r. Ismo 

[gcusello]

Hi @SG,

I don't know if this is what you'r waiting for:

if you want a row for each url with average an latest value you can try this:

index=nextgen sourcetype=lighthouse_json sourcetype=lighthouse_json datasource=webpagetest step="Homepage" url="*.bundle"
| stats avg(objectSize) as average last(url) AS latest latest by url

If you want two values for each column in your chart, the easiest way is to have two tables.

Ciao.

Giuseppe