Forum Discussion

Lisha's avatar
Lisha
Cloud Apps
10-04-2022
Solved

Dashboard Filter

Hi, I had a requirement to set my Dashboard date filter to have end date as today and this should be the default filter. (eg. 1 Jan 2022 to today) I found below script that does the job of settin...
dashboards & reporting
  • harikm007's avatar
    harikm007
    10-04-2022

    Hi Lisha ,

    Try this script along with existing dashboard script.

    dashboard.on('filterschanged', function (se, ev) {

	if(ev.items[0].jaql.title == 'As Of Month')
	{
		let today = new Date()
		let todayParsed = parsedDate = today.toISOString().substr(0,10)
	
		ev.items[0].jaql.filter.to = todayParsed
	
	}
});

    -Hari

harikm007's avatar
harikm007
Data Warehouse
10-04-2022

Hi Lisha ,

Try this script along with existing dashboard script.

dashboard.on('filterschanged', function (se, ev) {

	if(ev.items[0].jaql.title == 'As Of Month')
	{
		let today = new Date()
		let todayParsed = parsedDate = today.toISOString().substr(0,10)
	
		ev.items[0].jaql.filter.to = todayParsed
	
	}
});

-Hari

  • Lisha's avatar
    Lisha
    Cloud Apps
    10-04-2022

    Hi harikm007 

    This script is not working as expected. As you can see the date was set to today which is correct.

    However, on click of restore my default filters it goes back to the default filter that was set manually earlier. The default filter was not reset to have to date as today.

     

     

    • harikm007's avatar
      harikm007
      Data Warehouse
      10-04-2022

      Did you replace 'As Of Month' in above script with title of your filter ('Date')? ( I missed this to mention in above post).

       

       

      • Lisha's avatar
        Lisha
        Cloud Apps
        10-04-2022

        Okay yes. It is working fine now. Thank you.