Forum Discussion
Identify unique/repeat website visitors in a given time frame
I have a similar request, where I need to run the same query to mark repeat/unique against a visitor, for the time period selected in the slicer. I have copy pasted the sample of the table here, could you please help me to run the query based on slicer value selected.
To be more precise, the dax I used is COUNTROWS((FILTER('public user_perday_0507',EARLIER('public user_perday_0507'[Visitor ID])='public user_perday_0507'[Visitor ID]) and populated column #3 "Dup Check". But I want this to apply as per the slicer value that is selected.
Slicer values:
Last 2 days
Last 7 days,
Last 14 days
Date Visitor ID day Dup Check Category
05-Jul-23 09bef63f-1b99-42b7-87af-61849133fdf0 1688529600000 1 Unique
05-Jul-23 22709ce7-4d20-4f10-8585-f5d75c30e046 1688529600000 1 Unique
05-Jul-23 2df6e0cf-c238-4572-9460-ee0ce6735e66 1688529600000 8 Repeat
05-Jul-23 37a97a2d-af47-49a8-b25a-cef331112de1 1688529600000 2 Repeat
05-Jul-23 48ad22e4-9b95-48b4-bbb9-a5a4fd1050aa 1688529600000 1 Unique
05-Jul-23 64772fb4-151a-4477-8139-a57aef30f724 1688529600000 2 Repeat
05-Jul-23 6b73abd4-059b-47a4-8aa8-98be2fd3861a 1688529600000 1 Unique
05-Jul-23 72b60ab6-4d20-4414-89df-8b39580436ce 1688529600000 1 Unique
05-Jul-23 767361fa-186b-42d5-91c8-1fa327cdb0ac 1688529600000 1 Unique
05-Jul-23 7e64255d-80ff-4fa4-b366-84e80f386433 1688529600000 10 Repeat
05-Jul-23 90aa12c6-cd69-4eb2-9339-653f529fb0d7 1688529600000 2 Repeat
05-Jul-23 9f097fac-9500-488c-96dc-a21b27b7722a 1688529600000 1 Unique
05-Jul-23 a4fc155a-7bd0-4034-a20d-b19413e5ce01 1688529600000 1 Unique
05-Jul-23 ae0081ca-9957-42ac-b6ea-67484924bdb6 1688529600000 1 Unique
05-Jul-23 e14e7827-d726-491b-bf27-808433aa10d9 1688529600000 1 Unique
05-Jul-23 eda95143-4e5a-4a8e-9abb-427804b57f1a 1688529600000 1 Unique
04-Jul-23 21fc64d2-3549-40a1-b731-e5a06cafd322 1688443200000 1 Unique
04-Jul-23 2df6e0cf-c238-4572-9460-ee0ce6735e66 1688443200000 8 Repeat
04-Jul-23 4ca8405c-5a1b-4a20-8bac-37447fa1d771 1688443200000 1 Unique
04-Jul-23 5500b7b2-b427-4721-9fae-a60764f04687 1688443200000 1 Unique
04-Jul-23 64772fb4-151a-4477-8139-a57aef30f724 1688443200000 2 Repeat
04-Jul-23 7e64255d-80ff-4fa4-b366-84e80f386433 1688443200000 10 Repeat
04-Jul-23 a9c7ab83-632f-4271-9029-98ff8dd78954 1688443200000 1 Unique
04-Jul-23 c15e4f44-4457-41a8-a788-993290b8c485 1688443200000 1 Unique
04-Jul-23 dbeb998c-6e36-4094-9ff8-a5ba2ca67307 1688443200000 4 Repeat
03-Jul-23 143925eb-135c-4ddf-976d-780cc43ea257 1688356800000 2 Repeat
03-Jul-23 2df6e0cf-c238-4572-9460-ee0ce6735e66 1688356800000 8 Repeat
03-Jul-23 61c38028-e89f-41e4-8f22-87703d03d760 1688356800000 1 Unique
03-Jul-23 67bd2954-74ff-479d-85a3-bea4be79f143 1688356800000 5 Repeat
03-Jul-23 ab0270a7-769c-41a9-8a07-39cdf484efd4 1688356800000 1 Unique
03-Jul-23 b4c9be76-aa04-4054-ab1f-89121a2f944e 1688356800000 1 Unique
03-Jul-23 dbc19211-8a73-48ac-af36-ac248fa9367f 1688356800000 1 Unique
03-Jul-23 fe4f260e-48f7-4a29-ab4f-0c94beadfd67 1688356800000 1 Unique
02-Jul-23 2df6e0cf-c238-4572-9460-ee0ce6735e66 1688270400000 8 Repeat
02-Jul-23 a77ab287-1893-42fd-b110-93b087ae1291 1688270400000 2 Repeat
02-Jul-23 c1b28dda-96e3-4816-a94d-61adc25ab0f8 1688270400000 1 Unique
30-Jun-23 2df6e0cf-c238-4572-9460-ee0ce6735e66 1688097600000 8 Repeat
30-Jun-23 37a97a2d-af47-49a8-b25a-cef331112de1 1688097600000 2 Repeat
30-Jun-23 4fdb54ab-1fda-4487-baa5-38fe7410ff9a 1688097600000 1 Unique
30-Jun-23 67bd2954-74ff-479d-85a3-bea4be79f143 1688097600000 5 Repeat
30-Jun-23 7b191003-bcab-47d5-bdc5-16095e29d045 1688097600000 1 Unique
30-Jun-23 8c2197c4-87d0-4cf3-b149-dcbc306da3e6 1688097600000 1 Unique
30-Jun-23 a870229d-8b96-4aec-8aaf-cc0af200ed08 1688097600000 5 Repeat
30-Jun-23 b0b4cb92-a669-4f54-b3ad-4980c8b8b7ca 1688097600000 2 Repeat
30-Jun-23 b3a687d5-814e-45fc-80d9-32b0d31da4aa 1688097600000 1 Unique
29-Jun-23 01d40ef5-dc5c-4317-96ec-c10c0842cc9d 1688011200000 1 Unique
29-Jun-23 1089ba2f-3ffd-47a7-a725-98ccc155b4b7 1688011200000 1 Unique
29-Jun-23 2500c104-81fd-4a24-9a12-8a6302d2ff4a 1688011200000 1 Unique
29-Jun-23 2df6e0cf-c238-4572-9460-ee0ce6735e66 1688011200000 8 Repeat
29-Jun-23 3f066d6d-df5b-4416-ad17-cd5bc48458f2 1688011200000 1 Unique
29-Jun-23 5d3fd9a1-46d9-4040-9f3e-d29d475659d9 1688011200000 1 Unique
29-Jun-23 6753cfd0-96cd-45a1-a954-36b58945fce4 1688011200000 1 Unique
29-Jun-23 80f8dc0d-5353-488a-a6d0-2c3aeba290b2 1688011200000 15 Repeat
29-Jun-23 a77ab287-1893-42fd-b110-93b087ae1291 1688011200000 2 Repeat
29-Jun-23 c4d6338c-1084-470e-9518-48eabf38e6c2 1688011200000 2 Repeat
29-Jun-23 cc75f9c7-c0fb-49d2-ba90-50cdf84bdb02 1688011200000 1 Unique
29-Jun-23 d391b7b9-df6f-4557-a5cf-c79ecf8e7d90 1688011200000 1 Unique
29-Jun-23 ed6c8912-b607-4d73-9abe-23247c1d3948 1688011200000 1 Unique
28-Jun-23 1693fdea-71e2-450f-a0e2-9be30910b3b3 1687924800000 1 Unique
28-Jun-23 1b8f9cc5-79e2-4e67-a026-178eaca48899 1687924800000 1 Unique
28-Jun-23 30320e92-6fd2-4413-9481-1720b7680353 1687924800000 1 Unique
28-Jun-23 30ce49b1-c39c-4ce4-ad2d-527f3d0738c8 1687924800000 1 Unique
28-Jun-23 3153b584-d8f1-4918-beae-8acd8377d763 1687924800000 1 Unique
28-Jun-23 331cca8c-ff6e-4e13-a3ab-423cdcd8b5cd 1687924800000 1 Unique
28-Jun-23 4ebbbcdb-8f8d-45dd-aa36-e453157a5dc2 1687924800000 1 Unique
28-Jun-23 53504885-9fe7-48ae-93a0-5edffed8ef03 1687924800000 1 Unique
28-Jun-23 5bb67840-12d8-4297-a4a7-3a93726c1788 1687924800000 1 Unique
28-Jun-23 67bd2954-74ff-479d-85a3-bea4be79f143 1687924800000 5 Repeat
28-Jun-23 69866b6e-c6b4-49c4-ae3a-b6bdebd09239 1687924800000 1 Unique
Your help in this regard is much appreciated and will be highly helpful.
Thank you in advance!
Swetha