topic Re: Need to create a count variable according to the different fields and that count value should increa in Archived Groups

Need to create a count variable according to the different fields and that count value should increa

Shinooj_M — Tue, 22 Jul 2025 14:29:37 GMT

Hi All,

I have some sample data here.

I WANT TO CREATE A INCREMENT COUNT VARIABLE .

USER RAM VISITS ABC CATEGORY AND XYZ SUB CATEGORY , SO COUNT VARIABLE IS 1

AND NEXT TIME IF THE SAME USER VISITS THE SAME CATEGORY AND SUBCATEGORY THE COUNT VARIABLE SHOULD INCREASE TO 2 AND SO AND SO. CAN ANYONE HELP ME TO GET THAT DONE .

NOTE : THE USERS ARE NOT STATIC , THE USERS WILL BE CHANGE EVERYDAY .

User ID	Category	Sub Category	Updated	CREATED
RAM	ABC	XYZ	2020-10-28 12:31:18	2020-09-28 10:31:18
RAM	ABC	XYZ	2020-10-29 10:40:32	2020-10-29 9:20:32
RAM	ABC	LMN	2020-11-02 18:02:00	2020-10-02 12:52:00
ADAM	ABC	XYZ	2020-10-30 08:56:05	2020-08-30 18:56:05
ADAM	ABC	LMN	2020-11-02 12:00:56	2020-11-02 12:00:56

Thankfully,

Shinooj

Re: Need to create a count variable according to the different fields and that count value should in

Taoufiq_Zarra — Wed, 04 Nov 2020 13:37:54 GMT

@Shinooj_M can you share the expected output from this sample ?

Re: Need to create a count variable according to the different fields and that count value should in

Shinooj_M — Thu, 05 Nov 2020 05:52:47 GMT

Please find the expected output below .

want to create a counter variable which gives how many times the user visits the same category an subcategory .

User RAM Visits Category EDF and Subcategory LMN is 1 time.
User RAM Visits Category ABC and Subcategory PQR is 2 times
User ADAM Visits Category ABC and Subcategory XYZ is 3 time's.
User ADAM Visits Category EDF and Subcategory LMN is 2 time.
User RAM Visits Category ABC and Subcategory XYZ is 2 times.

Please find the sample data below

Re: Need to create a count variable according to the different fields and that count value should increa

Shinooj_M — Tue, 10 Nov 2020 09:29:10 GMT

Any Update . Is this possible..Please respond

Re: Need to create a count variable according to the different fields and that count value should increa

kfoudhaily — Wed, 07 Dec 2022 08:53:52 GMT

hello,

load

User,
[ID Category],
[Sub Category],
Updated,
CREATED,
autonumber (User&[ID Category]&[Sub Category]) as [you var]
from ...

please don't forget to mark accepted if response is ok for you.

regards,