If Statement within Advanced Filters?

hey simon_geoghegan ,

From the description shared in the post, it's sounds like the needs is to be able to change the JAQL once the filters apply, based on the day of the week.

First of all, it's recommended to have a Date Dimension in the data model which contain columns such as Day of Week (number) and Day Name. 

Sisense doesn't support natively if Statement within dashboard filters however the following can be achieved using the native dashboard class API that Sisense provides. 

This, Allow to run a Java script within a dashboard script and to change the Filter Jaql while the Filters changed. 

Here is an example of accessing the Sisense JAQL (Assuming there's one Date filter in the dashboard)

1. Add a date filter on top of the dashboard (first filter)
2. Open Dashboard Menu and Click on Edit Script 
3. Paste the script

dashboard.on('filterschanged', function(dashboard) {
    let filters = dashboard.filters.$$items;

    if (filters.length > 0) {
        let filter = filters[0].jaql; // Get the first filter

        if (filter?.filter?.last) {
            console.log("Before update:", filter.filter.last);

            // Toggle the count value: If 1 → set to 3, else set to 1
            filter.filter.last.count = filter.filter.last.count === 1 ? 3 : 1;
            
            console.log("After update:", filter.filter.last);

            // Apply the updated filter without triggering a full dashboard refresh
            dashboard.filters.apply();
        }
    }
});

The script is an example of how to update the jaql.last.count value using the 'filteredchanged' event and refresh the dashboard with the correct values based on the script.

The Original selection by the User

After applying the script

Note: This is a sample solution that may not directly resolve the issue, but it provides a starting point for addressing it.

Best regards