I’ve created several Looks from a view which is based on a derived table. The Look (without any filters active) will show a handful of records, but I’ve created the Looks with several default filter values such that most of the time, the Look will display ‘No results’ (except when some extreme values are reached, in which case the Look will show a record for the object reaching an extreme value).
These Looks are scheduled every hour, but I’ve selected Send if: there are results and results changed since last run. Hence, it should not send me any e-mails as long as there are no results if I’m correct. However, it does send e-mails every hour, all of the time having a visualisation which says ‘No results’.
See below the scheduling details:
What am I missing here? Why is not working as I’d think it should work?
As additional info, we’re running Looker 4.14. Let me know if you need any more info 🙂