Editing dates and date ranges

Return to top
Have more questions? Submit a request

14 Comments

  • Tsvetan Marinov

    Hello,

    I have added a time filter to my dashboard, but for some reason I cannot set a default values to it?

    I am clicking on Publish button, but each time when I go to Preview or reload the page it reset to the date filter and it shows all history which is not what I want.

    However I can see that on the predefined dashboards for Overview and Efficiency the Date filter have predefined search. Could you please advise how I can achieve that on my dashboard as well?

    Regards,

    Tsvetan

     

    2
  • Andrew Forbes

    Hi Tsvetan,

     

    This result was achieved by using a Bookmark filter. You can read more about how to use Bookmarks in Explore here

     

    Essentially the process is as follows:

    1. Filter to a timeframe 

    2. Capture this timeframe as the default using the Bookmark

    3. Hide the Bookmark widget from the dashboard

     

    With that, your dashboard will default to a specific timeframe each time you open it :) 

    0
  • Tsvetan Marinov

    Hi Andrew,

    Thanks for the provided information. I will definitely try it out.

    Regards,

    Tsvetan

    0
  • Judd Higgins

    Andrew, this will not work.

     

    I need users to see the Bookmarks to sort as they wish when the view the Dashboard.

     

    I need to set the Default date to "Last Week" so that when I deliver this each Monday morning, the viewers see data from Last Week and then can go to the Dashboard and use the Bookmarks to modify the filters.

     

    We really need an option in the Dashboard for setting a Default Time Frame.

    4
  • Justin Federico

    Is there an option to set the week format? The default is Mon - Sun. We would like to report on Sun - Sat when we are setting the date range for "Last week".

    1
  • Molly

    Hey Judd,

    You don't have to hide the Bookmark on the dashboard, you can leave it visible and allow your agents to toggle between different options. At this time that's the only way to have a default time filter. 

    Hey Justin,

    Yes, you can update the week format by navigating the Data Structure menu, finding the attribute, and creating an ordered set:

    Then ordering them how you want:

    After saving, you'll need to select the newly ordered attribute from the list rather than the default. More about that here: Explore recipe: Using renamed and ordered sets to change displayed values

    -1
  • Justin Federico

    Molly,

    Thanks very much for this but I need to go further. I have a query showing tickets updated by week of the year. Based on the range I selected I can see that the week format is Mon-Sun, ending on Sun 3/24. Is there a way to accomplish the week format change if my query is showing more than a single week?

    Update:

    I applied the new attribute to a test query and the columns are now sorted Sun-Sat. The problem is that all this did was reorder the data. The date range is still 3/18-3/24. I was expecting it to be 3/17-3/23.

    2
  • Justin Federico

    Has anyone figured a way to change the week format for a date range filter? The screenshot shows the filter I have set for the previous week. You can see from the dates that this is looking at Mon-Sun. In GoodData we had the ability to select a Sun-Mon format.

    It's hard to completely move to Explore with these types of limitations.

    0
  • Andy Killingsworth

    Hey, Justin!

    Thanks for the question. Explore doesn't have the same native Sun-Sat format as Insights, but we do have a solid workaround. 

    You can build a standard calculated attribute that sorts ticket dates in whichever week you'd like, such as the "week" starting on Sunday. For more details on creating that query, please see our Explore recipe: Using a Sunday to Saturday week attribute.

    1
  • Sarah

    Hi,

    The date format is dd/mm/yyyy when using the dashboard, however once I export the same dashboard to a PDF the date range changes to mm/dd/yyyy. How can I change so it's consistently dd/mm/yyyy?

    Dashboard:

    PDF:

    0
  • Landy Zamor

    My 'Apply' button is missing. I can't save my changes to the date field. How can I bring it back?

    0
  • Brett - Community Manager
    Zendesk Community Team

    Hey Landy,

    Any chance you could provide a screenshot of what you see on your end?

    Are you able to replicate this from another browser as well?

    Let me know!

    0
  • Ryad-Malik MEFTAHI

    Hi,

     

    I am also trying to set a default time range filter to last week.

    I tried to solution of using a bookmark to capture the current state (with the last week filter set) but it doesn't work, when you open to dashboard no bookmark are selected, the question then become how to set a default bookmark.

     

    Also my bookmark widget seems broken, I can't name my bookmarks, they must be named New bookmark and I can't seem to change this, i am only able to rename to widget title (bookmark)

     

    This is what I see when I click to edit the bookmark widget : 

     

    Thank you for your help!

     

    Ryad

    0
  • Devan - Community Manager
    Zendesk Community Team

    Ryad-Malik MEFTAHI,

    I've opened up a ticket for you since this looks like it might be a bug and should receive a response from one of our advocates shortly. Let us know if there is anything else we can help you with.

    Best regards. 

    0

Please sign in to leave a comment.

Powered by Zendesk