Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Ideas on an analysis

jeffv
8 - Asteroid

Good folks,

 

I was asked to do an analysis and wondering if any had ideas to accomplish it.  I have a list of data from helpdesk... agent, log-time, ticket.  I was asked to go through the data and show any agent that created three tickets within say a 15 minute period.

 

Thinking this out I need to group by agent but within that combine the log-time into 15 min groups.

 

Scratching my head.... any ideas?  I suspect it's easier than I'm making it.

 

Thanks for any input.

Jeff

 

 

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

Hi @jeffv ,

 

This is the way I would do it. The whole idea is based on the multi-row tool where, after ordering everything, I would calculate the difference between the current ticket and 2 above which would give me the difference between 3 opened tickets. (for the same agent - group by agent in multi-row)

 

fmvizcaino_0-1591810604660.png

 

 

Best,

Fernando Vizcaino

jeffv
8 - Asteroid
Thanks for your help... your workflow and message guided me to the right solution.
Labels