Calculate elapsed time

1

I am using elastic as datasource and having start date coming from one query. I have end date coming from another query. I want to calculate the difference between the 2 dates.

The difference should be reflected in hours.

image
image1448×705 36.5 KB

I see following metrics options

image
image928×472 21.6 KB

Can it be resolved using Mixed DataSource?

2

Did you look at the Time Range documentation.

3

I have the same question, for example if I have a swich which is on and off. I would like to know how much time was on for s specific time. How can I query that ?