My indices have this records:
Name Type IO bay01 diskA 0 bay01 diskA 20 bay01 diskB 0 bay01 diskB 40 bay03 diskC 0 bay03 diskC 10 bay03 diskD 30 bay03 diskD 60
A. I need to graph an average on the IO value group by Type,Name:
Name Type Average IO bay01 diskA 10 bay01 diskB 20 bay02 diskC 5 bay02 diskD 45
I don't have problem to graph this value;
B. Then I need a second graph sum of IO group by Name
But, this sum must use the average of the precedent graph.
I need to have this value:
Name Sum IO based on Average Io bay01 30 bay02 50
So in conclusion in this graph I need the sum of IO based on item average.
I don't find in Kibana how I can do that.
The uniq possibility that i find is to do sum. But it show this result and not that I want.
Name Sum IO bay01 100 bay02 80