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.