topic Re: Calculate orders in a year groupby costumer in App Development

Calculate orders in a year groupby costumer

ecabanas — Thu, 16 May 2019 13:38:34 GMT

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

Re: Calculate orders in a year groupby costumer

Lisa_P — Fri, 17 May 2019 00:20:54 GMT

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.