Splunk Search

## Dew Point Calculation

Explorer

I am trying to produce or calculate the Dew Point in Celsius of data in two separate indexes.

I believe the offcial Dew point formula is Td = T - ((100 - RH)/5.)

I want to basically use this formula to produce Dew point using relative humidity on one index with temperature on another index

Tags (2)
1 Solution
Ultra Champion

Assuming that the measurement times at the two indexes are the same,

index=relative_humidity_index OR index=temperature_index
|stats avg(relative_humidity) as relative_humidity avg(temperature) as temperature by _time
|eval dew_point=temprature-((100-relative_humidity)/5.0)
Ultra Champion

Assuming that the measurement times at the two indexes are the same,

index=relative_humidity_index OR index=temperature_index
|stats avg(relative_humidity) as relative_humidity avg(temperature) as temperature by _time
|eval dew_point=temprature-((100-relative_humidity)/5.0)
Explorer

That nearly worked. Thanks 🙂

(index="index1" device=* customer_id=*) OR (index="weather") | stats avg(hum) as relative_humidity avg(temp) as temperature by customer_id | eval dew_point=temperature-((100-relative_humidity)/5.0)

However something which ive noticed which could be any issue is that the both indexes have a temperature but on one index its temperature(weather index) and on the other its temp(index 1). When i change it to temperature it doesnt seem to produce/include the values from the "weather" index.

I basically want the temperature from the weather index vs humidity of the index1

SplunkTrust

Easily handled.

(index="index1" device= customer_id=) OR (index="weather")
| eval temperature=coalesce(temperature, temp)
| stats avg(hum) as relative_humidity avg(temp) as temperature by customer_id
| eval dew_point=temperature-((100-relative_humidity)/5.0)
---
If this reply helps you, Karma would be appreciated.
Explorer

richgalloway that seems to have done the job 🙂 Thanks very much.

Get Updates on the Splunk Community!

#### Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

#### Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

#### Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...