Split Series by Array Values (instead of whole Array)

Elastic Stack Kibana
1

Guess I have timeseries data roughly like this (four examples):

timestamp: 1
systems: [A, C]
value: 10

timestamp: 1
systems: [A, B]
value: 9

timestamp: 2
systems: [A]
value: 12

timestamp: 2
systems: [B, C]
value: 15

Now I want to use Kibana to plot a graph, which shows the average by bucket and is splitted by each single value of systems. But when I try to split a series by "Terms" on the field "systems", it will plot four series. One for each array:

  • [A,C]
  • [A,B]
  • [A]
  • [B,C]

But I want just three series, one for each "system":

  • A
  • B
  • C

Is that possible with Kibana?

2

The desired behavior you describe should be how Kibana works by default. It sounds to me like the systems field may not contain actual arrays, but instead literal strings like "[A, B]"

3

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