Maybe is just impossible but… is possible create an alert and “simulate” with the past data? For example to know how many times would have been raised in the last 6 months.
You might have an easier time answering "how many times did
x occur over
y minutes/days/months using the explore feature.
If you share more details about your datasource and what you are trying to calculate, we might be able to help you write the query