Create a widget filter based on dashboard filter

[Akhila]

There is a dashboard filter of months. If month jan’22 is selected, i need to get data not only from jan’22 but till jan’22. Currently my dashboard is returning only jan’22 data. Is there is any script for this implementation?

[harikm007]

@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

[Piotr_qbeeq]

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-y...

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

[TJT]

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.