Here is the sample data:
{
"state": "Done",
"series": [
{
"refId": "A",
"fields": [
{
"config": {
"filterable": true
},
"name": "timestamp",
"type": "time",
"values": [
"2022-09-27 19:38:29.192",
"2022-09-27 19:35:52.336",
"2022-09-27 18:58:57.881",
"2022-09-27 18:58:13.518",
"2022-09-27 18:27:45.865",
"2022-09-27 18:26:40.607",
"2022-09-27 18:25:02.515",
"2022-09-27 17:21:12.877",
"2022-09-27 17:16:25.294",
"2022-09-27 17:15:07.978",
"2022-09-27 17:15:07.701",
"2022-09-27 17:15:06.953",
"2022-09-27 17:15:06.716",
"2022-09-27 17:11:41.377",
"2022-09-27 17:07:11.396",
"2022-09-27 17:07:10.986",
"2022-09-27 17:07:10.204",
"2022-09-27 17:07:10.014",
"2022-09-27 16:50:48.385",
"2022-09-27 16:43:40.523",
"2022-09-27 16:43:40.240",
"2022-09-27 16:43:39.305",
"2022-09-27 16:43:39.121",
"2022-09-27 16:42:12.329",
"2022-09-27 16:42:12.055",
"2022-09-27 16:42:11.044",
"2022-09-27 16:42:10.774",
"2022-09-27 16:40:40.566",
"2022-09-27 16:40:40.354",
"2022-09-27 16:38:58.466",
"2022-09-27 16:38:58.274"
],
"state": null
},
{
"config": {
"filterable": true
},
"name": "path",
"type": "string",
"values": [
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567"
],
"state": null
}
],
"first": [
"2022-09-27 19:38:29.192",
"2022-09-27 19:35:52.336",
"2022-09-27 18:58:57.881",
"2022-09-27 18:58:13.518",
"2022-09-27 18:27:45.865",
"2022-09-27 18:26:40.607",
"2022-09-27 18:25:02.515",
"2022-09-27 17:21:12.877",
"2022-09-27 17:16:25.294",
"2022-09-27 17:15:07.978",
"2022-09-27 17:15:07.701",
"2022-09-27 17:15:06.953",
"2022-09-27 17:15:06.716",
"2022-09-27 17:11:41.377",
"2022-09-27 17:07:11.396",
"2022-09-27 17:07:10.986",
"2022-09-27 17:07:10.204",
"2022-09-27 17:07:10.014",
"2022-09-27 16:50:48.385",
"2022-09-27 16:43:40.523",
"2022-09-27 16:43:40.240",
"2022-09-27 16:43:39.305",
"2022-09-27 16:43:39.121",
"2022-09-27 16:42:12.329",
"2022-09-27 16:42:12.055",
"2022-09-27 16:42:11.044",
"2022-09-27 16:42:10.774",
"2022-09-27 16:40:40.566",
"2022-09-27 16:40:40.354",
"2022-09-27 16:38:58.466",
"2022-09-27 16:38:58.274"
],
"parsers": {},
"length": 31
}
],
"annotations": [],
"request": {
"app": "explore",
"dashboardId": 0,
"timezone": "browser",
"startTime": 1664308073982,
"interval": "30s",
"intervalMs": 30000,
"panelId": "1234",
"targets": [
{
"refId": "A",
"key": "1234",
"query": "request_source: \"search\"\n",
"alias": "",
"metrics": [
{
"id": "1",
"type": "raw_data",
"settings": {
"size": "500"
}
}
],
"bucketAggs": [],
"timeField": "timestamp",
"datasource": {
"type": "elasticsearch",
"uid": "ABCD"
}
}
],
"range": {
"from": "2022-09-27T07:47:53.980Z",
"to": "2022-09-27T19:47:53.980Z",
"raw": {
"from": "now-12h",
"to": "now"
}
},
"requestId": "explore_left",
"rangeRaw": {
"from": "now-12h",
"to": "now"
},
"scopedVars": {
"__interval": {
"text": "30s",
"value": "30s"
},
"__interval_ms": {
"text": 30000,
"value": 30000
}
},
"maxDataPoints": 1261,
"liveStreaming": false,
"endTime": 1664308075444
},
"timeRange": {
"from": "2022-09-27T07:47:53.980Z",
"to": "2022-09-27T19:47:53.980Z",
"raw": {
"from": "now-12h",
"to": "now"
}
},
"timings": {
"dataProcessingTime": 0.29999999701976776
},
"graphFrames": [],
"tableFrames": [
{
"refId": "A",
"fields": [
{
"config": {
"filterable": true
},
"name": "timestamp",
"type": "time",
"values": [
"2022-09-27 19:38:29.192",
"2022-09-27 19:35:52.336",
"2022-09-27 18:58:57.881",
"2022-09-27 18:58:13.518",
"2022-09-27 18:27:45.865",
"2022-09-27 18:26:40.607",
"2022-09-27 18:25:02.515",
"2022-09-27 17:21:12.877",
"2022-09-27 17:16:25.294",
"2022-09-27 17:15:07.978",
"2022-09-27 17:15:07.701",
"2022-09-27 17:15:06.953",
"2022-09-27 17:15:06.716",
"2022-09-27 17:11:41.377",
"2022-09-27 17:07:11.396",
"2022-09-27 17:07:10.986",
"2022-09-27 17:07:10.204",
"2022-09-27 17:07:10.014",
"2022-09-27 16:50:48.385",
"2022-09-27 16:43:40.523",
"2022-09-27 16:43:40.240",
"2022-09-27 16:43:39.305",
"2022-09-27 16:43:39.121",
"2022-09-27 16:42:12.329",
"2022-09-27 16:42:12.055",
"2022-09-27 16:42:11.044",
"2022-09-27 16:42:10.774",
"2022-09-27 16:40:40.566",
"2022-09-27 16:40:40.354",
"2022-09-27 16:38:58.466",
"2022-09-27 16:38:58.274"
],
"state": null
},
{
"config": {
"filterable": true
},
"name": "_id",
"type": "string",
"values": [
"f65c4ad4-3e9b-123456",
"98d7dcd1-3e9b-123456",
"70ecb152-3e96-123456",
"567be4d3-3e96-123456",
"151d9140-3e92-123456",
"ee37d593-3e91-123456",
"b3c0cb14-3e91-123456",
"c91bcc76-3e88-123456",
"1db244a5-3e88-123456",
"ef9c2c13-3e87-123456",
"ef72d224-3e87-123456",
"ef003a39-3e87-123456",
"eede0c30-3e87-123456",
"74789501-3e87-123456",
"d38df8bf-3e86-123456",
"d34dbb6a-3e86-123456",
"d2d7a100-3e86-123456",
"d2b9dfd0-3e86-123456",
"89a0b7d1-3e84-123456",
"8a9a4f89-3e83-123456",
"8a6f9607-3e83-123456",
"89dfd920-3e83-123456",
"89c37780-3e83-123456",
"56096e93-3e83-123456",
"55dfc685-3e83-123456",
"554449d1-3e83-123456",
"551bb332-3e83-123456",
"1f5893d4-3e83-123456",
"1f3665d1-3e83-123456",
"e27d0c83-3e82-123456",
"e25dc4ac-3e82-123456"
],
"state": null
},
{
"config": {
"filterable": true
},
"name": "path",
"type": "string",
"values": [
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567"
],
"state": null
}
],
"first": [
"2022-09-27 19:38:29.192",
"2022-09-27 19:35:52.336",
"2022-09-27 18:58:57.881",
"2022-09-27 18:58:13.518",
"2022-09-27 18:27:45.865",
"2022-09-27 18:26:40.607",
"2022-09-27 18:25:02.515",
"2022-09-27 17:21:12.877",
"2022-09-27 17:16:25.294",
"2022-09-27 17:15:07.978",
"2022-09-27 17:15:07.701",
"2022-09-27 17:15:06.953",
"2022-09-27 17:15:06.716",
"2022-09-27 17:11:41.377",
"2022-09-27 17:07:11.396",
"2022-09-27 17:07:10.986",
"2022-09-27 17:07:10.204",
"2022-09-27 17:07:10.014",
"2022-09-27 16:50:48.385",
"2022-09-27 16:43:40.523",
"2022-09-27 16:43:40.240",
"2022-09-27 16:43:39.305",
"2022-09-27 16:43:39.121",
"2022-09-27 16:42:12.329",
"2022-09-27 16:42:12.055",
"2022-09-27 16:42:11.044",
"2022-09-27 16:42:10.774",
"2022-09-27 16:40:40.566",
"2022-09-27 16:40:40.354",
"2022-09-27 16:38:58.466",
"2022-09-27 16:38:58.274"
],
"parsers": {},
"length": 31
}
],
"logsFrames": [],
"traceFrames": [],
"nodeGraphFrames": [],
"graphResult": null,
"tableResult": {
"refId": "A",
"fields": [
{
"config": {
"filterable": true
},
"name": "timestamp",
"type": "time",
"values": [
"2022-09-27 19:38:29.192",
"2022-09-27 19:35:52.336",
"2022-09-27 18:58:57.881",
"2022-09-27 18:58:13.518",
"2022-09-27 18:27:45.865",
"2022-09-27 18:26:40.607",
"2022-09-27 18:25:02.515",
"2022-09-27 17:21:12.877",
"2022-09-27 17:16:25.294",
"2022-09-27 17:15:07.978",
"2022-09-27 17:15:07.701",
"2022-09-27 17:15:06.953",
"2022-09-27 17:15:06.716",
"2022-09-27 17:11:41.377",
"2022-09-27 17:07:11.396",
"2022-09-27 17:07:10.986",
"2022-09-27 17:07:10.204",
"2022-09-27 17:07:10.014",
"2022-09-27 16:50:48.385",
"2022-09-27 16:43:40.523",
"2022-09-27 16:43:40.240",
"2022-09-27 16:43:39.305",
"2022-09-27 16:43:39.121",
"2022-09-27 16:42:12.329",
"2022-09-27 16:42:12.055",
"2022-09-27 16:42:11.044",
"2022-09-27 16:42:10.774",
"2022-09-27 16:40:40.566",
"2022-09-27 16:40:40.354",
"2022-09-27 16:38:58.466",
"2022-09-27 16:38:58.274"
],
"state": null
},
{
"config": {
"filterable": true
},
"name": "_id",
"type": "string",
"values": [
"f65c4ad4-3e9b-123456",
"98d7dcd1-3e9b-123456",
"70ecb152-3e96-123456",
"567be4d3-3e96-123456",
"151d9140-3e92-123456",
"ee37d593-3e91-123456",
"b3c0cb14-3e91-123456",
"c91bcc76-3e88-123456",
"1db244a5-3e88-123456",
"ef9c2c13-3e87-123456",
"ef72d224-3e87-123456",
"ef003a39-3e87-123456",
"eede0c30-3e87-123456",
"74789501-3e87-123456",
"d38df8bf-3e86-123456",
"d34dbb6a-3e86-123456",
"d2d7a100-3e86-123456",
"d2b9dfd0-3e86-123456",
"89a0b7d1-3e84-123456",
"8a9a4f89-3e83-123456",
"8a6f9607-3e83-123456",
"89dfd920-3e83-123456",
"89c37780-3e83-123456",
"56096e93-3e83-123456",
"55dfc685-3e83-123456",
"554449d1-3e83-123456",
"551bb332-3e83-123456",
"1f5893d4-3e83-123456",
"1f3665d1-3e83-123456",
"e27d0c83-3e82-123456",
"e25dc4ac-3e82-123456"
],
"state": null
},
{
"config": {
"filterable": true
},
"name": "path",
"type": "string",
"values": [
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/aws",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/bgp-settings/a12334a1-a12b-1234-c12d-abc123456cdf/prefixes",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections/PF-L3-CON-1234567/bgp/a12334a1-a12b-1234-c12d-abc123456cdf",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567",
"/v2/services/cloud-routers/PF-L3-CUST-1234567/connections",
"/v2/services/cloud-routers/PF-L3-CUST-1234567"
],
"state": null
}
],
"first": [
"2022-09-27 19:38:29.192",
"2022-09-27 19:35:52.336",
"2022-09-27 18:58:57.881",
"2022-09-27 18:58:13.518",
"2022-09-27 18:27:45.865",
"2022-09-27 18:26:40.607",
"2022-09-27 18:25:02.515",
"2022-09-27 17:21:12.877",
"2022-09-27 17:16:25.294",
"2022-09-27 17:15:07.978",
"2022-09-27 17:15:07.701",
"2022-09-27 17:15:06.953",
"2022-09-27 17:15:06.716",
"2022-09-27 17:11:41.377",
"2022-09-27 17:07:11.396",
"2022-09-27 17:07:10.986",
"2022-09-27 17:07:10.204",
"2022-09-27 17:07:10.014",
"2022-09-27 16:50:48.385",
"2022-09-27 16:43:40.523",
"2022-09-27 16:43:40.240",
"2022-09-27 16:43:39.305",
"2022-09-27 16:43:39.121",
"2022-09-27 16:42:12.329",
"2022-09-27 16:42:12.055",
"2022-09-27 16:42:11.044",
"2022-09-27 16:42:10.774",
"2022-09-27 16:40:40.566",
"2022-09-27 16:40:40.354",
"2022-09-27 16:38:58.466",
"2022-09-27 16:38:58.274"
],
"parsers": {},
"length": 31
},
"logsResult": null
}
The goal is to show a Pie Chart with the 34 Cloud Routers (cloud-routers) and 4 BGP Settings (bgp-settings).