Avatar

Christopher Le Quesne

  • Atividade total
    7
  • Última atividade
  • Membro desde
  • Seguindo
    0 usuário
  • Seguido por
    0 usuário
  • Votos
    0
  • Assinaturas
    2

Visão geral da atividade

Atividade mais recente por Christopher Le Quesne
  • Avatar

    Christopher Le Quesne comentou,

    Fixed this - turns out the DATE_FORMAT functions were causing the issues but I still don't understand why...

  • Avatar

    Christopher Le Quesne comentou,

    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.

  • Avatar

    Christopher Le Quesne comentou,

    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...

  • Avatar

    Christopher Le Quesne comentou,

    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...

  • Avatar

    Christopher Le Quesne criou uma publicação,

    Broken Boolean Logic?

    Respondida

    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-d...