Forum Discussion

SGeorgie's avatar
SGeorgie
Copper 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

Resources