If Statement within Advanced Filters? | Help and How-To

simon_geoghegan · 2025-02-17T09:32:45.902000Z

Hi All,First time posting here and hoping for some advice around advanced filters if possible please.I currently have this filter which gives me results based upon the previous createddatetime:Unfortunately, this scenario is not always relevant - due to some departments being closed at weekends, there is nothing displayed when the report is ran on a Monday morning.Is there any way of applying IF logic within advanced for the following scenario?If dayoftheweek = 1 (i.e. Monday)count: 3, offset: 1elsecount:1, offset: 1Effectively, I want to show Friday, Saturday & Sunday data when the current dayoftheweek is Monday, otherwise I just want the previous days data.I've had a search around the knowledge base but couldn't find anything (however i'm relatively new to Sisense so it might just be that I've not understood what some of the forum posts meant!)Any help greatly appreciated.Regards,Simon

MoreDiscussions

If Statement within Advanced Filters? | Help and How-To | Sisense Community