Data aggregation

[Anonymous]

Hi guys,

I have a list of records related to employees where I have the admission date (DD-MM-YYYY). I need to create a report where I can summarise the number of employees that I have in the company with more than 4 years, the ones that I have between 2 and 4 years and also the ones that I have until two years. What is the best option to do this?

[dwforest]

I'd construct a table to define the brackets

You could script as:

LOAD

[YOS Bracket], YOS;

LOAD

[YOS Bracket],

Start+IterNo() as YOS,

Start,

End;

LOAD * INLINE  [

[YOS Bracket], Start, End

'0-2',0,2

'2-4',3,4

'5+',5,99

;

Then for each employee calcuate a YOS field.