tell how many user visited different sites (transaction with one field same and one field _different_)

[a3p]

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.

[kristian_kolb]

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

[strive]

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.