Create a widget filter based on dashboard filter

Akhila ,

Please check if this script gives you expected result (add this script to the widget where you want to see data till selected date and update the variable 'columnName' with field name):

widget.on('beforequery', function(se, ev){

	columnName = 'DATE_OF_JOINING'//replace this with your field name
	dashdatefilter = ev.widget.dashboard.filters.$$items.find(el=>el.jaql.column == columnName)
	filterjaql = {
					to: dashdatefilter.jaql.filter.members[dashdatefilter.jaql.filter.members.length - 1],
					custom: true
	}
	
	widgetdatefilter = ev.query.metadata.find(el=>el.panel && el.panel == 'scope' && el.jaql.column == columnName)
	widgetdatefilter.jaql.filter = filterjaql

})

-Hari

Hi Akhila,

Are you looking for YTD,  MTD or related? If so these articles below might be interesting for you:

https://support.sisense.com/kb/en/article/ytd-function-reference

https://support.sisense.com/kb/en/article/calculating-ytd-with-variable-start-and-end-dates-of-the-year-academic-calendar

https://support.sisense.com/kb/en/article/date-analysis-yoy-mom-wow-ytd-mtd

Is it possible to achive same functionality with date range.

As in,respective widget (indicator) show aggregated value till end date in date range ignoring the start date part.