I want to create a report to show how many ITIL users have logged in to service portal in last 90 days and the report has to be fetched from 'ua_sp_usage' table.
Currently, I am using 3 filters :
1. User.Roles is ITIL
2. Portal is Service Portal
3. Start Time on Last 90 days.
These filters fetch the data correctly but challenge here is that it gives the data of 1 user multiple times if that particular user has logged in to Service portal multiple times in a day.
Question - How can I get a unique user entry in the report ? (1 user 1 visit) What filter can be used here?
PS : I am attaching the screenshot of the current report.
