Home

Remove Duplicate Events in Group

Highlighted
Greg Berns
New Contributor

Remove Duplicate Events in Group

Goal: Query AppInsights data for the pages a user has viewed over the course of their session.

The problem is that there are duplicate page views, each with the same timestamp. In the query below, I `sort by session_Id, timestamp` and that data shows a ton of duplicate urls in each session. If I can run `distinct timestamp` for each session, it would eliminate that duplication.

 

Any way I can do this? 

 

```

pageViews
| sort by session_Id, timestamp
```
1 Reply

Re: Remove Duplicate Events in Group

This seemed to do the job
 
```
pageViews
| summarize by session_Id, operation_Name, bin(timestamp, 1tick)
| sort by session_Id, timestamp asc

```

Related Conversations
Can't see folders in the Group files list
Laurie Willis  in  Office 365 Groups  on
16 Replies
Group restore is still in preview
Jesse Thompson  in  Office 365 Groups  on
6 Replies
Notifications in Groups
Anders Juul Sondrup  in  Office 365 Groups  on
6 Replies