Editing dates and date ranges

Return to top

9 Comments

  • Ervin Balazon

    Hi @... @...

    It seems this article sent provides instructions on how to do adjust time for a query.

    However, I'd like to adjust the "LAST WEEK" date range in the time filter for the entire DASHBOARD, not the query. My preference is start date: MONDAY, and end date: SUNDAY.

    For reference, please see the screenshot below. When I click "Last Week," the result is 1/24 - 1/30 which is a start date of Sunday, and an end date of Saturday -- instead, this should display 1/25 - 1/31. Is this possible?

    0
  • Paul Strauss

    Is there a way to create a dashboard that can have its dates set for on-demand reporting but can also generate scheduled email reports for preset ranges like "last 7 days" or "last month?" When I've done this before, I had to create duplicates of all my queries and a duplicate dashboard - one set of queries with no date restrictions so the Dashboard can set the dates, and another with the specific date restrictions for the scheduled email reports. I'd much rather do it with a single set of queries if there's a way to do it.

    0
  • Taylor Bowser
    Zendesk Customer Care

    Hi @...


    Thanks for reaching out! Selecting Last Week within the time filter should default to Monday - Sunday but as you can see the dates shown reflect Sunday - Saturday. We've raised this issue with our Product team and they will be working on a fix. I'd be happy to create a ticket on your behalf so you can stay updated on the progress. 

    In the meantime, we recommend manually selecting the dates within the time filter to reflect Monday - Sunday

    We're very sorry for any inconvenience.

    0
  • Paul Strauss

    I recently created a series of queries that have a pre-set date range of the last 7 days, and wanted to know if there's any way to include the date range that's covered somewhere on a dashboard that goes out via email each week. I know I could include the covered dates in table format, but these particular queries are either KPI (average for the week) or sparklines, so they don't display the date range.

    0
  • Taylor Bowser
    Zendesk Customer Care

    Hi @...

    Could you use a time filter at the dashboard level to filter to the last 7 days instead of filtering at the query level? When adding a time filter to a dashboard you can choose to show the selected date range on the dashboard. Here are some articles that might help for setting up time filters: 

    Warm regards, 

    0
  • Antonio Rodríguez

    I'm having the same issue as Ervin with the "Last week" time filter, but I want to add some more info on what I have observed. 

    When I select "Last week", the dates shown as currently viewing are Sunday to Saturday (2/28 to 3/6), and these are the results my queries show:

    Then, when I select "Custom", starting on Monday 3/1 and ending on Sunday 3/7, my queries show the same results:

    And finally, if I select "Custom", starting on Sunday 2/28 and ending on Saturday 3/6, I get different results:

    So, from this, what I understand is that the "Last week" filter is correctly showing results for Monday to Sunday, even though the dates shown as currently viewing are Sunday to Saturday. To everyone confused here, if your work week is Monday to Sunday, it looks like you can continue to use "Last week" confidently. 

    @... please make sure your Product team is aware of this, and I hope the display issue can be fixed soon.

    0
  • Gab Guinto
    Zendesk Customer Care

    Hi Antonio,

    Thanks for adding these here. Like what Taylor mentioned, this has been raised to our product and they are working to address this as soon as possible. Sorry again for any trouble that this may have caused. We'll also create a ticket on your behalf and link it up to the problem ticket that the product team is working on, so that you'll be notified as soon as a fix is ready for roll out.

    Thanks Antonio!

    0
  • Jake Babineau

    Howdy,

    Currently, my organization pulls the data individually for every day of the month. We need each separate day due to the way we currently calculate our metrics, but I'm having trouble finding a way to edit the date options in order to do that in one single report (choose a month and have that break out each individual day in one report), so that I can do a single export with all the individual data per day for each of our analysts, rather than having to adjust the date options for a single day, export, then rinse and repeat for the entire month.

    Any suggestions?

    0
  • Gab Guinto
    Zendesk Customer Care

    Hi Jake,

    If you add a - Date or - Day of month attribute (example: Ticket solved - Date, Update - Day of month) under rows/columns, then your metrics should be sliced per date. When you visit your report to export the data daily, the query should show how the numbers are for each day/date. If your report is also sliced by agent or assignee, then your report will display the stats of each agent for each day of the month.

    0

Please sign in to leave a comment.

Powered by Zendesk