1 Reply Latest reply on May 17, 2018 7:23 PM by Bryce Larsen

    Making Relative Date Filters More Dynamic

    john white
    john white May 17, 2018 2:44 PM

      Issue is i want to use relative date filters as a way to filter data and keep the dashboard up-to-date.

       

      The issue is that my data is not real time and is always today() -1.

      My clients want to see the dashboard change ever month; however, with the data being today()-1 there will not be any data for the new month until the 2nd.

      Is there anyway to control the relative date filter and make it look at the max data date oppose to using a standard calendar?

       

      I have seen post about creating parameters to control the anchor but that still leaves the issue of the updating the dashboard. I have also seen where there is a slider/type in filter that allows the user to select ' last n days' which will not work due to the length of time my data stretches.

       

      Any solutions?

       

      Thank you

      • 42 Views
      • Categories: Actions & Filters, Calculations, Dates & Times, Views & Dashboards
      • Tags:
        • 1. Re: Making Relative Date Filters More Dynamic
          Bryce Larsen
          Bryce Larsen May 17, 2018 7:23 PM (in response to john white)

          Hi john white!

          You are correct - you can look to use a parameter where the user can first select from here: Most Recent or Custom, and after click Custom they can then use a Date Picker.

           

          I first find the Max Date in the data using a LOD expression. If they select Most Recent, I use this field, otherwise I use the Date Picker (which I compared to Max Date to ensure it's not more recent than the max date - if so, I "snap" it back to the Max Date.

           

          Screen Shot 2018-05-17 at 10.20.09 PM.png

          I've attached an old date template workbook for reference. I'm sure I've learned new/better ways since doing this, but figured it might help!

           

          Best,

          Bryce