Page tree
Skip to end of metadata
Go to start of metadata

Syntax

GROUP_PATH_CHANGES(<any>)

Description

Create paths from a field, but only if the value changes. This function can be used for click stream analysis.

This is a group series function.

Example

Analyze click streams, group on a session, sort by timestamp, and generate the clicks paths.

Given the following data:

session
timestamp
url
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).

sessionsAscending_TimeStamp
session12
session13
session14
session17
session19
session25
session26
session28
session210

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

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

Also see:

  • GROUP_PATH To not filter out paths where the URL doesn't change.
  • GROUPBYGAP To extract sessions from gaps in a timestamp.
  • No labels