It is possible to get an alert only when you have hit a new record, a new MAX value within a specific time period?
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
@Maria_Gomez, this is not a feature available in Looker at the moment. I will let our team know that you would like this option implemented.
In the meantime, something similar to this can be achieved in the following way:
there are resultsand
and results changed since last run
This way an email will be sent when the value for the Single Value Visualization changes, this means that it would also send the scheduled item if the results have gone down.
Many thanks Romain!
If you wanted to send out a more elaborate report when a new record is hit, you could set up a persistent derived table in your LookML with a refresh trigger of your record-setting value going up, and an explore on top of that view. Then you could schedule an email distribution (or whatever) when the contents change, which will only happen on the trigger.