Hi there! I am trying to create a simple report in Insight that would show me website visitors from yesterday - then subscribe to it and get it daily.
The problem I'm running into is there is no way to set "Yesterday" in the visit date filter - it only accepts date values.
I assume there is a way to write "Yesterday" in SQL (i.e. "Today" is "Current_Date") - but don't know how and broke my brain trying to figure it out.
Anyone has a solution? Help is much appreciated!