Here are a couple ways to exclude the weekends from your data. If you have another way that you use, please share it here!
WHERE strftime('%w', "ga:date") NOT IN ('0','6')
This will give you all of your data, but exclude those rows that fall on a Saturday ("weekday 6" in SQLite) or Sunday ("weekday 0").
WHERE EXTRACT(DOW FROM "ga:date") <> '0' AND EXTRACT(DOW FROM "ga:date") <> '6'
Calculated Columns and Filter Transforms
You can use the "DateFormat" expression in a Calculated Columns transform to add a new column with the day of the week for each row, and then add a Filter transform to exclude the "Saturday" and "Sunday" rows.
Please sign in to leave a comment.