Editing dates and date ranges

Have more questions? Submit a request

9 Comments

  • Tsvetan Marinov
    Comment actions Permalink

    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

     

    1
  • Andrew Forbes
    Comment actions Permalink

    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 :) 

    -1
  • Tsvetan Marinov
    Comment actions Permalink

    Hi Andrew,

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

    Regards,

    Tsvetan

    0
  • Judd Higgins
    Comment actions Permalink

    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.

    3
  • Justin Federico
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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
    Comment actions Permalink

    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

Please sign in to leave a comment.

Powered by Zendesk