Explore recipe: Creating weekly date buckets

Have more questions? Submit a request

9 Comments

  • Terry O'Donnell
    Comment actions Permalink

    Hi Andrew,  This article was helpful.  I have a need for all Explore Weekly Reporting to start Sunday and end on Saturday.  The current default Week in Explore starts on Monday and ends on Sunday.

    Will I need to build out some weekly metrics to have a Sun-Sat work week?

     

    Insights allowed a couple choices of week start and end dates.

     

    Can the be a feature Request for Explore?

     

    Thanks, ~Terry (Evernote)

    1
  • Andrew Forbes
    Comment actions Permalink

    Hey Terry,

     

    You can build out some custom metrics to track weeks that start on Sunday. The formula looks something like: START_OF_WEEK_SUNDAY(_date). 

     

    We don't currently have it on the roadmap for this to be a native feature, but it is possible with a Calculated Attribute. I'll bring it up with our Product team to see their thoughts! 

    0
  • Travis Tubbs
    Comment actions Permalink

    I think the syntax of the example provided is incorrect because I keep getting an error when copying it and attempting to put in a field name. Specifically, the brackets are in the wrong place.

    The field name should be enclosed in brackets, not the DATE function. For example:

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

    At least, that's what I had to do to get this to work.

    0
  • Nicole Haberman
    Comment actions Permalink

    I keep getting an error that is difficult to track down "An error has occurred while evaluating Week Bucket for the following values: Ticket solved - Date -> .


    I have the following as my calculated query: 

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

     

    Is there something wrong with the syntax of the query I have, or is the error related to something else? 

    0
  • Rob Stack
    Comment actions Permalink

    Hi Nicole, I tried this query and got the same error as you did. I'm going to create a ticket for this so we can investigate it properly and get this working for you. Someone will be in touch soon.

    0
  • Allen Lai
    Comment actions Permalink

    Feels like something that should come out of the box, rather than having to create a custom calculated attribute.

    1
  • Devan
    Comment actions Permalink

    Hello Allen Lai,

    I appreciate the insight on Explore. I would suggest posting your thoughts in our product feedback forums so our developers can consider it for a future update in the future.

    Best regards. 

    0
  • Devan
    Comment actions Permalink


    On Wednesday, April 8, from 8:00am-10:00pm CDT, we'll have a special guest team of experts on hand to answer your questions about Explore: Reporting & Insights Migration in your Zendesk Explore instance for an AMA-style conversation!

    Just click the "new post" button and write up your question. Be sure to be as detailed as possible. The best questions include: 

    • What it is you're trying to do
    • What you've tried so far 
    • Any other context or relevant information
    • Screenshots, if you have them

    Questions posted to this topic in advance of the start time will be answered first thing on the 8th, so if you've got something you want our experts to look at, post it today!

    0
  • Stanley Franco
    Comment actions Permalink

    Hey Devan is there a Zoom or Hangouts for the AMA tomorrow? How do I sign up?

    0

Please sign in to leave a comment.

Powered by Zendesk