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:

sessiontimestampurl
session12url1
session13url1
session14url2
session25url1
session26url2
session17url3
session28url1
session19url2
session210url1

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

session
session1
session2

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

sessiontimestamp
session12
session13
session14
session17
session19
session25
session26
session28
session210

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.

sessiontimestampurl_Path
session12["external","url1"]
session13["url1","url1"]
session14["url1","url2"]
session17["url2","url3"]
session19["url3","url2"]
session19["url2","external"]
session25["external","url1"]
session26["url1","url2"]
session28["url2","url1"]
session210["url1","url1"]
session210["url1","external"]

Also see: