3 Replies Latest reply on Aug 2, 2018 1:29 AM by M Lamb

    Published dashboard to default date to Today

    M Lamb

      Dear all,

       

      I'm out of my wits here and desperately looking for help!

       

      I have attached the workbook in 10.2 but I'm using 2018.1.

       

      The data has future dates and it's a daily record of a KPI.

       

      How can I show on the published dashboard to default to today and everything before that?  And the user would also like to select historical dates and see how daily KPI were performing before the 'Selected Date'....

      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

      My current solution is located on the second sheet, where the user can choose Today or Calendar (historical data). However, the stakeholders still do not like the Calendar UI cannot be updated/refreshed after publishing...

       

      Any suggestions will be appreciated!  Thank you!