Question

need help using right transformer to filter

R
Badge

I have some data that need to be filter first and then calculate Values count of WO, Average of Age, and % of age.

1. I need to filter out work order that are CM, PM, CAP and MM. I have done that using Test Filter,

2. I need to then filter our CM's with HOLD status. I have column that is HOLD and has different status. I need to calculate CM's that are not on hold and CM's that are on hold.

3. Then I need to Count the work order, Average of age and % of AGE for all work types.

I am not sure what transformers i need to use the filter. I need your help.

10 replies

david_r
Rank
Userlevel 4

Have you looked at the StatisticsCalculator?

R
Badge

yes, I have looked at the statistics calculator and it will do the calculation part, I am stuck on second part of the filter. i can filter out CM,PM,CAP and MM categories but i don't know how to filter out HOLD status work order after or before the first filter.

R
Badge

i need to filter like this in FME

M
Badge +5

yes, I have looked at the statistics calculator and it will do the calculation part, I am stuck on second part of the filter. i can filter out CM,PM,CAP and MM categories but i don't know how to filter out HOLD status work order after or before the first filter.

Can you not add a second TestFilter to filter those features?

R
Badge

yes, I have looked at the statistics calculator and it will do the calculation part, I am stuck on second part of the filter. i can filter out CM,PM,CAP and MM categories but i don't know how to filter out HOLD status work order after or before the first filter.

@mark2catsafe i have tried adding 2nd test filter but it's not working to what i want

takashi
Rank
Userlevel 2
Badge +17

i need to filter like this in FME

Hi @ruby6, as @mark2catsafe suggested, the TestFilter can be used if you filters the features according to possible values (status) for the HOLD attribute. However you mentioned that it didn't work, so we need to understand exactly your desired filtering rules. Can you clarify how you want to filter the features in more detail? It's ideal if you would describe using some concrete examples.

R
Badge

Hi @ruby6, as @mark2catsafe suggested, the TestFilter can be used if you filters the features according to possible values (status) for the HOLD attribute. However you mentioned that it didn't work, so we need to understand exactly your desired filtering rules. Can you clarify how you want to filter the features in more detail? It's ideal if you would describe using some concrete examples.

fme-test-filter.pdf
takashi
Rank
Userlevel 2
Badge +17

i need to filter like this in FME

@ruby6, schema of the source table is still unclear, but maybe a StatisticsCalculater can do that, as David suggested at first. You can categorize the records with the 'Group By' parameter in the transformer.

R
Badge

@ruby6, schema of the source table is still unclear, but maybe a StatisticsCalculater can do that, as David suggested at first. You can categorize the records with the 'Group By' parameter in the transformer.

@takashi I was able to use Statistics calculator and it did do what i need to do but only think i can't figure out how to calculate the % of Total.

For example

375 42%

76 8%

144 16%

3 0%

274 30%

28 3%

Total 900 100%

Is there a way to calculate the % of the total in FME.

Thank you

takashi
Rank
Userlevel 2
Badge +17

@takashi I was able to use Statistics calculator and it did do what i need to do but only think i can't figure out how to calculate the % of Total.

For example

375 42%

76 8%

144 16%

3 0%

274 30%

28 3%

Total 900 100%

Is there a way to calculate the % of the total in FME.

Thank you

The StatisticsCalculator itself doesn't have the function to calculate percentage, but you can add another StatisticsCalculator to calculate the sum (grand total) for the summarized features, and then calculate the % (value / sum * 100) for each feature output from the Complete port. To calculate the %, consider using the ExpressionEvaluator or AttributeCreator.

Reply


Community Stats

28,714
Posts
109,490
Replies
36,561
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.