I'm collecting accounting data from our cloud platform (vmname, memory, cpu, owner, etc...)
Script is running every hour and posting document for every vm.
I would like to visualize usage of resources by every owner in time.
So I need first to aggregate by vmname and take average of cpu then take sum of those averages by time histogram and split it by owner.
Is it possible to make in kibana? What kind of visualisation should it take? I'm using 7.6.1