Kibana graphing average of nested data


(David Tomasheski) #1

So i have timestamped data coming in with some nested data attached to it. which looks like this:

sessionID: 1
timestamp 01/17/2018 12:00:00
tests(nested data type):
{
testid: 1
result: 75
}
{
testId: 2
result: 88
}

What i need is a graph of the average of result. Is this possible.


(David Tomasheski) #2

I thought about creating sepeate indexes for my data though there is some other data that i didn't show something like:

SesionINDEX:
SessionID: 1
Timestamp: 01/17/2018 12:00:100:
system: system1

TESTINDEX having one doc per sesssion:
SessionId:1
TestId: 1
result: 75

I was hoping to then do a visualization based on the timestamp in SESSIONINDEX and tying the sessionIds together to graph avg result

My other thought was to have one index listing per session and just listing all the data for the session each doc. This would solve my issue of getting the avg of result. but then would screw up things like count of sessions per system. Though it may make it easier to get things like avg result based on system.


(system) #3

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