Hello,
I have data set where order ID's get created for every purchase transaction, whenever there is a change in transaction same order id gets updated and forms a new row.
Now i wanted to distinct count how many orders i received per calendar day where the calendar dates sits out side of the data set.
Appreciate if you guys could help me with the solution. Many thanks.
<tbody>
</tbody>
I have data set where order ID's get created for every purchase transaction, whenever there is a change in transaction same order id gets updated and forms a new row.
Now i wanted to distinct count how many orders i received per calendar day where the calendar dates sits out side of the data set.
Appreciate if you guys could help me with the solution. Many thanks.
id | creation time | Calendar | ||||||
285 | 11/20/2018 | 11/20/2018 | Output | |||||
285 | 11/20/2018 | 11/21/2018 | Calendar date | Distinct ID's count | ||||
286 | 11/20/2018 | 11/22/2018 | 11/20/2018 | 10 | ||||
286 | 11/20/2018 | 11/23/2018 | 11/21/2018 | 2 | ||||
286 | 11/20/2018 | 11/24/2018 | ||||||
286 | 11/20/2018 | 11/25/2018 | ||||||
286 | 11/20/2018 | 11/26/2018 | ||||||
286 | 11/20/2018 | 11/27/2018 | ||||||
287 | 11/20/2018 | 11/28/2018 | ||||||
287 | 11/20/2018 | 11/29/2018 | ||||||
287 | 11/20/2018 | 11/30/2018 | ||||||
288 | 11/20/2018 | 12/1/2018 | ||||||
290 | 11/20/2018 | 12/2/2018 | ||||||
290 | 11/20/2018 | 12/3/2018 | ||||||
290 | 11/20/2018 | 12/4/2018 | ||||||
291 | 11/20/2018 | 12/5/2018 | ||||||
291 | 11/20/2018 | 12/6/2018 | ||||||
291 | 11/20/2018 | 12/7/2018 | ||||||
292 | 11/20/2018 | 12/8/2018 | ||||||
292 | 11/20/2018 | 12/9/2018 | ||||||
292 | 11/20/2018 | 12/10/2018 | ||||||
293 | 11/20/2018 | 12/11/2018 | ||||||
293 | 11/20/2018 | 12/12/2018 | ||||||
293 | 11/20/2018 | |||||||
293 | 11/20/2018 | |||||||
293 | 11/20/2018 | |||||||
294 | 11/20/2018 | |||||||
294 | 11/20/2018 | |||||||
294 | 11/20/2018 | |||||||
297 | 11/20/2018 | |||||||
297 | 11/20/2018 | |||||||
297 | 11/20/2018 | |||||||
297 | 11/20/2018 | |||||||
298 | 11/21/2018 | |||||||
298 | 11/21/2018 | |||||||
298 | 11/21/2018 | |||||||
299 | 11/21/2018 | |||||||
299 | 11/21/2018 | |||||||
299 | 11/21/2018 | |||||||
299 | 11/21/2018 |
<tbody>
</tbody>