I need find Top 5 Users Name Tried Accessing blocked URL based on number of hits in bar chart
This is my data model. I have UserName in Incoming Buffer Table, Hits in IncomingBuffer Table. I want to get top 5 users who have tried accessing the blocked websites based on Number of Hits on that website, StatusOfConnection which gives us the connection is permitted or not.
Another Problem is How to extract Website Name using URL in QlikView?