having a field user_id='1234' and page_id='yellow books' or page_id='green books', i can easily do a search
search | transition user_id
but this also returns users who only visited one of the pages multiple times.
what i need is to track users through different sites and count how many pages they have visited in average. preferable without being limited to a maximum time between events. i.e. over the entire dataset.
It looks like this could be done with stats
:
your_search | stats dc(page_id) AS distinct_pages c as visits values(page_id) as pages by user_id | where distinct_pages >1
/K
You need total number of unique pages visited by each user OR Average number of visits per user per day.
Can you post some sample log lines.