Forum Discussion
harikm007
08-11-2022Data Warehouse
mirzay Another approach is to write a dashboard script to select last 180 days and N\A in filter.
dashboard.on('initialized', function (se, ev) {
filter = se.filters.$$items.find(el=>el.jaql.title == 'Date')
day_count = 180
max_date = new Date(new Date().toDateString())
min_date = new Date()
min_date.setDate(max_date.getDate()-day_count);
var new_date_list = [];
var new_date_list_string = []
temp_date = min_date
while (temp_date <= max_date) {
new_date_list.push(new Date(temp_date));
new_date_list_string.push(moment(temp_date).format('YYYY-MM-DDT00:00:00'));
temp_date.setDate(temp_date.getDate() + 1);
}
new_date_list_string.push('N\\A')
breakbyFilter = {
'jaql': filter.jaql
}
filter.jaql.filter = {
"explicit": true,
"multiSelection": true,
"members": new_date_list_string
}
filter.jaql.level = 'days'
var filterOptions = {
save: true,
refresh: true,
}
se.filters.update(filter, filterOptions)
})
-Hari