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?
Solved! Go to Solution.
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:
Hope this helps : )
Totally missed out on the 2nd requirement 😅. Great catch @binuacs 🙂
Outstanding thank you!