How do I make a AWS Cloudwatch Insights line chart plot?

Question

I want to parse a structured JSON value as milliseconds, that looks like:

Instead with my AWS Log Insights query:

fields msg, duration, @timestamp
| filter msg == "fetching"
| display @timestamp, duration

When I click the Vizualization tab it says "No visualization available".

Can you try it from CloudWatch Dashboards instead? https://catalog.us-east-1.prod.workshops.aws/workshops/a8e9c6a6-0ba9-48a7-a90d-378a440ab8ba/en-US/200-cloudwatch/240-cloudwatch-dashboards/241-cloudwatch-dashboard — Sri, Mar 05 '23 at 01:38
Also struggling to make a metric filter https://s.natalian.org/2023-03-05/filter.png — hendry, Mar 05 '23 at 02:46
if you are using json data then you should remove all delimiters such as new lines and carriage returns — Sri, Mar 05 '23 at 03:25

score 0 · Answer 1 · answered Mar 05 '23 at 22:30

0

Try something like this


    fields @timestamp, duration
    | filter msg == "fetching"
    | stats avg(duration) as avgDuration by bin(1m)

answered Mar 05 '23 at 22:30

Venkat S

1 Answers1