Calendar week 52

3 Comments

  • Sydney Neubauer

    We definitely had this issue affecting our reports. Upvoting

    0
  • Anton M.

    upvoting. having 2 weeks №52 in one year is a mess (Jan from previous year + Dec for current)  .
    In our internal reports I've created a new custom metric as a workaround. 

    Here is calculated attribute code, that works for ticket creation week and year. It uses the fact, that first day of the week only exists in 1 year, + some formatting, so the text field will sort correctly. 

    If WEEK_NUMBER_MONDAY(START_OF_WEEK_MONDAY([Ticket created - Timestamp]))<10 then 
    String(Year(START_OF_WEEK_MONDAY([Ticket created - Timestamp])))
    +"-0"+String(WEEK_NUMBER_MONDAY(START_OF_WEEK_MONDAY([Ticket created - Timestamp])))

    else
    String(Year(START_OF_WEEK_MONDAY([Ticket created - Timestamp])))
    +"-"+String(WEEK_NUMBER_MONDAY(START_OF_WEEK_MONDAY([Ticket created - Timestamp])))
    endif


    PS you may need to use WEEK_NUMBER_SUNDAY if your weeks start on Sunday. 

    0
  • CJ Johnson

    Last year the problem was week 53, forgot about this particular issue but agreed, it would be nice not to have to work around this every January. 

    0

Please sign in to leave a comment.

Powered by Zendesk