Explore recipe: Using a Sunday to Saturday week attribute

Return to top
Have more questions? Submit a request

18 Comments

  • Kirsten

    Hi, I tried to do this for week starting on Saturday, but there's no option to edit the date range:

    Are there additional steps I'm missing?

    Thank you!

    -1
  • Brett Bowser
    Zendesk Community Team

    Hey Kirsten,

    I'm going to create a ticket on your behalf so our Customer Advocacy team can dig into this further for you. You'll receive an email shortly stating your ticket has been created.

    Cheers!

    0
  • William Chase Myer

    I am experiencing the same issue as Kristen:

     

    Use case: I need to automate reports to be sent out weekly, which scheduling is the easy part but I am having difficulty creating a Sunday-Saturday ticket solved - last week attribute to use. Is there something missing from the formula? 

    Is there anyway to make this update to the previous week to effectively automate a distribution schedule? 

     

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello William Chase Myer,

    I've gone ahead and opened a ticket on your behalf so our Advocacy team can look into this deeper for you. You'll receive an email shortly stating your ticket has been created.

    Best regards. 

    0
  • Ryad-Malik MEFTAHI

    Hi, I am having the same problem. Was the issue resolved? If not could you open a ticket on my behalf please.

    0
  • Nicole S.
    Zendesk Community Team

    Hi Ryad-Malik,

    Custom date/time attributes will not have the “Edit date ranges” button. Dynamic ranges are only available for default date/time attributes.

     
    0
  • smithy smith

    Hi,

     

    I used the formula and it returns the week start date however it seems to be splitting the results between two lines when compared to the week of year attribute. Is there a way to get a better understanding of how this function works? I would assume that the week start date and the week of year when used together should return results that do not split between rows. Ticket solved was used for both attributes (week of year and week start date formula).

    0
  • Hannah Meier
    Zendesk team member

    Hello smithy smith,

    This is because the built-in Week of year attributes will show weeks based on a start date of Monday with the end date of Sunday. The above recipe creates a Standard calculated attribute that reports on data by week with Sunday as the start of the week. These attributes are not meant to be used together because they are define weeks differently.

    If you want an attribute that shows the date the week started for the week of year attribute, you'll need to create this attribute instead.

    0
  • Larry Click

    I just have to say, this shouldn't be so convoluted. I've not see a calendar that doesn't start on Sunday. Should just be an option in Explore that the week starts on Sunday or Monday. 

    2
  • Nicole S.
    Zendesk Community Team

    Thanks for that feedback, Larry.

    0
  • Pavel Grozev

    I am experiencing the same issue as Kristen and William. Is there a plan to have dynamic data ranges? Or at least have the option of picking last week data for every week's schedule report delivery?

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello Pavel Grozev,

    I've opened up a ticket on your behalf so our team of Advocates can look into this for you. You should receive an email shortly followed by a reply from one of our experts. 

    Best regards. 

    0
  • Katarzyna KRZAK

    Hi,

    Our team provides support from Monday to Friday. As the tickets created on weekends should be included in the next week report, I assume that my week should start on Saturday. Is that correct? 

    The query looks like this;
    I used the time filter (in the query) to display only last 8 weeks. But when I have a query on the dashboard and apply the 'last week' time filter it looks like the results are messed up. 
    Can you explain how this calculated attribute will work with 'last week' or 'this week' time filter?

    Thank you!

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello Katarzyna KRZAK,

    So the best way to accomplish this would be to utilize time filters in your dashboard. I've linked an article below that goes into detail on how to implement this in your Explore instance.

    Best practices for using dashboard filters

    Best regards. 

    0
  • John Tieu

    We're experiencing the same limitation as Kristin, William and Pavel. We'd like to be able to see the rolling 3 week date range without having to manually pick and choose weeks each time we want to review the latest data for our reports. 

    Similarly, it's not user friendly to use the default metric of Week 1, 2, 3 etc. Is there any plan to allow advanced date ranges?

    0
  • Devan - Community Manager
    Zendesk Community Team

    Hello John Tieu,

    With this issue, unfortunately, that is expected behavior. Custom metrics and attributes do not have the functionality to do the "edit date range" function at this time. A workaround would be to go in and manually select the dates you want, or use the metric as a filter and select it up in the filter. Either way, it does require manual selection.

    Best regards. 

    0
  • Matt Salas

    To those trying to filter dynamically, I did something that always gives me the current week starting Sunday and ending Saturday. Basically you're creating a true or false flag and then just filter on that. My flag will allow to see the full week in review as well as I've based it on the prior day's date.

     

    LEFTPART(START_OF_WEEK_SUNDAY([Chat started - Date]),10)=LEFTPART( START_OF_WEEK_SUNDAY(DATE_ADD(TODAY(),"day",-1)),10 )

    0
  • Brett Bowser
    Zendesk Community Team

    Thanks for taking the time to share this Matt!

    1

Please sign in to leave a comment.

Powered by Zendesk