I have a need to filter based on day of week - for example, I need to total all weekend (or weekday) sales.The filter would seem to be the way to go, but I can't find a way to get it to filter based on weekday. I tried JAQL exclude, which it parsed ok but didn't seem to work correctly.Any other ideas?

Hey pb_si , The recommended best practice for retrieving this data is to include a Date Dimension directly in the data model, which is then joined to the relevant Fact tables. Dim Date includes the Date column along with related columns such as: Days_of_week Is_weekend or Weekend/Weekday With this approach, instead of filtering by a specific date, the Weekend/Weekday column can be used as a dashboard filter. This also allows the option to group by this column (see the related scr...

Filter only on Weekends or Weekdays | Help and How-To

MoreDiscussions

Filter only on Weekends or Weekdays | Help and How-To | Sisense Community