UiPath Insights - Get top 1 record from queue based on date

[ShubhankarJogalekar (Shubhankar)]

Hi,

I want to create a dashboard where I need to display list of exceptions (business and application exception) with exception reason. Each queue item will be processed more than once if there is business exception (same day or next day), and every queue item has a ticket number as reference number. Hence in the current dashboard same ticket number is counted multiple times when calculating the data. What I want is to count one ticket number only once (top 1) based on latest End Processing Date.

Any help would be much appreciated.

Thanks.