How we add additional information on Kibana Visualize which is queried by Buckets's X-axis result IDs?

Hello, I'd like to show the additional information on Kibana Visualize close to Buckets's X-axis.
Currently, my X-axis result is document's ids. (That is parent data)
These documents have children documents. (But we don't use join feature)
I'd like to show the information which is children document data that is searched by Bucket's X-axis result's id.

For example, below data's parent id is '562c1ea71b85c270'.
finally, I'd like to show children data's tags.graphql.source information (I need to take first 10 - 20 words).
I think we need to write some script for fetching this information.

By the way, Kibana Visualize can be queried by Buckets's X-axis result and then just showing?
How we do this kind of complicated visualization?

Thank you so much.

mapping
{
    "zipkin-span-2021-10-18":{
       "aliases":{
          
       },
       "mappings":{
          "_source":{
             "excludes":[
                "_q"
             ]
          },
          "dynamic_templates":[
             {
                "strings":{
                   "match":"*",
                   "match_mapping_type":"string",
                   "mapping":{
                      "ignore_above":256,
                      "norms":false,
                      "type":"keyword"
                   }
                }
             }
          ],
          "properties":{
             "_q":{
                "type":"keyword"
             },
             "annotations":{
                "type":"object",
                "enabled":false
             },
             "duration":{
                "type":"long"
             },
             "id":{
                "type":"keyword",
                "ignore_above":256
             },
             "kind":{
                "type":"keyword",
                "ignore_above":256
             },
             "localEndpoint":{
                "dynamic":"false",
                "properties":{
                   "serviceName":{
                      "type":"keyword"
                   }
                }
             },
             "name":{
                "type":"keyword"
             },
             "parentId":{
                "type":"keyword",
                "ignore_above":256
             },
             "remoteEndpoint":{
                "dynamic":"false",
                "properties":{
                   "serviceName":{
                      "type":"keyword"
                   }
                }
             },
             "tags":{
                "type":"object",
                "enabled":false
             },
             "timestamp":{
                "type":"long"
             },
             "timestamp_millis":{
                "type":"date",
                "format":"epoch_millis"
             },
             "traceId":{
                "type":"keyword"
             }
          }
       },
       "settings":{
          "index":{
             "number_of_shards":"5",
             "provided_name":"zipkin-span-2021-10-18",
             "creation_date":"1634536102682",
             "requests":{
                "cache":{
                   "enable":"true"
                }
             },
             "number_of_replicas":"1",
             "uuid":"ZN66UyddS8-YFlSly6M-5Q",
             "version":{
                "created":"7090399"
             }
          }
       }
    }
 }
parent document
curl -s 'localhost:9200/zipkin*/_search?q=id:6173b7140ef7d23f'
{
   "took":2,
   "timed_out":false,
   "_shards":{
      "total":5,
      "successful":5,
      "skipped":0,
      "failed":0
   },
   "hits":{
      "total":{
         "value":1,
         "relation":"eq"
      },
      "max_score":3.1780539,
      "hits":[
         {
            "_index":"zipkin-span-2021-10-18",
            "_type":"_doc",
            "_id":"6c4bd64364ca942608948c00212c0c9a-2abaeb0c1767e3169a0014169fe4a420",
            "_score":3.1780539,
            "_source":{
               "traceId":"6c4bd64364ca942608948c00212c0c9a",
               "duration":224484,
               "localEndpoint":{
                  "serviceName":"unknown_service:node"
               },
               "timestamp_millis":1634536273448,
               "kind":"SERVER",
               "name":"http post",
               "id":"562c1ea71b85c270",
               "timestamp":1634536273448577,
               "tags":{
                  "http.flavor":"1.1",
                  "http.host":"localhost:3000",
                  "http.method":"POST",
                  "http.request_content_length_uncompressed":"163",
                  "http.route":"/graphql",
                  "http.status_code":"200",
                  "http.status_text":"OK",
                  "http.target":"/graphql",
                  "http.url":"http://localhost:3000/graphql",
                  "http.user_agent":"PostmanRuntime/7.28.4",
                  "net.host.ip":"::1",
                  "net.host.name":"localhost",
                  "net.host.port":"3000",
                  "net.peer.ip":"::1",
                  "net.peer.port":"50754",
                  "net.transport":"ip_tcp",
                  "ot.status_code":"OK",
                  "service.name":"unknown_service:node",
                  "telemetry.sdk.language":"nodejs",
                  "telemetry.sdk.name":"opentelemetry",
                  "telemetry.sdk.version":"0.24.0"
               }
            }
         }
      ]
   }
}
children data
curl -s 'localhost:9200/zipkin*/_search?q=parentId:562c1ea71b85c270'

{
   "took":4,
   "timed_out":false,
   "_shards":{
      "total":5,
      "successful":5,
      "skipped":0,
      "failed":0
   },
   "hits":{
      "total":{
         "value":18,
         "relation":"eq"
      },
      "max_score":2.7725885,
      "hits":[
         {
            "_index":"zipkin-span-2021-10-18",
            "_type":"_doc",
            "_id":"6c4bd64364ca942608948c00212c0c9a-005a0a2a214d24489f5114739494d0e1",
            "_score":2.7725885,
            "_source":{
               "traceId":"6c4bd64364ca942608948c00212c0c9a",
               "duration":565,
               "localEndpoint":{
                  "serviceName":"unknown_service:node"
               },
               "timestamp_millis":1634536273450,
               "name":"middleware - query",
               "id":"486eeec3b920a9a0",
               "parentId":"562c1ea71b85c270",
               "timestamp":1634536273450807,
               "tags":{
                  "express.name":"query",
                  "express.type":"middleware",
                  "http.route":"/",
                  "ot.status_code":"UNSET",
                  "service.name":"unknown_service:node",
                  "telemetry.sdk.language":"nodejs",
                  "telemetry.sdk.name":"opentelemetry",
                  "telemetry.sdk.version":"0.24.0"
               }
            }
         },
         {
            "_index":"zipkin-span-2021-10-18",
            "_type":"_doc",
            "_id":"6c4bd64364ca942608948c00212c0c9a-89b8a9320b388356696bca9526537134",
            "_score":2.7725885,
            "_source":{
               "traceId":"6c4bd64364ca942608948c00212c0c9a",
               "duration":247,
               "localEndpoint":{
                  "serviceName":"unknown_service:node"
               },
               "timestamp_millis":1634536273592,
               "name":"graphql.parse",
               "id":"84b6623ee1b43a9d",
               "parentId":"562c1ea71b85c270",
               "timestamp":1634536273592592,
               "tags":{
                  "graphql.source":"query Projects {\n  __typename\n  projects {\n    __typename\n    id\n    name\n    code\n    photoID\n  }\n}",
                  "ot.status_code":"UNSET",
                  "service.name":"unknown_service:node",
                  "telemetry.sdk.language":"nodejs",
                  "telemetry.sdk.name":"opentelemetry",
                  "telemetry.sdk.version":"0.24.0"
               }
            }
         },
         {
            "_index":"zipkin-span-2021-10-18",
            "_type":"_doc",
            "_id":"6c4bd64364ca942608948c00212c0c9a-62fd79571b7d4c72f0fb8bc1d0973a62",
            "_score":2.2735975,
            "_source":{
               "traceId":"6c4bd64364ca942608948c00212c0c9a",
               "duration":303,
               "localEndpoint":{
                  "serviceName":"unknown_service:node"
               },
               "timestamp_millis":1634536273453,
               "name":"middleware - use",
               "id":"43a5203c6649943e",
               "parentId":"562c1ea71b85c270",
               "timestamp":1634536273453045,
               "tags":{
                  "express.name":"use",
                  "express.type":"middleware",
                  "http.route":"/",
                  "ot.status_code":"UNSET",
                  "service.name":"unknown_service:node",
                  "telemetry.sdk.language":"nodejs",
                  "telemetry.sdk.name":"opentelemetry",
                  "telemetry.sdk.version":"0.24.0"
               }
            }
         },
         {
            "_index":"zipkin-span-2021-10-18",
            "_type":"_doc",
            "_id":"6c4bd64364ca942608948c00212c0c9a-10f1e84a8a8690dc2dff92bfe99fe85c",
            "_score":2.2735975,
            "_source":{
               "traceId":"6c4bd64364ca942608948c00212c0c9a",
               "duration":868,
               "localEndpoint":{
                  "serviceName":"unknown_service:node"
               },
               "timestamp_millis":1634536273453,
               "name":"middleware - use",
               "id":"d38ec1ec9a8e905e",
               "parentId":"562c1ea71b85c270",
               "timestamp":1634536273453532,
               "tags":{
                  "express.name":"use",
                  "express.type":"middleware",
                  "http.route":"/",
                  "ot.status_code":"UNSET",
                  "service.name":"unknown_service:node",
                  "telemetry.sdk.language":"nodejs",
                  "telemetry.sdk.name":"opentelemetry",
                  "telemetry.sdk.version":"0.24.0"
               }
            }
         }
      ]
   }
}

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.