duplicates using a transaction date

User_DARJB

Hi all; so I am having a somewhat similar issue to my last question. Let me give you the objective; I would like to create an attribute column that highlights when an individual (ID #) creates transactions in multiple stores in a single day.

In my data, I am given the ID #, two transaction date columns, a store # column. What I would like to produce is a column on the far right hand side (Please see example below) that reads out whether or not an individual has frequented two or more DISTINCT stores within a day, the column is called "Store count per day"..

If you see the example below; it shows that if an individual frequented three DISTINCT stores in a day, then they are labeled as "suspicious -3 or more' in the "Same count per day" column which is the one I am trying to create. If they have only been to one store location in a single day, regardless of how many times they went there, then they are labeled as "not suspicious".

So far, this has been the query I have been able to come up with where it satisfies some, but not all for the transactions in my data:

Please let me know how using the given data below, you would create the "Store count per day" column on the right hand side. I greatly appreciate any and all feedback. Thank you all!