Free Trial

Alteryx Designer Desktop Discussions

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

"Caller" more than once within 24 hours

bh1789
8 - Asteroid

I need to determine if the same "caller" made a call within a 24 hour period (Jack Black did in the below example INC1 and INC2)

 

NumberCreatedCaller
INC12020-12-01 07:21:20Jack Black
INC22020-12-01 09:21:20Jack Black
INC32020-12-01 07:40:22Bob Brown
INC42020-12-02 07:41:15Brian Green
INC52020-12-02 07:50:11James Red
INC62020-12-02 07:51:50Andrew Smith
INC72020-12-04 08:46:37Andrew Smith
2 REPLIES 2
DavidP
17 - Castor
17 - Castor

Hi @bh1789 

 

You can take advantage of the Grouping functionality in the Mult-row formula tool to do this. Have a look at the example attached.

 

DavidP_0-1611183760722.png

 

Qiu
21 - Polaris
21 - Polaris

@bh1789 
Try to make it to be more general in case of multiple entries for one caller.

0121-bh1789.PNG

Labels
Top Solution Authors