Activity with in window of time

RADSr — Tue, 29 Nov 2022 13:22:33 GMT

If I have a site and I want to bucket visitors in to 'Super Active,' 'Active,' 'Kinda Active,' and 'Meh' based on a rolling n-day window of activity ( e.g. 30 visits is 'Super' 2 is 'Meh' )

That seems pretty straightforward for a given end date ( although I haven't done it yet ) but what if I want to do a timeline? On Jan 1 we had n-<level>, Jan 2 n-<level>, etc. so for each date I am looking back at the window and counting visitors?

Can I do that dynamically or do I need to loop through every date and put the results into a new table? If I do need to do that can I do it automatically and have it persist into the future?

Re: Activity with in window of time

Rasha — Thu, 01 Dec 2022 21:06:09 GMT

Hello RADSr,

Please check and confirm the below as per my understanding:

1-Assuming this is the main data set:

Date	No.Of vistors
1-Jan	2
2-Jan	3
3-Jan	5
4-Jan	10
5-Jan	12
6-Jan	6
7-Jan	4
8-Jan	7
9-Jan	8
10-Jan	9
11-Jan	1
12-Jan	3
13-Jan	0
14-Jan	4
15-Jan	2
16-Jan	6
17-Jan	8
18-Jan	3
19-Jan	1
20-Jan	15

2-After loading the Data into a new schema and new table (Attached)

3-From the Analyzer

Add a new result set
Add the previous 2 columns
Enable the running total option for the "No Of Vistors" measure
From the Analyzer go to the original insight and display the columns and the new Rating column using a case function as below:

case(

between(

ds_9k_3uh40w.insight.No_Of_vistors,

1,

5

),

'Meh',

between(

ds_9k_3uh40w.insight.No_Of_vistors,

6,

20

),

'Kinda Active',

between(

ds_9k_3uh40w.insight.No_Of_vistors,

21,

70

),

'Active',

between(

ds_9k_3uh40w.insight.No_Of_vistors,

70,

200

),

'Super Active',

''

)
It should be like that:
Attached here are the used data, Schema, and dashboard.

topic Activity with in window of time in Data & Schema Discussions

Activity with in window of time

Re: Activity with in window of time