Alert if sum from prevous day is below a value

Hey everybody,
I’m currently facing the problem that I’m not able to create an alert if the sum of values from yesterday is below a certain value.
The goal is, to sum up, the values from the last day from 00:00:00 to 23:59:59 and give an alert if the value is below a value I defined.
I tried something like it is done in the time picker “now-1d/d,now-1d/d” but that did not work out.
Do you have any ideas or would it be a feature request to consolidate the time range shortcuts?