Hi, this is a really basic question, but none of the other answers I've read have quite fit. What I want to do is simple - find the percentages of these two values:
The answer would be NoBlank - 78.22% , BothBlank - 21.78%
I'm aware the trick is to find a way to sum the Individual ID.total_count column in the Expression Evaluator, but "@sum@value(individual ID.total_count)' doesn't work, only returning the original values.
This so frustrating because I'm sure it's very simple.
You could put a counter starting at 1 before the StatisticCalculator, add _count value to your statistics calculations for max, and then math it with the expression evaluator. It will append the 202 (or whatever the count is) to every record.
Theres a few ways you could do it... here is one (FME 2020.1)
Theres a few ways you could do it... here is one (FME 2020.1)
This worked a charm, thanks!
You could put a counter starting at 1 before the StatisticCalculator, add _count value to your statistics calculations for max, and then math it with the expression evaluator. It will append the 202 (or whatever the count is) to every record.
I found this almost worked, but the final number for the BothBlank row was 198 (I assume because 198th row was the final BothBlank row). No worries though, the answer below worked fine for me. Thanks a lot for taking the time to help anyways!