I thought about creating sepeate indexes for my data though there is some other data that i didn't show something like:
Timestamp: 01/17/2018 12:00:100:
TESTINDEX having one doc per sesssion:
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.