Data structure:
Requirement:
- Find the maximum number of tickets resolved by an employee in a day.
For example, on 15/02/2022, maximum number of tickets resolved is 3.
Solution:
- Drag ‘Resolved Date’ field to the rows. Right click on the field choose ‘Exact Date’ and then again right on the ‘Resolved Date’ to select discrete.
- Create a new calculated field and name the calculation as ‘Max of Tickets Resolved’
- Enter the following calculation in the calculation editor
- MAX( { FIXED [Assigned to], [Resolved Date]:COUNTD ([Ticket ID])} )
- Drag the ‘Max of Tickets Resolved’ field to the text in the Marks card
Output:
Downloads: