Member Avatar for Techsavy
Techsavy 0 Newbie Poster

Hello,

I am trying to analyze 56 years of hourly rainfall data.

Right now i have three columns. Date(mm/dd/yyyy), hr(0-23) and hourly Rainfall(inches).

I would like to know the count of rainfall events that exceed 2.4 inches in 24 hrs. Meaning if the sum of Rainfall exceeds 2.4 inches in 24 hours then that is one event.

once an event is identified the next event should be identified with a gap of 72 hours.

Any suggestions on how to query this?

Thanks,

  • 1 Contributor
  • 0 Replies
  • 73 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.