Calculate % in TSVB

Elastic Stack Kibana
1

This is how my data which is compile over time.

every five min sample, one record is as below, I have hundreds of systems.

system name: sys1,
total cpus = integer
used cpus = integer
free cpus = integer

would like to get % free cpu per last sample
that should be ((sum of free cpus / sum of total cpus) *100)

I know it can only be achieved in tsvb
how do I get this ?

https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations

I have already check this link out. this is for total count of document from everything and it does work. I have used that on other use case.

but this example is not usable for me because I need sum of free cpus/sum of total capacity over 5m interval.

2

Anyone?

3

this is more detail. I am after creating gauge or metrix in %

I have a two type of record
rack1: cpu/gpu
each has capacity, free,used

{
rack1
cpu
@timestamp
capacity:100
free: 50
used: 50
}

{
rack2
cpu
@timestamp
capacity: 10
free: 9
used: 1
}

so in this two record I should see
free % = (50+1 / 110 ) * 100 = 46.36%

How do I do this tsvb?

4

giving bump to see anyone come acorss this problem

5

one last try. if anyone has done anything like this before