Skip to main content
Solved

Sorting a time series dataset by day

  • December 8, 2020
  • 2 replies
  • 27 views
J

Hello,

I have several year's worth of rain gauge data at 15 minute intervals. What I am trying to get out of it is sorting the dataset by days when it rained over, and under a certain value (that would be a sum total of rainfall in mm for each day).

Any suggestion on how to achieve this are muchly appreciated.

Cheers.

Best answer by ebygomm

If you use the datetimeconverter, to convert the datetime to just a date, statistics calculator with a group by of the date and sum the rainfall attribute, then a tester to see if the total is over or under your specified value

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    2 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+44
    • ebygommInfluencer
    • Influencer
    • 3427 replies
    • Best Answer
    • December 8, 2020

    If you use the datetimeconverter, to convert the datetime to just a date, statistics calculator with a group by of the date and sum the rainfall attribute, then a tester to see if the total is over or under your specified value

    J
    • jeremy_spoken
    • Author
    • 2 replies
    • December 8, 2020

    That's exactly what I needed. Thank you!

    Community Stats

    32,070
    Posts
    121,778
    Replies
    39,698
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.