Group BY Year Aggr Help

[Vittore8]

Hi,please tell me how to get this result

2015 3
2016 1
2017 3

and return 2016 because it occurs 1 time

[IamAlbinAntony]

Please use,

Front end script :

count(Year) or sum(value)  (b'cos in your case value is 1)

Back end:

Load Year, count(Year)

resident table

group by Year;

[AdiPai]

Try this 

LOAD * INLINE [
Year,Value
2015,1
2015,1
2015,1
2016,1
2017,1
2017,1
];

FirstSortedValue(Year,AGGR(Count(Value),Year))