count orders by customer in a day based on time interval

[abhishekc]

Hi all,

need help with the following :

treat orders by same clientid in a 10 minute interval as one order

Order_id	Client_id	DOOR	Tray	Date
OD0001	CL0001	A	A1	02/10/2019, 11:10:10
OD0002	CL0002	B	B3	02/10/2019, 11:13:41
OD0002	CL0002	B	B7	02/10/2019, 11:13:41
OD0003	CL0002	A	A4	02/10/2019, 11:17:34
OD0004	CLOOO3	B	B3	02/10/2019, 12:38:34
OD0005	CL0004	C	C1	02/10/2019, 13:21:34
OD0006	CL0002	B	B7	02/10/2019, 13:23:41
expected output
number of orders	number of clients
5	4
since, we are counting all orders made by a customer within a ten minute interval as one order, therefore , OD0001 AND OD0003 ARE COUNTED AS ONE ORDER

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.