Calculate orders in a year groupby costumer

[ecabanas]

Hi,

I would like to do that in the load script to create a table with the customer and the number of orders in a year

something like this,

But I do not have any idea how to do that

Any advice or literature to investigate?

thanks

[Lisa_P]

You need to define the Year field, then you can use the Group by function in the load script to aggregate the orders by year.

eg.
Orders:
Load Customer,
'Order ID',
Date,
Year(Date) as Year
From .....

Load 'Order Id',
Count('Order Id') as YearlyOrders
Resident Orders
Group by Year;
This will allow you to create a table showing as per above in your app.