How do I display the start date of the week instead of the week number?

Return to top
Have more questions? Submit a request

38 Comments

  • fellownarrator

    How do you do this same rename in the Backlog dataset?

    0
  • Ricardo
    Zendesk Community Team

    Hello fellownarrator!

    Could you please try the following formula:

    DATE_FORMAT(START_OF_WEEK_MONDAY([Backlog recorded - Date]),"YYYY-MM-dd")

    I tried in my test account and it worked. Let me know how it goes for you though!

    1
  • fellownarrator

    That worked, thanks Ricardo!

    0
  • fellownarrator

    How about for:

     

    Tickets Created - Week of Year

    Tickets Solved - Week of Year

    0
  • Ricardo
    Zendesk Community Team

    Are you trying to do add those attributes in the Backlog dataset fellownarrator?

    Those are not available in that dataset. But maybe I didn't understand your question :).

    0
  • fellownarrator

    No, what you gave for the Backlog dataset worked just fine.  Now, I want to make the same changes to a few reports I have in the Tickets Dataset, specifically for:

    Tickets Solved - Week of Year

    Tickets Created - Week of Year

     

     

    0
  • Ricardo
    Zendesk Community Team

    Ah! For the attribute "Tickets Created - Week of Year", you can use the example in the article.

    DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket created - Date]),"YYYY-MM-dd")

    For "Tickets Solved - Week of Year", it should be

    DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket solved - Date]),"YYYY-MM-dd")

    All you need to do is to change what is inside the [square brackets] with the respective Date attribute.

    0
  • fellownarrator

    Got it, thanks again!

    0

Please sign in to leave a comment.

Powered by Zendesk