Have you looked at the StatisticsCalculator?

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.

i need to filter like this in FME

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

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

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.

@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

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.