Question

Aggregate datetime in range

  • 4 December 2018
  • 4 replies
  • 7 views
D
Badge +5

Hi FME'ers,

 

I have a table containing weather forecast data every 3 hours over a 24 hour period. The time value is recorded in minutes past midnight, e.g. 180, 360, 540 etc. This table is updated at midnight and filtered to only records where the chance of precipitations is greater the 20%. I would like to aggregate these records where they occur consecutively with a start and end date

 

E.g. If rain is forecast for a continuous 9 hour then for 3 hours that would be aggregated into two record

Thanks,

4 replies

ebygomm
Rank
Userlevel 1
Badge +21

I would make use of the adjacent attribute feature in an attributecreator to create groupings, e.g. first value has group of zero, if the next attribute minute value is equal to the previous minute value plus 180 assign group zero, otherwise increment one to the group value. This grouping can then be used to aggregate

D
Badge +5

Hi @egomm. Thank you for responding so quickly. I have had a play with the adjacent feature function and it looks promising. How do I handle incrementing the group value? Can you provide an screenshot?

ebygomm
Rank
Userlevel 1
Badge +21

Hi @egomm. Thank you for responding so quickly. I have had a play with the adjacent feature function and it looks promising. How do I handle incrementing the group value? Can you provide an screenshot?

Not sure exactly what end result you are aiming for but this should give a demo of the adjacent feature function.

Incrementing is done with a conditional formula

rainfall.fmwt

D
Badge +5

Not sure exactly what end result you are aiming for but this should give a demo of the adjacent feature function.

Incrementing is done with a conditional formula

rainfall.fmwt

Work great! Thank you

Reply


Community Stats

28,692
Posts
109,433
Replies
36,544
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.