Hello, I have these dataArea Category Date A Medium 202301 A High 202305 B Medium High 202306 B Medium High 202305 B Medium High 202304 B Medium High 202303 B Medium High 202302 B Medium High 202301 C Low 202306 C Low 202305 C Medium 202304 C Low 202303 D High 202306 D Low 202305 D Low 202304 D Low 202303 E High 202306 E High 202305 E High 202304 E Medium High 202303 E Medium High 202302 E Medium High 202301 I want to count the categories that occurred 3 or more times consecutively per area. So something like these Area Category Count Same category consecutively >3 A 0 B Medium High 6 C 0 D Low 3 E High 3 E Medium High 3 I am not sure how to do it in FME. Thank you!

Solved

Count if event happened consecutively based on other variable.

Forum|Forum|1 year ago
April 23, 2024
9 replies
79 views

alejacd
Contributor

Hello,

I have these data

Area	Category	Date
A	Medium	202301
A	High	202305
B	Medium High	202306
B	Medium High	202305
B	Medium High	202304
B	Medium High	202303
B	Medium High	202302
B	Medium High	202301
C	Low	202306
C	Low	202305
C	Medium	202304
C	Low	202303
D	High	202306
D	Low	202305
D	Low	202304
D	Low	202303
E	High	202306
E	High	202305
E	High	202304
E	Medium High	202303
E	Medium High	202302
E	Medium High	202301

I want to count the categories that occurred 3 or more times consecutively per area.

So something like these

Area	Category	Count Same category consecutively >3
A		0
B	Medium High	6
C		0
D	Low	3
E	High	3
E	Medium High	3

I am not sure how to do it in FME.

Thank you!

Best answer by geomancer

Something like this?

First the workspace adds all missing Area + Date combinations.

Then the consecutive occurences are counted. The AttributeManager uses Adjacent Feature Attributes, the Statistics Calculator gets the maximum values.

Some areas are missing from the results, so they are added in the last step.

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.

+60

geomancer
Evangelist
Forum|Forum|1 year ago
April 23, 2024

Additional test data:

Area	Category	Date
F	Medium High	202306
F	Medium High	202305
F	Medium High	202302
F	Medium High	202301

Rows 202303 and 202304 are missing, so would this be considered as 3 or more times consecutive occurences?

Upvote

alejacd
Author
Contributor
Forum|Forum|1 year ago
April 23, 2024

If the date is not present, it means that no data was registered. So it won’t be considered as consecutive.

Upvote

+60

geomancer
Evangelist
Forum|Forum|1 year ago
April 23, 2024

Thanks for your reply. I suspected as much, but there was no example data for this situation.

I'll take a look.

Upvote

+60

geomancer
Evangelist
Best Answer
Forum|Forum|1 year ago
April 23, 2024

Something like this?

First the workspace adds all missing Area + Date combinations.

Then the consecutive occurences are counted. The AttributeManager uses Adjacent Feature Attributes, the Statistics Calculator gets the maximum values.

Some areas are missing from the results, so they are added in the last step.