Forum Discussion
Solved
Count Overlap by Date
Hello! I have a list of Customer IDs, Dates, City, and State. I am trying to figure out how to show all the customers that have attended the first show date, the second show date, and then both d...
Yep! Here is the data pasted. And below is my expected output with dummy data. I don't have it based on the current data I have because I can't get there yet.
| Cust ID | Date | City | State |
| 100000000000192 | 3/30/2019 | New Orleans | LA |
| 100000000000192 | 3/30/2019 | New Orleans | LA |
| 100000000000912 | 3/30/2019 | New Orleans | LA |
| 100000000002976 | 3/30/2019 | New Orleans | LA |
| 100000000002976 | 3/30/2019 | New Orleans | LA |
| 100000000002976 | 3/30/2019 | New Orleans | LA |
| 100000000042960 | 3/30/2019 | New Orleans | LA |
| 100000000050352 | 3/30/2019 | New Orleans | LA |
| 100000000050352 | 3/30/2019 | New Orleans | LA |
| 100000000050352 | 3/30/2019 | New Orleans | LA |
| 100000000061920 | 3/30/2019 | New Orleans | LA |
| 100000000093120 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000096768 | 3/30/2019 | New Orleans | LA |
| 100000000229680 | 3/30/2019 | New Orleans | LA |
| 100000000229680 | 3/30/2019 | New Orleans | LA |
| 100000000229680 | 3/30/2019 | New Orleans | LA |
| 100000000297600 | 3/30/2019 | New Orleans | LA |
| 100000000297600 | 3/30/2019 | New Orleans | LA |
| 100000000386544 | 3/30/2019 | New Orleans | LA |
| 100000000397440 | 3/30/2019 | New Orleans | LA |
| 100000000397440 | 3/30/2019 | New Orleans | LA |
| 100000000448464 | 3/30/2019 | New Orleans | LA |
| 100000000476544 | 3/30/2019 | New Orleans | LA |
| 100000000494928 | 3/30/2019 | New Orleans | LA |
| 100000000589488 | 7/31/2021 | New Orleans | LA |
| 100000000665280 | 3/30/2019 | New Orleans | LA |
| 100000000665280 | 3/30/2019 | New Orleans | LA |
| 100000000684864 | 7/31/2021 | New Orleans | LA |
| 100000000703728 | 3/30/2019 | New Orleans | LA |
| 100000000703728 | 3/30/2019 | New Orleans | LA |
| 100000000994512 | 3/30/2019 | New Orleans | LA |
| 100000001023264 | 3/30/2019 | New Orleans | LA |
| 100000001023264 | 3/30/2019 | New Orleans | LA |
| 100000001023264 | 3/30/2019 | New Orleans | LA |
| 100000001023264 | 3/30/2019 | New Orleans | LA |
| 100000001056240 | 7/31/2021 | New Orleans | LA |
| 100000001289280 | 7/31/2021 | New Orleans | LA |
| 100000001418016 | 7/31/2021 | New Orleans | LA |
| 100000001434528 | 3/30/2019 | New Orleans | LA |
| 100000001434528 | 3/30/2019 | New Orleans | LA |
| 100000001434528 | 3/30/2019 | New Orleans | LA |
| 100000001674432 | 3/30/2019 | New Orleans | LA |
| 100000001674432 | 3/30/2019 | New Orleans | LA |
| 100000001674432 | 3/30/2019 | New Orleans | LA |
| 100000001997904 | 3/30/2019 | New Orleans | LA |
| 100000001997904 | 3/30/2019 | New Orleans | LA |
| 100000001997904 | 7/31/2021 | New Orleans | LA |
| 100000001998816 | 3/30/2019 | New Orleans | LA |
| 100000002059824 | 7/31/2021 | New Orleans | LA |
| 100000002059824 | 7/31/2021 | New Orleans | LA |
| 100000002101008 | 3/30/2019 | New Orleans | LA |
| 100000002132208 | 3/30/2019 | New Orleans | LA |
| 100000002155200 | 3/30/2019 | New Orleans | LA |