Recent searches
No recent searches

Christopher Le Quesne
Joined Apr 15, 2021
·
Last activity Oct 20, 2021
Following
0
Followers
0
Total activity
7
Votes
0
Subscriptions
2
ACTIVITY OVERVIEW
BADGES
ARTICLES
POSTS
COMMUNITY COMMENTS
ARTICLE COMMENTS
ACTIVITY OVERVIEW
Latest activity by Christopher Le Quesne
Christopher Le Quesne commented,
Fixed this - turns out the DATE_FORMAT functions were causing the issues but I still don't understand why...
View comment · Posted Mar 16, 2021 · Christopher Le Quesne
0
Followers
0
Votes
0
Comments
Christopher Le Quesne commented,
Hi - why does the WEEKDAY_NUMERIC() function not allow us to set the parameter for when the week starts? Even Excel lets us do this, this should be fundamental to an analytics tool.
View comment · Posted Mar 16, 2021 · Christopher Le Quesne
0
Followers
0
Votes
0
Comments
Christopher Le Quesne commented,
Here's what is contained in the two attributes:
[TicketSolvedWeekday]:
IF
WEEKDAY_NUMERIC([Ticket solved - Date])-1 = 0 THEN 7 ELSE WEEKDAY_NUMERIC([Ticket solved - Date])-1
ENDIF
[CurrentWeekday]:
IF
CURRENT_WEEKDAY_NUMERIC() = 0 THEN 7 ELSE CURRENT_WEEKDAY_NUMERIC()
ENDIF
I literally had to write this because for some reason it is hard for Zendesk to just put an optional parameter into WEEKDAY_NUMERIC so you could actually choose the week start day. This is a basic thing that I would expect from an analytical tool for date-based analytics and it's quite bad to see Zendesk don't think this is important.
View comment · Posted Mar 16, 2021 · Christopher Le Quesne
0
Followers
0
Votes
0
Comments
Christopher Le Quesne commented,
Extra info on this - it seems to be tied to my [TicketSolvedWeekday] < [CurrentWeekday] boolean consisting of two attributes that are each individually defined by further boolean logic.
If I swap this statement to say 1 < 2 it suddenly evaluates the whole thing to false as it should do so there is clearly something very strange happening here.
It's as if Zendesk Explore can't process the outputs of these custom attributes within another piece of logic correctly. Interestingly I also can't take the logic from these attributes and compare them explicitly because it returns an error, despite there not being an error when I store each of them in an attribute.
View comment · Posted Mar 16, 2021 · Christopher Le Quesne
0
Followers
0
Votes
0
Comments
Christopher Le Quesne created a post,
Hi - I am looking at the following logic for a specific ticket as a test.
(
DATE_FORMAT([Ticket solved - Date],"yyyy-mm-dd") >= DATE_FORMAT(DATE_ADD(START_OF_WEEK_MONDAY(TODAY()),"day",-7),"yyyy-mm-dd")
AND
DATE_FORMAT([Ticket solved - Date],"yyyy-mm-dd") < DATE_FORMAT(START_OF_WEEK_MONDAY(TODAY()),"yyyy-mm-dd")
)
AND
[TicketSolvedWeekday] < [CurrentWeekday]
This seems to be evaluating to True based on the third boolean being True however one of the other two booleans is false so this should evaluate to False.
Why would it ignore the first statement completely like this? Am I missing something?
Posted Mar 16, 2021 · Christopher Le Quesne
0
Followers
2
Votes
4
Comments