How to use the timestamp & cpu values available in the json data to plot the time series graph

I want to extract the & from the given below log and plot the time series graph. If anyone knows how to do this, Please share the query to do this? Thanks.

2024-02-12 18:53:42.938	{"timestamp": "2024-02-12 12:33:42.931311", "name": "process", "memory": 160, "cpu": 90, "fd": 140}
2024-02-12 18:53:42.931	{"timestamp": "2024-02-12 12:28:42.931311", "name": "process", "memory": 150, "cpu": 80, "fd": 130}
2024-02-12 18:53:42.947	{"timestamp": "2024-02-12 12:48:42.931311", "name": "process", "memory": 190, "cpu": 120, "fd": 170}
2024-02-12 18:53:42.944	{"timestamp": "2024-02-12 12:43:42.931311", "name": "process", "memory": 180, "cpu": 110, "fd": 160}
2024-02-12 18:53:42.941	{"timestamp": "2024-02-12 12:38:42.931311", "name": "process", "memory": 170, "cpu": 100, "fd": 150}

You can try the extract fields transformation, to split your json payload into fields and values, and then you can plot the values:

image

1 Like