No visualization available

Question

![Showing matched records](/media/postImages/original/IMGV9Ld6yWRgu933t0bjok8Q)

Using AWS Log insights, I simply want to plot duration (unit is nanosecond, ideally shown as seconds) as the Y axis, instead it appears to count the matches. What am I missing please?

@timestamp,duration
2023-03-05 00:08:24.324,5440944
2023-03-05 00:08:15.052,16121353
2023-03-05 00:07:24.128,13136935
2023-03-05 00:07:21.830,13971799
2023-03-05 00:07:20.493,19536558
2023-03-05 00:07:12.665,13965687
2023-03-05 00:07:02.095,9988365
2023-03-05 00:06:49.970,17717579
2023-03-05 00:06:32.391,6515700

Answer

Hello hendry,

Time series visualizations work for queries with the following characteristics:
    The query contains one or more aggregation functions. 
    The query uses the bin() function to group the data by one field.

When you run a query that uses the bin() function to group the returned results by a time period, you can view the results as a line graph, stacked area graph, pie chart, or bar chart. This helps you more efficiently visualize trends in log events over time.

bin(period: Period)
	
Timestamp
	
Rounds the value of @timestamp to the given time period and then truncates. For example, bin(5m) rounds the value of @timestamp to 5 minutes before it truncates.

No visualization available

Relevant content