@Mukherjee, Sirsendu Thanks for reaching out. Here are some of the kusto examples that can help you retrieve the information about clicks and session data.
- Below provides information number of clicks segregated by an hour. pageViews
| where timestamp >= ago(24h)
| summarize totalclicks=count() by user_Id , session_Id , name, bin(timestamp,1h)
| order by timestamp desc - Below kusto provides information of distinct sessions segregated by day pageViews
| where timestamp >= ago(7d)
| summarize dcount(session_Id) , totalclicks=count() by user_Id , name , bin(timestamp,1d)
Reference Documents: