Forum Discussion

SGeorgie's avatar
SGeorgie
Brass Contributor
Jan 20, 2023

How to use a pivot to work out counts

Hello,

 

I have data which shows the number of closed tickets per technician and by date among other things.

 

I can pull a pivot to show how many closed tickets per tech but what I need is:

 

Most tickets closed in one day

Fewest tickets closed in one day

Most tickets closed in one day per tech

 

Any ideas please?

 

Thanks

No RepliesBe the first to reply