Skip to main content
Solved

What is the best way to find the maximum value of an attribute given 3 other constraining attributes?

  • October 19, 2023
  • 1 reply
  • 22 views
daniel.m.getz
Contributor
Forum|alt.badge.img+4

I have data coming in from an instrument. It contains the readings for gasses like oxygen and H2S.

 

I am trying to create a report to highlight the highest value in a given hour on a given day. With the table below:

 

Instrument 1 | 10:00 AM | March 1st | Unit ABC 123 | H2S 10 ppm

Instrument 1 | 10:05 AM | March 1st | Unit ABC 123 | H2S 5 ppm

Instrument 1 | 10:10 AM | March 1st | Unit ABC 123 | H2S 0 ppm

...

Instrument 1 | 10:00 AM | March 2nd | Unit ABC 123 | H2S 10 ppm

Instrument 1 | 10:05 AM | March 2nd | Unit ABC 123 | H2S 15 ppm

...

 

I would want the report to show me the following,

Instrument 1 | 10:05 AM | March 2nd | Unit ABC 123 | H2S 15 ppm

Instrument 1 | 10:00 AM | March 1st | Unit ABC 123 | H2S 10 ppm

 

because those values are the highest gas reading for each hour, (10 AM as a record, 11 AM as another etc) on each unique day.

 

I have tried the statistics calculator, but it doesn't allow you to accumulate the other attributes, or allow you to find unique fields to 're-merge' the data together. I am suspect that it is returning the expected data.

 

Am I missing an obvious transformer to use here?

Best answer by geomancer

What a truly terrible format...

Anyhow, the Complete port from a StatisticsCalculator, followed by a TestFilter, should do the trick.

image

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.

1 reply

geomancer
Evangelist
Forum|alt.badge.img+60
  • geomancerEvangelist
  • Evangelist
  • Best Answer
  • October 19, 2023

What a truly terrible format...

Anyhow, the Complete port from a StatisticsCalculator, followed by a TestFilter, should do the trick.

image

Community Stats

32,154
Posts
122,047
Replies
39,812
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.