Alteryx Designer Discussions

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

Counting date time occurances in a text field

DKMI
6 - Meteoroid

I am hoping someone may be able to help with the following challenges.

 

Challenge 1:

 

I have a text field like this:

 

2021-10-14 19:31:44 - HR_EC_Connector (Employee Central Connector) (Additional comments)
Manager Approval
Decision: approved
Approver: 10111s

 

2021-10-14 18:51:46 - HR_EC_Connector (Employee Central Connector) (Additional comments)
User HR_EC_Connector (Employee Central Connector) has initiated a Promotion of Employee requests approval

 

The bottom section is a comment added to a ticket on the date shown, The top section is the ticket being updated with a response.

 

I am looking to count the number of messages in this field ie.. count the number of times the format YYYY-MM-DD HH:MM:SS is used (none of the other text is available in all records)

 

Challenge 2:

 

How might I calculate the average response time for all messages within this field?

4 REPLIES 4
atcodedog05
21 - Polaris

Hi @DKMI 

 

You can use a formula like this

 

 

REGEX_CountMatches([Field1], 
"\d{4}-\d{2}-\d{2} \d{2}:\d{2}:\d{2}")

 

 

Workflow:

atcodedog05_0-1642164472532.png

 

Hope this helps : )

 

binuacs
12 - Quasar

@DKMI  answering your second question

 

binuacs_1-1642179925633.png

 

 

atcodedog05
21 - Polaris

Totally missed out on the 2nd requirement 😅. Great catch @binuacs 🙂

DKMI
6 - Meteoroid

Outstanding thank you!

 

 

Labels