Regex recipe for update times ending in ":00"
I am trying to report on any update whose update time recorded by the Time Tracking app end in :00.
This is my current custom metric that is not functioning correctly:
IF (REGEXP_MATCH(STRING(SUM(Update Handling Time (Min))),"^:00$"))
THEN [Update ID]
ELSE NULL
ENDIF
I am working in the Updates history dataset. Any help developing the metric that will accurately report on this would be greatly appreciated. Thanks!
-
Hi Michael, and welcome to the community!
I think deleting the carat ("^") from the beginning of your regex string should help -- the carat matches the beginning of the string, and since you also have the dollar sign that matches the end of a string, I think the only string that would match right now would be ":00" exactly. So try changing your regex string to ":00$" instead, can you give that a try?
-
Hey Dave,
Thanks for the warm welcome and for the help. I made the suggested change of removing the ^ but it still returns no results.
Edit: I should add that I know there to be a few updates with times ending in :00 that it should report on.
Iniciar sesión para dejar un comentario.
2 Comentarios