I'm new to Looker, and I'm trying to understand if I can create a simple table to compare yesterday (it was a Wednesday) to the average of the previous 4 or 6 Wednesdays of this year.
I'll try to explain my request better:
we receive daily a certain number of leads, but usually they're not equally distributed during the week, so for instance usually on Monday and Tuesday there are more leads, while on Wednesday it's less, and so on.
So I'd like to have a table with 2 columns: yesterday, and the last n days that are the same day of the week to understand how yesterday went, so I can immediately spot if it's a normal trend or if it'something that is worth more analysis.
Thanks a lot