Forum Discussion
Deleted
Dec 22, 2017Remove 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
```
- DeletedThis seemed to do the job```pageViews| summarize by session_Id, operation_Name, bin(timestamp, 1tick)| sort by session_Id, timestamp asc
```