Dynamic Nested Key Value List Aggregation

[alparslan]

Hi,

I have "inputParams" object with dynamic key value pair with the following structure.

My purpose is visualizing the "inputParams" field according to key.
Keys are not known. It can be change according to process.

What is the best approach to visualize these data.

{
"action": "FINISHED",
"startedDate": "2021-02-08T12:36:04.008+01:00",
"endedDate": "2021-02-08T12:36:21.873+01:00",
"durationAsMinutes" : 12,
"inputParams" : [
  {
    "key" : "addresstype",
    "value" : "home"
  },
  {
    "key" : "city",
    "value" : "berlin"
  },
  {
    "key" : "primary",
    "value" : "true"
  }
] }

{
"action": "FINISHED",
"startedDate": "2021-02-08T12:36:04.008+01:00",
"endedDate": "2021-02-08T12:36:21.873+01:00",
"durationAsMinutes" : 16,
"inputParams" : [
  {
    "key" : "addresstype",
    "value" : "home"
  },
  {
    "key" : "city",
    "value" : "hamburg"
  },
  {
    "key" : "primary",
    "value" : "false"
  }
] }

{
"action": "FINISHED",
"startedDate": "2021-02-08T13:36:04.008+01:00",
"endedDate": "2021-02-08T13:36:21.873+01:00",
"durationAsMinutes" : 5,
"inputParams" : [
  {
    "key" : "creditscore",
    "value" : "1300"
  }
] }

{
"action": "FINISHED",
"startedDate": "2021-02-08T13:36:04.008+01:00",
"endedDate": "2021-02-08T13:36:21.873+01:00",
"durationAsMinutes": 5,
"inputParams": [
    {
        "key": "creditscore",
        "value": "1200"
    }
]

}

{
"action": "FINISHED",
"startedDate": "2021-02-08T13:36:04.008+01:00",
"endedDate": "2021-02-08T13:36:21.873+01:00",
"durationAsMinutes" : 5,
"inputParams" : [
  {
    "key" : "filename",
    "value" : "sample.xls"
  },
  {
    "key" : "filepath",
    "value" : "/home/comp/dev"
  }

] }

[matw (Matthias Wilhelm)]

Hi

I'm not sure what you want to visualize, what kind of answer should the visualization you intend to create give? do you want to visualize e.g. the distribution of input values with type city? Could you share the mapping of your data?

Thx and best,
Matthias

[alparslan]

Hmm for example following table (data table in kibana) fits to me.

I want to show total count of value by key.

Thanks..