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

```