Remove Duplicate Events in Group

[Deleted]

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

```

[#2]

This seemed to do the job

```

pageViews

| summarize by session_Id, operation_Name, bin(timestamp, 1tick)

| sort by session_Id, timestamp asc

```