Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
5 years ago

Date range slicer (or other data range user interface) to be updated automatically

I am posting this question again (3rd time) because I did not get solution for my issue.   I am trying to apply Date Range slicer as below, and I would like this to be updated automatically. The p...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hi JustinDoh1,

have you enabled the following option?

 "Don't allow end user to save filters on this report."

 

 

  • JustinDoh1's avatar
    JustinDoh1
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    mwegener Not sure how/whether it would suffice my requirement, but I just enabled it and republished to the service. But, would't it just the feature for report to stay where they were left off (by not having the option of going back to a default mode)? My requirement is having the date ranges automatically updated 14 days interval. Let me check tomorrow when data refreshs to check whether it makes sense or not. Thanks.

    • JustinDoh1's avatar
      JustinDoh1
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      mwegener I liked using "Relative date" filter (compared to using measure of last 14 days) as it has the option of "Clear selections". Only issue that I have is that the actual visual (or graph) does not reflect those date range (I guess since I cleared the selection). As you can see (on the bottom image illustration), it starts from the very beginning of data (early 2020). Reason I cleared the selection was so that this date range would be updated dynamically (for instance, it would be 7/3/2021 - 7/14/2021 tomorrow), correct? It is little bit not making sense why this date range would not be updated by itself if we do not clear the filter. Is there a way for graph be reflected based on the filter, and also date range be updated dynamically? Thanks.

       

      • mwegener's avatar
        mwegener
        Icon for Most Valuable Professional rankMost Valuable Professional
        5 years ago

        Hi JustinDoh1 ,

         

        move the filter from "Filter on this visual" to "Filter on this page"

         

  • JustinDoh1's avatar
    JustinDoh1
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    mwegener I was expecting the date range starts from 6/29/2021, but it still stays at 6/28/2021 this morning (after daily data refresh). I don't think it would suffice my requirement... Thanks!

     

     

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      5 years ago

      Hi JustinDoh1 ,


      is the selection cleared on the slicer?

      It is important that the slicer has not saved any preselection and only displays the value range set via the filter. Therefore, users should not be able to save slicer/filter settings.

       

      • JustinDoh1's avatar
        JustinDoh1
        Icon for Post Prodigy rankPost Prodigy
        5 years ago

        mwegener Thank you again! (and for your prompt response). I don't see that option on Slicer itself, but I see "Clear Filter" option in  "14 Days Reports" measure. So, I cleared the filter.

         

         

        After clearing filter:

         

        But, I see this behavior. Even though the slicer moves by itself, the date range (ex: 6/27/2021) does not seem to get adjusted, but that was my requirement...

         

        I modified the slicer so that I do not use the measure anymore. Now I see "Clear Filter" option is available on Slicer itself. But, when I clear it, it obvisously cleared the visual (it displays all avialable date range).