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,
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
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
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