elasticsearch - how to fetch value of key from message in grafana?

Question

I am very new to grafana, and trying to build dashboard using grafana and datasource as elastic search. I am getting one column message and for that i am getting some values: example one value:

{ "correlationId" : "64e0cb30-4b2c-11eb-80da-52e0855f2deb", "message" : "JSON LOGGER Message", "tracePoint" : "START", "priority" : "INFO", "elapsed" : 0, "locationInfo" : { "lineInFile" : "15", "component" : "json-logger:logger", "fileName" : "grafana-business-logic-poc.xml", "rootContainer" : "grafana-business-logic-pocFlow" }, "timestamp" : "2020-12-31T05:52:40.806Z", "content" : { "payload" : { "name" : "xyz", "age" : 24, "status" : 2 } }, "applicationName" : "grafana-business-logic-poc", "applicationVersion" : "1.0.0-SNAPSHOT", "environment" : "SANDBOX", "threadName" : "[MuleRuntime].uber.04: [grafana-business-logic-poc].grafana-business-logic-pocFlow.BLOCKING @62c6b1c6" }

Now in order to make dashboard what i want to do is timestamp in x axes and status value inside payload i want to fetch and show in y-axis.

Anyhelp will be appreciable.

Kind regards, Vikas

question from:https://stackoverflow.com/questions/65517328/how-to-fetch-value-of-key-from-message-in-grafana

Answer 1

Waitting for answers