GROUP_PATH

GROUP_PATH

Syntax

GROUP_PATH(<any>)

Description

Displays the path from one point to another for all values in a group. This can be used for click stream analysis.

This is a group series function.

Example

This example is a simple click stream analysis that displays the path during specified sessions.

Given the following data:

session

timestamp

url

session

timestamp

url

session1

2

url1

session1

3

url1

session1

4

url2

session2

5

url1

session2

6

url2

session1

7

url3

session2

8

url1

session1

9

url2

session2

10

url1

First create a group using GROUPBY(#RawData!session).

session

session

session1

session2

Next sort your timestamp in ascending order using GROUP_SORT_ASC(#RawData!timestamp).

session

timestamp

session

timestamp

session1

2

session1

3

session1

4

session1

7

session1

9

session2

5

session2

6

session2

8

session2

10

Then use the GROUP_PATH(#RawData!url). The result shows paths for all values of the column in ascending order in relation to the GROUPBY() column.

session

timestamp

url_Path

session

timestamp

url_Path

session1

2

["external","url1"]

session1

3

["url1","url1"]

session1

4

["url1","url2"]

session1

7

["url2","url3"]

session1

9

["url3","url2"]

session1

9

["url2","external"]

session2

5

["external","url1"]

session2

6

["url1","url2"]

session2

8

["url2","url1"]

session2

10

["url1","url1"]

session2

10

["url1","external"]

Also see: