Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
Use case: Essentially we have a 'DimDate' filter set to 'This Quarter' within our dashboard which works great, but whenever we enter into the last month of a given sales quarter, we need the 'DimDate' filter to be automatically set to 'Next Quarter' instead of 'This Quarter'. Instead of manually going to the filter on the dashboard every last month of the quarter, I want to make this process automatic. 
The example code is below:
dashboard.on('initialized',function(d) {

var date = new Date();
var n = date.getMonth();

if([3,6,9,12].includes(n)) {
dashboard.filters.update({ //Set the date filter to be next quarter
'column': 'Date',
'dim': '[DIM_Date.Date]',
'next': {
'count': 1,
'offset': 1
'level': 'quarters',
'table': 'DIM_Date',
'title': 'My filter'
Version history
Last update:
‎03-02-2023 09:16 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: