Could not select single value for line chart

First of all, I am new to grafana. Its very impressive and unbelievable feature rich.
So far I was using seq just for viewing logs. Now we got the requirement to

  1. Have a time chart about response time in parts of our application
  2. Setup alerts when response time gets bad
  • What Grafana version and what operating system are you using?

Google Cloud console

  • What are you trying to achieve?
    I am running an webapplication using serilog for logging. Through filtering in serilog I send following log entries to loki
2022-07-27 11:22:24	
  "Message": "Req: \"DzaSettingsDetailQuery\", Resp: \"DzaSettingsDetailRsp\", Duration: 00:00:00.0192448",
  "MessageTemplate": "Req: {Name}, Resp: {RespName}, Duration: {@Elapsed}",
  "Name": "DzaSettingsDetailQuery",
  "RespName": "DzaSettingsDetailRsp",
  "Elapsed": "00:00:00.0192448",
  "EventId": {
    "Id": 35,
    "Name": "RequestDuration"
  "SourceContext": "avsweb.Application.Module.SettingsModul.Queries.DzaSettingsDetail.DzaSettingsDetailQuery",
  "TransportConnectionId": "pnnnoNCud9UNj9BmxqhFqA",
  "RequestId": "0HMJFLH39CL76:00000002",
  "RequestPath": "/_blazor",
  "ConnectionId": "0HMJFLH39CL76",
  "Application": "avsweb",
  "level": "info"

Now I want create a grafana dash board showing the field ‘Elapsed’ over time for each value in ‘Name’. As I am new to grafana I got lost somewhere or missed the point. Would be great if someone could point mit in the right direction.

  • How are you trying to achieve it?
    Created a new dashboard an started play around. I could mange view the log entries in Explorer, but was not able to create a chart.

I am playing with this query:

avg by(Elapsed) (rate({app=“avsweb_app”} [$__interval]))

  • What happened?
    All I get are a few vertical lines like this.

  • What did you expect to happen?
    Get a chart like this like in grafana doc,

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?