Christopher Le Quesne
-
Total activity7
-
Last activity
-
Member since
-
Following0 users
-
Followed by0 users
-
Votes0
-
Subscriptions2
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...
-
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.
-
Christopher Le Quesne commented,
Here's what is contained in the two attributes:[TicketSolvedWeekday]:IFWEEKDAY_NUMERIC([Ticket solved - Date])-1 = 0 THEN 7 ELSE WEEKDAY_NUMERIC([Ticket solved - Date])-1ENDIF[CurrentWeekday]:IFCUR...
-
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 t...
-
Christopher Le Quesne created a post,
Broken Boolean Logic?
AnsweredHi - 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-d...