Calculating time spent in state with Metricbeat and Kibana

[m_x]

Hi,

I would like to calculate the time spent in a certain state with Metricbeat and Kibana . For example : how long have the system been up during specified period ? how long have a user spent logged in ?. I'm discovering Kibana and I can't find a way to do this.

I can plot a metric over time but I find that "time spent in state" gives more insight.

As a workaround, I can plot the number of record over states in a histogram. Assuming the period between two record is constant (normally the case with metricbeat), the number of records is a proxy to "time spent".

My use case is gathering usage statistics on endpoint computers.

Thanks

[wylie (Wylie Conlon)]

This is one of the main reasons to use the transforms feature: your data needs to be pivoted before analysis.