I want to create a table that lists out the average clicks per day based on the filters for weekday (5 days) vs weekend (2 days).
If I set the filter for “past 14 days”
I would like to see:
Weekday | clicks (sum of Mon-Fri for last 2 weeks) | clicks (daily average of Mon-Fri for last 2 weeks)
Weekend | clicks (sum of Sat-Sun for last 2 weeks) | clicks (daily average of Sat-Sun for last 2 weeks)
I’ve tried using calculations but I can’t seem to get it to divide by the right number. I’ve also tried doing a LookML code but am getting stuck.
Because the count of how many weekdays or weekends depend on the filter. If I select last 7 days, then it is counted only once. If I select last 10 days, then I could get 2 Wednesdays, but only 1 Saturday.
Any help would be appreciated.