Hi all,
I have the data in a table similar to that:
I have been asked to create something like the table below:
Basically, I am grouping by Site, Name, Feature, Subfeature, then counting Y or N for each group, concatenating the years and summing the count.
Does anyone know how to do this? By only using the aggregator I get something like that but it is not exactly but I need:
Any ideas how can I get Count_Dead_N and Count_Dead_Y.
Thanks!
Best answer by takashi
I think you have almost accomplished the goal by using the Aggregtor.
Regarding the DEAD field, consider creating two attributes "COUNT_DEAD_Y" and "COUNT_DEAD_N" BEFORE aggregating:
- set 1 to COUNT_DEAD_Y if the DEAD is Y, set 0 otherwise.
- set 1 to COUNT_DEAD_N if the DEAD is N, set 0 otherwise.
You can then sum the values of the attributes with the Aggregator.
Takashi
Have a look at the StatisticsCalculator. You probably want to set the Group By on SITE, NAME, FEATURE and SUBFEATURE.
David
?
I think you have almost accomplished the goal by using the Aggregtor.
Regarding the DEAD field, consider creating two attributes "COUNT_DEAD_Y" and "COUNT_DEAD_N" BEFORE aggregating:
- set 1 to COUNT_DEAD_Y if the DEAD is Y, set 0 otherwise.
- set 1 to COUNT_DEAD_N if the DEAD is N, set 0 otherwise.
You can then sum the values of the attributes with the Aggregator.
Takashi
You idea of craeating two attributes worked really well and I have achieved what I wanted to.
Thanks for that! :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
