Display number of logs by timestamp

I’m querying CloudWatch logs and would like to display the number of log files which have been received at a specific time.

In explore mode Grafana shows this graph that I would like to replicate in my dashboard.

image

Unfortunately, the same query results in “Unable to graph data - Switch to table view” when I try to build my own dashboard. I want to send an alert every time I receive an error message and I don’t have Grafana 8 yet so need a graph instead of a table. This is my query:

FIELDS @message | filter @message like /ERROR/

How can I create a panel that looks like the one in the screenshot?

Can you use the data tab inside the Grafana Inspector panel to share your data?